diagnosticquery/SQLServerDiagnosticQueries_2005.sql

Provides a suite of diagnostic queries for SQL Server 2005 to assist database administrators in monitoring and troubleshooting performance.

-- Source: https://github.com/dataplat/dbatools | License: MIT
-- Provided via justclaw.it.com; keep this notice with the code.

-- SQL Server 2005 Diagnostic Information Queries
-- Glenn Berry 
-- Last Modified: January 1, 2026
-- https://glennsqlperformance.com/
-- https://sqlserverperformance.wordpress.com/
-- YouTube: https://bit.ly/2PkoAM1 
-- Blue Sky: https://bsky.app/profile/glennalanberry.bsky.social

-- Diagnostic Queries are available here
-- https://glennsqlperformance.com/resources/

-- Many of these queries will not work if you have databases in 80 compatibility mode
-- Please make sure you are using the correct version of these diagnostic queries for your version of SQL Server

--******************************************************************************
--*   Copyright (

... (truncated -- full source via MCP)