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

Content with tag Trace Flag Rss

   Items 1 to 3 of 3   
 

Testing SQL Server Backup Performance with Trace Flag 3042

Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.  Read more...
By Additional Articles 2015/05/19 | Source: MSSQLTips.com | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 3,195 reads

Next-Level Parallel Plan Forcing: An Alternative to 8649

The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.  Read more...
By Additional Articles 2013/12/23 | Source: SQL Blog | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 1,868 reads

Trace flag in deadlock

By Sumanta Roy 2011/09/15 | Category: trace flag
Rating: (not yet rated) |  Discuss |   Briefcase | 1,908 reads
   Items 1 to 3 of 3   
 
Tags
administration (1)    
performance (1)