Scripts for querying database metadata, configuration, and object information.
Identifies databases with non-standard settings (auto_close on, auto_shrink on, or auto_update_stats off) that may indicate configuration issues.
Lists the server default collation and all database collations to identify databases with non-standard collation settings.
Shows common database configuration settings like recovery model, containment, compatibility level, page verification, auto statistics, parameterization, isolation levels, and delayed durability.
Reports compatibility level for each database and the server version to help identify version mismatches and upgrade readiness.
Analyzes heap table fragmentation including ghost records, forwarded records, and fragmentation percentage to identify maintenance needs.
Shows objects modified in the last week to track recent schema changes and code deployments.
Lists stored procedures sorted by modification date to identify recently updated or deployed stored procedures.
Displays all user databases with detailed status information including owner, compatibility level, recovery model, replication settings, and various database options.
Counts objects by type in the current database to provide an overview of database structure and object inventory.
Lists all schemas and their owners, useful for identifying schemas owned by non-dbo users which may indicate security or maintenance issues.
📝 synonyms
Lists all synonyms in the current database with their base object names for understanding synonym usage and dependencies.
Scripts for analyzing stored procedures, functions, and triggers.
Columnstore index diagnostics.
Data compression analysis and estimation.
📁 indexes
Index metadata and analysis.
In-Memory OLTP diagnostics.
📁 ledger
SQL Server 2022 Ledger table metadata.
Database size, file, and allocation analysis.
Column and index statistics analysis.
Table metadata and structure analysis.
Transaction log analysis.