Performance counters missing? Here is why sys.dm_os_performance_counters can return no rows and how to bring the counters back.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL SERVER 2016 – Comparing Execution Plans
A query runs fine in test but slow in production? SQL Server 2016 tools add a way of comparing execution plans so you can find what changed.
SQL SERVER – Save and Send Execution Plan Via Email
A reader wanted to send a big graphical execution plan via email to a friend. Here is a quick step by step way to save it, and what to do if it is over 20 MB.
SQL Server: What to Record Before Tuning a Slow Query
What to record before tuning a slow query starts with the original execution. Keep its SQL, inputs, connection settings, measurements, and plan together before testing a change.
Plan Guides: Fixing a Query You Cannot Change
Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.







