Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag MAXDOP Rss

   Items 1 to 2 of 2   

What MAXDOP Setting Should be Used for SQL Server

I have a busy SQL Server and notice that several queries are running in parallel. I know I can set the max degree of parallelism setting, but what MAXDOP should I use?  Read more...
By Additional Articles 2012/11/28 | Source: | Category: maxdop
Rating: (not yet rated)  Rate this |   Briefcase | 4,018 reads

Configuring the Maximum Degree of Parallelism

How to configure settings to limit the number of processors used in parallel query execution  Read more...
By Additional Articles 2009/04/20 | Source: SQL Server Performance | Category: parallelism
Rating:  Rate this |   Briefcase | 2,799 reads
   Items 1 to 2 of 2   
administration (1)    
parallelism (1)