Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: MSSQLTips.com | Category: maxdop
Rating: (not yet rated)  Rate this |   Briefcase | 3,813 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,701 reads
   Items 1 to 2 of 2   
 
Tags
administration (1)    
parallelism (1)