Tag: Performance

  • DBA Scripts: Get Duplicate Indexes

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Index Maintenance Indexes accumulate the same way clutter does: one developer adds an index to fix a slow query, a colleague adds a near-identical one three months later because the first one wasn’t obvious from the name, and nobody…

    Written by

    Peter Whyte

  • DBA Scripts: Get Statistics Health

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning Query plans are only as good as the statistics SQL Server uses to build them. When a table’s data distribution changes but its statistics don’t get refreshed to match, the optimizer keeps making decisions based…

    Written by

    Peter Whyte

  • DBA Scripts: Get Unused Indexes

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Index Maintenance Every non-clustered index has to be maintained by SQL Server on every INSERT, UPDATE, and DELETE against the table. A table with 12 non-clustered indexes means 12 index updates for every row changed. Some of those indexes…

    Written by

    Peter Whyte

  • DBA Scripts: Get Deadlock Summary

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Blocking & Locking A deadlock is SQL Server’s way of resolving a situation it can’t otherwise escape: two transactions each holding a lock the other one needs, waiting on each other forever unless something intervenes. SQL Server intervenes automatically,…

    Written by

    Peter Whyte

  • DBA Scripts: Get Blocking Chains

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Blocking & Locking A single blocked session is usually easy to spot. The harder case is a chain: session C is waiting on session B, which is itself waiting on session A, which is sitting idle holding a lock…

    Written by

    Peter Whyte

  • DBA Scripts: Get Query Store Regressions and Forced Plans

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning “What Changed Today” and “Is the Plan I Forced Still Any Good” Query Store Top Queries tells you what’s expensive right now. This post covers two narrower, sharper questions that come up once Query Store…

    Written by

    Peter Whyte

  • DBA Scripts: Get Index Usage Stats

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Index Maintenance The Raw Usage Data Behind Every Index Decision Unused Indexes already filters straight to drop candidates in one database. This script is the raw data underneath that filter, and more: every index across every user database, its…

    Written by

    Peter Whyte

  • DBA Scripts: Get Query Performance Deep-Dive

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning Four Angles on “Why Is This Slow” That Go Beyond Top CPU Top CPU Queries ranks by raw resource consumption. These four scripts answer more specific questions the ranking alone can’t: Get-StoredProcedurePerformance ranks stored procedures…

    Written by

    Peter Whyte

  • DBA Scripts: Get Active Sessions and Requests

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting Who’s Connected, and What’s Actually Running Right Now Worker Threads and Active Sessions gives you the aggregate health number: how close the worker thread pool is to exhaustion. These three scripts give you the per-session detail underneath that number. Get-ActiveSessions…

    Written by

    Peter Whyte

  • DBA Scripts: Get Top CPU Queries

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning Three Different Ways a Query Can Be the Problem “Which query is causing this” has more than one right answer, because a query can be expensive in different ways: it can burn CPU, it can…

    Written by

    Peter Whyte
Major pillars
DBA Scripts180+ scripts, one page each SSMS Complete GuideInstall, shortcuts, git, Copilot, dark mode Error LibraryLook up an exact message, cause and fix Wait Types LibraryWhat the server was waiting on
Find a script
Find a ScriptSearch by name, or browse every script page DBA Scripts: The Complete GuideHow the series works, read end to end
Health check & tooling
Full Health CheckCollect 45 diagnostics, apply rules, then an AI assessment sqldba MCP ServerGive an AI assistant a verified SQL Server reference
Script areas
Server & Configuration Storage & Capacity Backup & Recovery High Availability Performance & Troubleshooting Security Maintenance & Automation Migration & Deployment
Latest posts
Browse by topic