Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jmchristy
Starting Member
8 Posts |
 Posted - 2008-04-04 : 11:57:12
|
| I recently upgraded to a Quad dual core CPU system. I noticed that whenever we run any applications or queries that on the task manager of the server it shows that only 1 processor is being used and it is pegged near 100% utilization. I read up a little bit on using MAXDOP and setting it to 1 or greater depending on the amount of physical CPU's you have. There are mixed reviews on how to set this up and I'd like to hear your guys opinions on it.All of the SQL processing is in house, and serves .NET 1.0, 1.1, and 2.0 applications. How can I get SQL to utilize the other processors?Any feedback is greatly appreciated, thanks! |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-04 : 13:40:46
|
| In EM, right->click the server, select properties and then select the processors tab. What do you see in the processor window, all processors? Is the "Use all Available Processors" radio button selected on that pane or are you limiting it to a set number of processors (like 1)?Terry |
 |
|
|
jmchristy
Starting Member
8 Posts |
Posted - 2008-04-04 : 13:46:15
|
| It is selected to use all available processors. There are a total of 8 processors listed (4 physical Dual core CPU's) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 00:00:08
|
| Sql checks dop settings to decide if need run query in parallel. You have to set dop settings with sp_configure or use maxdop in qeruy based on server load and what the query does. I saw queries ran slower when in parallel. |
|
|
|
jmchristy
Starting Member
8 Posts |
Posted - 2008-04-07 : 07:38:27
|
| Thanks for the responses. Looks like I'll just have to try out different settings, I've read some people have success with setting the MAXDOP to 1 at the server level and adjusting that in the query if necessary. |
|
|
|
|
|
|
SQL 2000 configuration