Tuesday, November 14, 2017

 

SQL Server: A more useful CXPacket Waits...

Starting with the upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2 releases, CXPACKET waits are split into an actionable wait (CXPACKET) and a negligible wait (CXCONSUMER). 

(these wait types are already present in Azure SQL Database).

Making parallelism waits actionable



Wednesday, November 01, 2017

 

SQL Server Trace Flags

Microsoft have published a useful list of all SQL Server trace flags in a single location: 
   
DBCC TRACEON - Trace Flags

In the past, some of these were poorly documented or hard to find.


    

Powered by Blogger