Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
Foreign Keys Without Indexes: Finding and Fixing Slow Deletes
Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.
Missing Index Query Text: Linking Suggestions to Their Queries
A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries
My friend Jim needed an easy way to find blocking on a live system. Here is how to use Activity Monitor to identify blocking and find expensive queries.
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
The MSDB database is one of the most ignored on any server. Tim shares his tricks to keep the MSDB system database lean, fit and at its best settings.
SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.






