Export-DbaDiagnosticQuery View Source Andre Kamman (@AndreKamman), clouddba.io Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 .
Get-DbaMaintenanceSolutionLog View Source Klaas Vandenberghe (@powerdbaklaas) , Simone Bizzotto (@niphlod) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Install-DbaMultiTool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Install-DbaSqlWatch View Source Ken K (github.com/koglerk) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Install-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Invoke-DbaDiagnosticQuery View Source Andre Kamman (@AndreKamman), andrekamman.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Invoke-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
dbatools