Post reply

can sql server share its usage load between all processors

  • October 7, 2008 at 11:31 am

    #191897

    Hi Guys,

    Do anyone know how to share the sql server load between all processors, i have 4 processors but sql server uses the 2nd a lot like in 90's and other 3 below 10%. Does any one knows how to load the sql services on all the processors of the server for better performance.

    Thanks

  • October 10, 2008 at 3:01 pm

    #883654

    Sql server on its own balances load by assigning threads to processor with least runnable threads.

    Unless you have some processor affinity set on your server.

  • October 10, 2008 at 3:14 pm

    #883660

    You need to be sure you haven't set the server to not use parallel queries or the threshold is too high. If so, you might see one CPU working hard on a query while the others are relatively idle.

  • October 10, 2008 at 3:56 pm

    #883679

    You maybe also running queries with "MAXDOP=1" and in that case you are out of luck ( unless you fix them )


    * Noel

  • October 10, 2008 at 7:08 pm

    #883706

    Thanks guys, i have seen my sql server properties and checked the processors tab in it. all the 4 processors are selected and i can see like both the other two tabs are also selected about affinity,

    I dont know how is this affinity set and dont know whether this is allready correct or need to change it. If any one can forward a document on it or any snapshots it will be very grateful,

    Thanks to all once again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply