PerfMon

Add-DbaPfDataCollectorCounter

Chrissy LeMaire (@cl), netnerds.net

Add-DbaPfDataCollectorCounter View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Adds performance counters to existing Windows Performance Monitor Data Collector Sets for SQL Server monitoring. Description Adds specific performance counters to existing Data Collector Sets within Windows Performance Monitor. This allows DBAs to customize their performance monitoring by adding SQL Server-specific counters like disk queue length, processor time, or SQL Server object counters to existing collection sets.

Remove-DbaPfDataCollectorCounter

Chrissy LeMaire (@cl), netnerds.net

Remove-DbaPfDataCollectorCounter View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes specific performance counters from Windows Performance Monitor Data Collector Sets. Description Removes performance counters from existing Data Collector Sets in Windows Performance Monitor. This allows you to clean up monitoring configurations by removing counters that are no longer needed, reducing resource consumption and focusing on relevant metrics.

Remove-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Remove-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes Windows Performance Monitor Data Collector Sets from local or remote computers Description Removes Windows Performance Monitor Data Collector Sets that are no longer needed for SQL Server performance monitoring. This is useful for cleaning up old monitoring configurations, freeing disk space, or standardizing performance monitoring setups across your SQL Server environment.

Start-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Start-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Starts Windows Performance Monitor Data Collector Sets on local or remote computers. Description Starts Performance Monitor Data Collector Sets that have been configured to gather system performance data. This is useful for SQL Server performance troubleshooting when you need to collect OS-level metrics like CPU, memory, disk I/O, and network statistics alongside your SQL Server monitoring.

Stop-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Stop-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Stops Windows Performance Monitor Data Collector Sets used for SQL Server performance monitoring. Description Stops running Performance Monitor Data Collector Sets that are actively collecting performance counters for SQL Server monitoring and analysis. This function interacts with the Windows Performance Logs and Alerts (PLA) service to gracefully halt data collection processes.