Recently I completed a migration of a SQL Server (2008 R2) onto some new hardware for a client, the SAN storage was retained as is, while the actual server was upgraded to a blade holding 64Gigs of memory and 4 of AMD`s Opteron 6276 CPU`s. Upon logging on to the server I noticed 64 processors available to the OS and SQL – 64!
Showing posts with label MAXDOP. Show all posts
Showing posts with label MAXDOP. Show all posts
Tuesday, June 19, 2012
Getting to the CORE of the problem
Recently I completed a migration of a SQL Server (2008 R2) onto some new hardware for a client, the SAN storage was retained as is, while the actual server was upgraded to a blade holding 64Gigs of memory and 4 of AMD`s Opteron 6276 CPU`s. Upon logging on to the server I noticed 64 processors available to the OS and SQL – 64!
Subscribe to:
Posts (Atom)