PerfMon

Add-DbaPfDataCollectorCounter

Chrissy LeMaire (@cl), netnerds.net

Add-DbaPfDataCollectorCounter View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. The function modifies the Data Collector Set configuration and immediately applies the changes, so you can start collecting the additional performance metrics without recreating your monitoring setup.

Remove-DbaPfDataCollectorCounter

Chrissy LeMaire (@cl), netnerds.net

Remove-DbaPfDataCollectorCounter View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. Commonly used when fine-tuning SQL Server performance monitoring setups or removing counters that were added for troubleshooting specific issues.

Remove-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Remove-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. The collector set must be stopped before removal - running collector sets will generate an error and must be stopped first using Stop-DbaPfDataCollectorSet.

Start-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Start-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. The function checks the collector set status before starting and will skip sets that are already running or disabled.

Stop-DbaPfDataCollectorSet

Chrissy LeMaire (@cl), netnerds.net

Stop-DbaPfDataCollectorSet View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. Commonly used to stop baseline data collection after capturing sufficient performance metrics, or to halt monitoring during maintenance windows when counter data isn’t needed.