Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.
SQL SERVER – List the Name of the Months Between Date Ranges – Part 2
Part 2 on listing the names of the months between date ranges, with an improved script from readers Miladin Joksic and Peter Lalovsky that adds more details.
SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058
SQL Server 2012 added the SSIS Catalog to store, run and log packages in one place. In Notes from the Field #058, Tim Mitchell shows how to set it up.
Is It the Database? Reading ASYNC_NETWORK_IO
Investigate ASYNC_NETWORK_IO with request and task evidence, check client consumption, and separate large outputs from network faults.
Reading a Workload Capture Without a Tool
Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.
Hey DBA – Baselines and Performance Monitoring – Why? – Notes from the Field #058
Mike Walsh explains why baselines and performance monitoring matter for every DBA, and how to know what normal looks like on your servers.