Export-DbaDiagnosticQuery View Source Andre Kamman (@AndreKamman), clouddba.io Windows, Linux, macOS Synopsis Converts diagnostic query results from Invoke-DbaDiagnosticQuery into CSV or Excel files
Description Processes the PowerShell objects returned by Glenn Berry’s diagnostic queries and saves them as CSV files or Excel worksheets for analysis, reporting, and sharing with vendors.
Automatically extracts execution plans as separate .sqlplan files and query text as .sql files, which can be opened directly in SQL Server Management Studio.
Get-DbaMaintenanceSolutionLog View Source Klaas Vandenberghe (@powerdbaklaas) , Simone Bizzotto (@niphlod) Windows, Linux, macOS Synopsis Parses IndexOptimize text log files from Ola Hallengren’s MaintenanceSolution when database logging is disabled.
Description Retrieves detailed execution information from IndexOptimize text log files when LogToTable=‘N’ is configured in Ola Hallengren’s MaintenanceSolution. This function parses the text files written to the SQL Server instance’s log directory, extracting index operation details including start times, duration, fragmentation levels, and any errors encountered.
Install-DbaDarlingData View Source Ant Green (@ant_green) Windows, Linux, macOS Synopsis Downloads and installs Erik Darling’s performance monitoring stored procedures
Description Downloads, extracts and installs Erik Darling’s collection of performance monitoring stored procedures from the DarlingData GitHub repository. This gives you access to popular diagnostic tools like sp_HumanEvents for extended events analysis, sp_PressureDetector for memory pressure monitoring, sp_QuickieStore for Query Store analysis, and several others that help with SQL Server performance troubleshooting.
Install-DbaFirstResponderKit View Source Tara Kizer, Brent Ozar Unlimited (brentozar.com) Windows, Linux, macOS Synopsis Downloads and installs Brent Ozar’s First Responder Kit diagnostic stored procedures.
Description Downloads and installs the First Responder Kit (FRK), a collection of stored procedures designed for SQL Server health checks, performance analysis, and troubleshooting. The FRK includes essential procedures like sp_Blitz for overall health assessment, sp_BlitzCache for query performance analysis, sp_BlitzIndex for index recommendations, and sp_BlitzFirst for real-time performance monitoring.
Install-DbaMaintenanceSolution View Source Viorel Ciucu, cviorel.com Windows, Linux, macOS Synopsis Installs Ola Hallengren’s Maintenance Solution stored procedures and optional SQL Agent jobs for automated database maintenance
Description Deploys Ola Hallengren’s comprehensive maintenance framework including DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize, and CommandExecute stored procedures to automate backup, DBCC checks, and index maintenance tasks. Optionally creates pre-configured SQL Agent jobs with intelligent scheduling for daily, weekly, and log backup routines. Replaces manual maintenance scripting with industry-standard procedures used by thousands of SQL Server environments worldwide.
Install-DbaMultiTool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Installs five essential T-SQL stored procedures for database documentation, index optimization, and administrative tasks.
Description Downloads and installs the DBA MultiTool collection of T-SQL stored procedures into a specified database. This toolkit provides five key utilities that help DBAs with common documentation and optimization tasks that would otherwise require manual T-SQL scripting.
The installed procedures include:
• sp_helpme - Enhanced version of sp_help that provides detailed object information
Install-DbaSqlWatch View Source Ken K (github.com/koglerk) Windows, Linux, macOS Synopsis Installs or updates SqlWatch monitoring solution on SQL Server instances.
Description Deploys SqlWatch, an open-source SQL Server monitoring and performance collection tool, to one or more SQL Server instances. SqlWatch continuously gathers performance metrics, wait statistics, and system information into dedicated tables for historical analysis and alerting.
This function automatically downloads the latest SqlWatch release from GitHub (or uses a local file), then deploys it to the specified database using DACPAC technology.
Install-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Downloads and installs sp_WhoIsActive stored procedure for real-time SQL Server session monitoring
Description Installs Adam Machanic’s sp_WhoIsActive stored procedure, the most widely-used tool for monitoring active SQL Server sessions in real-time. This procedure provides detailed information about currently running queries, blocking chains, wait statistics, and resource consumption without the overhead of SQL Server Profiler.
The function automatically downloads the latest version from GitHub or uses a local file you specify.
Invoke-DbaDiagnosticQuery View Source Andre Kamman (@AndreKamman), andrekamman.com Windows, Linux, macOS Synopsis Executes Glenn Berry’s DMV diagnostic queries to assess SQL Server performance and health
Description Runs Glenn Berry’s comprehensive collection of DMV-based diagnostic queries to analyze SQL Server performance, configuration, and health issues. These queries help identify common problems like blocking, high CPU usage, memory pressure, index fragmentation, and configuration issues that affect SQL Server performance.
The diagnostic queries are developed and maintained by Glenn Berry and can be found at https://glennsqlperformance.
Invoke-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves real-time information about active SQL Server sessions and currently running queries
Description Executes Adam Machanic’s sp_WhoIsActive stored procedure to display detailed information about currently running sessions, active queries, and their resource consumption. This is the go-to command for troubleshooting performance issues, identifying blocking chains, and monitoring SQL Server activity in real-time. Provides comprehensive session details including wait statistics, query plans, lock information, and transaction details that would otherwise require querying multiple DMVs manually.
dbatools