Sql performance and available cpu's

Published 2 February 5 3:0 PM | Ramon Smits
This is really a very good post about sql server's performance. I didn't realy knew why I had this behaviour a while back. I though the servers load wasn't high enough. Didn't really think of this IO optimization. SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors. This immediately reminds me not to think I know a lot about sql server.

Comments

# Ramon Smits said on February 3, 2005 8:19 AM:

We had a situation like this.... and one processor would be up to 100% all the time....

It became clear that parallel execution of the query caused the problem. It would give a TempDB error message and from then on the thread would push the processor to 100 %

after disabeling parallel execution (setting query cost to 99999) plans this problem has gone away as wel as the tempDB errors.....