Set-DbaMaxDop View Source Claudio Silva (@claudioessilva) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Configures SQL Server maximum degree of parallelism (MaxDOP) at instance or database level
Description Configures the max degree of parallelism setting to control how many processors SQL Server uses for parallel query execution. Without a specified value, the function automatically applies recommended settings based on your server’s hardware configuration using Test-DbaMaxDop.
Set-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)
Test-DbaBuild View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Test-DbaInstanceName View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Test-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)
Update-DbaBuildReference View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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