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 |
|
JohnDeere
Posting Yak Master
191 Posts |
 Posted - 2010-01-09 : 11:19:08
|
| We recently replaced a dual proc server running Win2003, Sql2000 with 4gb of Ram. To a dual proc, quad core, 2 hardware Numa node server running Win2008R2, SQL2008 Std ed with 18 GB RAM.This server is used to perform DBCC checkdb.We did not see any performance improvement.We ran the DBCC on 2 other servers and got the results listed below.Server #0 win2003 SQL2000 ent 4 GB Ram dual proc 1core Box to old for numaServer #1 Win2008R2 SQL2008 Std 18 GB RAM dual proc 4core 2 hardware Numa nodesServer #2 Win2008 SQL2008 Dev 16 GB Ram quad proc 4core 1 hardware Numa nodesServer #3 Win2008R2 SQL2008 Dev 4 GB Ram dual proc 1core Box to old for numaAll Servers have the same windows and sql service packs applied.All servers are using EMC cx700's for storage.Server Dbcc Time Parallelism#0 6 hours #1 6 hours Sysprocesses 1 row for the DBCC spid#2 2 hours Sysprocesses 14 to 16 rows for the DBCC spid#3 6 hours Sysprocesses 5 rows for the DBCC spidI can't figure out why the new server (#1) will not generate any parallel tasks.MaxDOP is the same on all the servers.We have run several other tasks that will generate parallel tasks on the other servers but not on Server #1.I am not sure what else to check at this point.Thanks for any help.Lance Harra |
|
|
|
|
|
SQL 2008 no parallel tasks