Set-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Configures Windows power plan on SQL Server host computers to optimize database performance.
Description Changes the Windows power plan on SQL Server host machines using WMI and PowerShell remoting. Defaults to High Performance, which prevents CPU throttling that can severely impact database query performance and response times.
Windows power plans control CPU frequency scaling, and the default “Balanced” plan can cause significant performance degradation under SQL Server workloads.
Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)
Test-DbaBuild View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Tests SQL Server build versions against patching compliance requirements
Description Evaluates SQL Server instances or build versions against organizational patching policies to determine compliance status. Returns detailed build information including service pack level, cumulative update, reference KB, and end-of-support dates with a compliance flag. Helps DBAs audit patch levels across environments and identify instances that fall below minimum security or stability requirements.
Test-DbaInstanceName View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Validates SQL Server instance name consistency with the host OS and identifies rename requirements and potential blockers.
Description When a SQL Server’s host OS is renamed, the SQL Server should be as well. This helps with Availability Groups and Kerberos.
This command compares the SQL Server instance name (from @@servername) with the actual hostname and instance combination to determine if they match.
Test-DbaMaxDop View Source Claudio Silva (@claudioessilva) Windows, Linux, macOS Synopsis Tests SQL Server MAXDOP configuration against recommended values based on CPU cores and NUMA topology.
Description Analyzes your SQL Server’s Max Degree of Parallelism (MAXDOP) settings and compares them against Microsoft’s recommended values based on your server’s hardware configuration. This function examines CPU cores, NUMA topology, and SQL Server version to calculate optimal MAXDOP settings for query performance.
The function helps you identify instances where MAXDOP may be misconfigured, which can lead to poor query performance, excessive parallelism overhead, or CXPACKET waits.
Test-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Tests Windows Power Plan settings against SQL Server best practices and identifies non-compliant systems.
Description Audits Windows Power Plan settings on SQL Server hosts to ensure compliance with Microsoft’s performance recommendations. SQL Server runs optimally with the “High Performance” power plan, which prevents CPU throttling and ensures consistent performance under load.
This function compares the currently active power plan against the recommended “High Performance” plan (or a custom plan you specify) and returns a compliance report.
Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)
Update-DbaBuildReference View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Downloads the latest SQL Server build reference database used for patch compliance and version tracking
Description Refreshes the comprehensive SQL Server build reference database that powers Get-DbaBuild and Test-DbaBuild functions with current patch level information. This database contains detailed mappings between build numbers, service packs, cumulative updates, KB articles, release dates, and support lifecycle dates for all SQL Server versions.
dbatools