Utility

Set-DbaPowerPlan

Chrissy LeMaire (@cl), netnerds.net

Set-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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.

Test-DbaBuild

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

Chrissy LeMaire (@cl), netnerds.net

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

Claudio Silva (@claudioessilva)

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

Chrissy LeMaire (@cl), netnerds.net

Test-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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.

Update-DbaBuildReference

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.

← Previous

1 2 3

Page 3 of 3