Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.
Consulting 101 – Why Do I Never Take Control of Computers Remotely?
I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.
Wide Update Plans: What Every Extra Index Costs a Write
Inspect wide update plans, compare index-maintenance work with narrow updates, and read per-index counters without misreading STATISTICS IO.
Watching Many Servers Without Buying Anything
Use scheduled snapshots to monitor SQL Server with central storage, failure reporting, and four focused queries collected every five minutes.
SQL SERVER – Default Worker Threads Per Number of CPUs
During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads.
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
A client wanted to undo the damage from Database Engine Tuning Advisor. Here is how to drop all the hypothetical indexes of a database that DTA left behind.
Eager Index Spool: When the Plan Builds Its Own Index
Investigate an eager index spool, read seek keys and output, and compare a supporting index with the cost of rebuilding temporary storage.