Short answers to the questions that come up every morning — what changed, what broke, and what to do next.
Overnight slowdowns usually come from maintenance, ETL or growth colliding in the same window. Here is how to work out which one.
2 min read
Wait statistics narrow a slow server down to a handful of causes. Here is how to filter the noise and read the top of the list.
Blocking and deadlocks look similar and are fixed differently. Here is the order to investigate them in.
1 min read
High memory usage on a SQL Server is normal. These are the settings and signals that actually matter.
Fragmentation percentage is the least useful number in maintenance. Here is what to check instead.
The short list of checks that tells you whether the night was fine before anyone asks.
When something is different today, the answer is almost always a change. Here is where to look.
A backup job saying 'succeeded' is not proof you can recover. Here is the short list that is.
Disk-full outages are predictable. Here is how to see them coming weeks ahead.
Monitoring does not need sysadmin. Here is the least-privilege account that is enough, and why it matters.