GlennBerry

Export-DbaDiagnosticQuery

Andre Kamman (@AndreKamman), clouddba.io

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.

Invoke-DbaDiagnosticQuery

Andre Kamman (@AndreKamman), andrekamman.com

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.

New-DbaDiagnosticAdsNotebook

Gianluca Sartori (@spaghettidba)

New-DbaDiagnosticAdsNotebook View Source Gianluca Sartori (@spaghettidba) Windows, Linux, macOS Synopsis Generates a Jupyter Notebook containing Glenn Berry’s SQL Server diagnostic queries for Azure Data Studio Description Converts Glenn Berry’s well-known SQL Server diagnostic queries into a Jupyter Notebook (.ipynb) file that can be opened and executed in Azure Data Studio. The function automatically detects your SQL Server version or accepts a target version parameter, then creates a notebook with version-specific diagnostic queries formatted as executable cells.

Save-DbaDiagnosticQueryScript

Andre Kamman (@AndreKamman), andrekamman.com

Save-DbaDiagnosticQueryScript View Source Andre Kamman (@AndreKamman), andrekamman.com Windows, Linux, macOS Synopsis Downloads Glenn Berry’s SQL Server Diagnostic Information Queries for performance monitoring and troubleshooting Description Downloads the latest versions of Glenn Berry’s renowned SQL Server Diagnostic Information Queries from his website. These DMV-based scripts are essential tools for DBAs to assess SQL Server health, identify performance bottlenecks, and gather comprehensive system information across all SQL Server versions including Azure SQL Database and Managed Instance.