MaximT
SSC Journeyman
Points: 98
More actions
March 1, 2005 at 3:34 pm
#163744
Most querries on my server normally take 40% CPU, but some take it all. Can I somehow limit a number of processors to a particular querry, so it wouldn't take all CPU. I don't care how long it runs, I just want it not to use all processors.
Antares686
SSC Guru
Points: 125444
March 2, 2005 at 7:12 am
#544863
Look at MAXDOP in BOL.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply