I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.
Plan Cache Size in SQL Server: List Every Cached Plan
Plan cache size shows how much memory each cached query plan takes. This post lists every plan in one database with its size, its text and its execution count. It also explains why the cache entry and the plan itself report different sizes.
How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216
How do you know when memory constraints are hurting CPU in SQL Server? Someone asked me this loaded question before a Health Check, and here is my answer.
SQL SERVER – Default Worker Threads Per Number of CPUs
The default Worker Threads limit depends on SQL Server version, logical CPUs and memory. A workshop reader asked about automatic configuration.
Index Key Columns and Included Columns in SQL Server
Index key columns and included columns show what each index really stores. This post builds one query that lists them for every index, then a second query that finds indexes with the same keys or a shared leading key. It ends with the rules for merging them safely.
Finding Edition-Bound Features With sys.dm_db_persisted_sku_features
Use sys.dm_db_persisted_sku_features before an edition move, inventory databases, and distinguish feature evidence from licensing checks.
Reduce IO Waits in SQL Server: Read the Waits First
To reduce IO waits in SQL Server, first name the wait. This post explains the main IO wait types and measures two of them for a single session on a demo database. It then shows how to check file latency and which fix matches each wait.