Drew Furgiuele | Friedrich Weinmann (@FredWeinmann)
Get-DbaWindowsLog View Source Drew Furgiuele , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Retrieves and parses SQL Server error log entries from the file system for analysis and troubleshooting
Description Parses SQL Server error log files directly from the file system to extract structured error information including timestamps, SPIDs, error numbers, severity levels, and messages. Locates error log files by querying Windows Application Event Log for SQL Server startup events (Event ID 17111), then reads and parses the raw log files to provide searchable, filterable results.
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.
Show-DbaInstanceFileSystem View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Displays a GUI tree view for browsing remote SQL Server file systems and returns the selected directory path
Description Similar to the remote file system popup you see when browsing a remote SQL Server in SQL Server Management Studio, this function allows you to traverse the remote SQL Server’s file structure. This replaces the need to manually type or guess directory paths when setting up backup locations, restore operations, or specifying data and log file paths.
Test-DbaDiskAlignment View Source Constantine Kokkinos (@mobileck), constantinekokkinos.com Windows, Linux, macOS Synopsis Tests disk partition alignment to identify I/O performance issues that can impact SQL Server.
Description Tests disk partition alignment by checking if partition starting offsets align properly with common stripe unit sizes (64KB, 128KB, 256KB, 512KB, 1024KB). Misaligned disk partitions can cause significant SQL Server I/O performance degradation, particularly on high-transaction systems.
The function connects to Windows computers via CIM and examines each disk partition’s starting offset.
Test-DbaDiskAllocation View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Validates disk allocation unit sizes against SQL Server best practice recommendations.
Description Examines all NTFS volumes on target servers to verify they are formatted with 64KB allocation units, which is the recommended cluster size for optimal SQL Server performance. When checking a single server, returns a simple true/false result. For multiple servers, returns detailed information including server name, disk details, and compliance status for each volume.
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.
dbatools