OS

Get-DbaWindowsLog

Drew Furgiuele | Friedrich Weinmann (@FredWeinmann)

Get-DbaWindowsLog View Source Drew Furgiuele , Friedrich Weinmann (@FredWeinmann) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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

Chrissy LeMaire (@cl), netnerds.net

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.

Show-DbaInstanceFileSystem

Chrissy LeMaire (@cl), netnerds.net

Show-DbaInstanceFileSystem View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Test-DbaDiskAlignment

Constantine Kokkinos (@mobileck), constantinekokkinos.com

Test-DbaDiskAlignment View Source Constantine Kokkinos (@mobileck), constantinekokkinos.com Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Test-DbaDiskAllocation

Chrissy LeMaire (@cl), netnerds.net

Test-DbaDiskAllocation View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Test-DbaInstantFileInitialization

the dbatools team + Claude

Test-DbaInstantFileInitialization View Source the dbatools team + Claude Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Tests whether Instant File Initialization (IFI) is properly configured for SQL Server Engine service accounts. Description Audits Instant File Initialization (IFI) configuration for all SQL Server Engine services on the specified computer(s). IFI allows SQL Server to skip zeroing out data file space during file creation and auto-growth operations, which can dramatically speed up database creation, restore operations, and auto-growth events.

Test-DbaPowerPlan

Chrissy LeMaire (@cl), netnerds.net

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.

← Previous

1 2

Page 2 of 2