Export-DbaPfDataCollectorSetTemplate

Synopsis

Exports Windows Performance Monitor Data Collector Set configurations as reusable XML templates.

Description

Exports Data Collector Set configurations from Windows Performance Monitor as XML template files that can be imported on other SQL Server hosts. This allows you to standardize performance monitoring across your SQL Server environment by saving custom counter collections, sampling intervals, and output settings as portable templates. Particularly useful for creating consistent performance baselines and troubleshooting configurations that can be quickly deployed when performance issues arise.

Syntax

Export-DbaPfDataCollectorSetTemplate
    [[-ComputerName] <DbaInstanceParameter[]>]
    [[-Credential] <PSCredential>]
    [[-CollectorSet] <String[]>]
    [[-Path] <String>]
    [[-FilePath] <String>]
    [[-InputObject] <Object[]>]
    [-EnableException]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Export-DbaPfDataCollectorSetTemplate -ComputerName sql2017 -Path C:\temp\pf

Exports all data collector sets from to the C:\temp\pf folder.

Example: 2

PS C:\> Get-DbaPfDataCollectorSet ComputerName sql2017 -CollectorSet 'System Correlation' | Export-DbaPfDataCollectorSetTemplate -Path C:\temp

Exports the ‘System Correlation’ data collector set from sql2017 to C:\temp.

Optional Parameters

-ComputerName

Specifies the target computer(s) to export data collector sets from. Defaults to localhost.
Use this to export performance monitoring templates from remote SQL Server hosts for standardization across your environment.

-Credential

Allows you to login to $ComputerName using alternative credentials. To use:
$cred = Get-Credential, then pass $cred object to the -Credential parameter.

-CollectorSet

Specifies the name(s) of specific data collector sets to export. If not specified, all collector sets will be exported.
Use this when you only need to export particular performance monitoring configurations rather than all available sets.

-Path

Specifies the directory where XML template files will be created. Each collector set exports as a separate XML file.
Defaults to the configured dbatools export path, typically used when exporting multiple collector sets.

-FilePath

Specifies the complete file path including filename for the exported XML template. Use instead of Path when exporting a single collector set.
Automatically appends .xml extension if not provided, ideal for creating named templates for specific monitoring scenarios.

-InputObject

Accepts data collector set objects from Get-DbaPfDataCollectorSet via pipeline input. Enables pipeline workflows for filtering and processing collector sets.
Use this when you need to chain commands together, such as filtering collector sets before exporting them.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with “sea of red” exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this “nice by default” feature off and enables you to catch exceptions with your own try/catch.