Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag parallelism Rss

   Items 1 to 4 of 4   
 

Maximum degree of Parallelism

By Kwex 2011/10/19 | Category: parallelism
Rating: (not yet rated) |  Discuss |   Briefcase | 1,729 reads

Understanding and Using Parallelism in SQL Server

SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.  Read more...
By Additional Articles 2011/03/08 | Source: SimpleTalk | Category: parallelism
Rating:  Rate this |   Briefcase | 4,358 reads

Is hyper-threading still relevant for SQL Server?

There still seems to be a lot of fear, uncertainty and doubt, in the community, with regard to use of Hyper-threading (HT) with SQL Server workloads. So, how and when should it be used?   Read more...
By Tony Davis 2011/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 351 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,629 reads
   Items 1 to 4 of 4   
 
Tags
administration (1)    
database weekly (1)    
editorial (1)    
maxdop (1)