Copy and paste
DBA Quick Links
The scripts a DBA reaches for most, most used first. Every link lands on the script, ready to copy.
New CU out? Check what you run, then compare.
- SQL Server Builds, the latest CU and GDR for every version, data checked 2026-10-08
- Patch Level, the script that reports your version, CU and build
- Installation and Patching, the pillar for the patching scripts
Showing all 30 scripts
Most Used
Active Sessions and RequestsWhat is running right now, who is blocking whom, wait type, elapsed time and the statementPerformance, jump to the scriptWorker Threads and Active SessionsThread pool in use against the ceiling, with user session and active request countsPerformance, jump to the scriptDatabase Sizes and Free SpaceData and log file sizes with used and free space for every online user databaseStorage, jump to the scriptDatabase Free Space SummaryTightest database first, with the files that cannot grow any furtherStorage, jump to the scriptDisk SpaceFree and used space per volume that hosts database files, from T-SQLStorage, jump to the scriptUser Permissions AuditOne login’s effective access across the instance, nested AD groups includedSecurity, jump to the scriptPatch LevelVersion, CU level, edition and build number, to check against the builds pageServer & Config, jump to the script
Also Daily
Blocking ChainsEvery session in every blocking chain, head blocker first, idle blockers includedPerformance, jump to the scriptWait StatisticsTop actionable waits since the last restartPerformance, jump to the scriptLong-Running QueriesActive requests ordered by elapsed timePerformance, jump to the scriptTop CPU QueriesTop 20 CPU-consuming queries with execution countsPerformance, jump to the scriptOpen TransactionsOpen transactions with age and the SQL behind themPerformance, jump to the scriptTransaction Log Size and UsageLog size, used, free and percent used per databaseStorage, jump to the scriptLog Reuse WaitsWhy each log cannot truncate, with the last log backupStorage, jump to the scriptTempDB Usage and File BalanceTempDB file sizes, free space and allocation per fileStorage, jump to the scriptDatabase Backup HistoryBackup history for every database over the last two monthsBackups, jump to the scriptBackup CoverageBackup coverage per database with a status flagBackups, jump to the scriptBackup and Restore ProgressPercent complete and estimated finish for a running backup or restoreBackups, jump to the scriptRecent Error Log EntriesThe last 24 hours of the error log with the routine noise filteredServer & Config, jump to the scriptSQL Agent Job Failure SummaryJob failures from the last 7 days with the error messagesMaintenance, jump to the scriptOS and Hardware InfoOS version, CPU, RAM and SQL Server uptime in one rowServer & Config, jump to the scriptMemory Configuration and UsageConfigured memory limits against current consumptionServer & Config, jump to the scriptServices InformationService startup type, status and service account, with risk flagsServer & Config, jump to the scriptPermissions and Role MembershipExplicit GRANT and DENY in the current databaseSecurity, jump to the scriptSysadmin MembersWho is in the sysadmin roleSecurity, jump to the scriptFix Orphaned UsersALTER USER statements to re-map users after a restoreSecurity, jump to the scriptVLF CountsVLF count per transaction logStorage, jump to the scriptMissing IndexesMissing index candidates ranked by impactPerformance, jump to the scriptIndex FragmentationThe most fragmented indexes across user databasesMaintenance, jump to the scriptDatabase InventoryCompatibility level, recovery model and state per databaseServer & Config, jump to the script
Nothing matches. Try the full Script Finder, it covers every script.