Database Resources

The most comprehensive and widely-used SQL Server maintenance solution. Includes scripts for database backups, integrity checks, and index/statistics maintenance. Used by thousands of DBAs worldwide.

The definitive stored procedure for monitoring active SQL Server sessions. Shows what's running, who's blocking whom, and detailed query information. An essential tool for every DBA's toolkit.

A comprehensive suite of scripts for SQL Server health checks, query analysis, and index tuning. sp_Blitz rapidly assesses configuration, security, and performance issues with prioritized recommendations.

A comprehensive set of diagnostic queries that provide deep insights into SQL Server configuration, performance, and health. Includes version-specific scripts from SQL Server 2005 through 2025.

Quickly identify CPU and memory pressure on your SQL Server. For CPU, it analyzes worker thread usage and THREADPOOL waits. For RAM, it shows what's available, in use, and allocation by buffer pool or query memory grants.

The fastest and most configurable way to navigate Query Store data. Drill into query performance metrics beyond what the GUI provides, with flexible filtering and sorting options.

A powerful PostgreSQL log analyzer that produces detailed statistical reports from log files. Generates beautiful HTML reports with query analysis, performance metrics, and optimization recommendations.

Essential PostgreSQL extension for tracking query execution statistics. Capture detailed metrics on query performance, execution counts, and resource consumption for optimization insights.

Online tool that generates optimal PostgreSQL configuration parameters based on your hardware specifications and workload type. Perfect starting point for performance tuning.

The most popular MySQL performance tuning script. Analyzes server statistics and configuration to provide optimization recommendations for improved database performance.

Comprehensive collection of advanced command-line tools for MySQL/MariaDB. Includes pt-query-digest for slow query analysis, pt-online-schema-change for zero-downtime migrations, and more.

Oracle's official GUI tool for MySQL. Includes performance dashboard, visual explain, query profiler, and server status monitoring. Essential for visual database administration.