Viewing Server Performance with PerfMon and the PAL Tool - SQL Server 2012 Internals and Troubleshooting - page 292

TABLE 10-8: Summary of LogMan Usage

VERB DESCRIPTION

Create Creates a new data collector

Query Queries data collector properties. If no name is given, all data collectors are listed.

Start Starts an existing data collector and sets the begin time to manual

Stop Stops an existing data collector and sets the end time to manual

Delete Deletes an existing data collector

Update Updates properties of an existing data collector

Import

Imports a Data Collector Set from an XML fi le

Export

Exports a Data Collector Set to an XML fi le

The following example creates a collector named DBOverviewLog, which contains all Processor,
Memory, and LogicalDisk counters with a sample interval of 30 seconds and a max log i le size of
254MB:

Logman create counter "DBOverviewLog" -si 30 -v nnnn -max 254 -o
"D:\logs\DBOverview" -c "\Processor(*)\*" "\Memory(*)\*" "\LogicalDisk(*)\*"

Table 10-9 describes the four options available with LogMan, including the useful -s parameter,
which enables the collector to be created, started, and stopped on remote computers.

TABLE 10-9: LogMan Options

OPTION DESCRIPTION

-? (a) Displays context-sensitive help

-s <computer> (b) Performs the command on the specifi ed remote system

-config <value> (c) Setting fi le containing command options

-ets

(d) Sends commands to Event Trace Sessions directly without saving or
scheduling

Using LogMan it's possible to script collection for a baseline data set from an entire application
environment. This could be incredibly useful when doing performance testing, baselining applica-
tion performance, or troubleshooting live problems.