Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
Finding Dead Code: Stored Procedures Nobody Calls
Investigate dead code with cached procedure statistics, dependency checks and retained snapshots, then quarantine candidates before removal.
SQL Server Scheduler and Operating System Scheduling: Notes
The SQL Server scheduler decides which ready work gets processor time, on top of the operating system’s own thread scheduling. Tested queries on SQL Server 2025 show runnable, running and suspended tasks under load, and the permission each view needs.
SQL SERVER – Identify Time Between Backups Calculation
A DBA whose latest tape backup was corrupt wanted to know the possible data loss. This script uses backup history to calculate the time between backups.
SQL SERVER – Knowing Which Database is Consuming My Memory
Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.
SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds
Seeing ‘I/O requests taking longer than 15 seconds’ in the ERRORLOG? Here is what this common warning means and where to look for the slow disk behind it.
How to Identify Cross-Database Transactions in SQL Server
To find cross-database transactions, search the code for references to other databases, watch a live transaction with a DMV, or read special records in the transaction log. This post tests all three on two demo databases. It also shows why a popular log script flags a brand new database.