MySQL, SQL server, SQLServerPedia Syndication

Logman for performance data collection.

While experimenting with Extended events, I ran across a tool call Logman that ships with windows. Another similar tool is Tracerpt (which I want to test out later). As per technet: Logman creates and manages Event Trace Session and Performance logs and supports many functions of Performance Monitor from the command line.

This tool can be used to create, collect, and query perfmon data right from the command line. Run the command logman query to see a list of data collector sets available on the system. I saw a ‘test’ data collector that I had previously created using perfmon. Run logman query “test” to see details about the data collectors and the counter-categories\counters that are setup.

From the command line, logman can be used to start and stop the collectors. Unfortunately the import\export feature is not there in XP or 2003. I checked a 2008 server, and it had the import\export feature. This is useful for moving around customized data collectors without having to manually create them on each server.

Advertisements
Standard

Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s