Quick one today:

A few days ago, one of your customers, upon request, sent us their Perfmon files from their database server. We have a template to capture all pertinent Sql Server metrics from PerfMon that we provide to all our customers. When needed we request them to enable the process and let it capture data for a specified amount of time.

Sometimes, customers have their own configuration that writes PerfMon data into a binary performance log file (*.blg) format. In such situations, Relog command could help convert BLG files into CSV (text file format).

“Relog creates new performance logs from data in existing performance logs by changing the sampling rate and/or converting the file format. Supports all performance log formats, including Windows NT 4.0 compressed logs.”

Using the flag “-f”, specify the output file format (CSV in this case).

Here is the command:

relog -f csv inputfile.blg -o outputFile.csv

Hope this helps,
_Sqltimes