Max Degree of parallellism
-
Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?
-
lianvh (9/11/2012)
Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?Is your SQL Server a Virtual Server?
-
Yes, they are
-
Tell them that's the biggest load of hogswash you've heard and they should kindly update their 'best practices' from ones used 10 years ago. 🙂
Seriously though, no, that's not a good recommendation (neither's the other one that you mentioned here). It used to be 'recommended' some years back, but it wasn't the best even then.
It's touched on in this article and there are links to further details https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
lianvh (9/11/2012)
Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?Just this? Thanks God, they didn't ask you to migrate to MS Access...
It's like renting the Ferrari with limiting yourself to 40 miles per hour on motorways.
That would really impress girls ...
:hehe:
-
Yes, you can say that again
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply