Processor Use

[scotward]

Our server has 4 processors. Long running queries will use all of them until they finish, effectively preventing other users from retrieving data during that time. Is there any way to configure SQL Server 2000 to restrict processor usage?

 

[Skiboy]

Hi Scotty,

The cardinal rule of configuring a SQL server is that with datafiles and log files.. 'never the twain shall meet'. Put them on separate disk drives for max performance.

Also, consider creating separate file groups and placing them on different drives if you are still having problems.

For more info on the above have a look at books on line, or microsofts technet site. it has how to's on nearly everything

 

[Corran007]

on the server properties, there is one under processor for parallesim that says how many to use for paralle execution of quries. try chaning it to 3 or maybe two and then try it.

see if that works any