Importing Perfmon log files into databases or spreadsheets

by Mitch Tulloch [Published on 23 Nov. 2011 / Last Updated on 23 Nov. 2011]

How you can import Performance Monitor log files into a database.

Performance Monitor (perfmom) creates log files using the Binary Performance Log (BLG) file format. Since these files are binary in nature, they can't be directly imported into databases such as those used by SQL Server or into Excel spreadsheets.

However, you can use the Relog command-line tool to convert BLG files to CSV format which can then easily be imported into SQL databases or Excel spreadsheets.

The syntax for the Relog tool can be found at http://technet.microsoft.com/en-us/library/cc771669(WS.10).aspx

Mitch Tulloch is a Microsoft Most Valuable Professional (MVP) and widely recognized expert on Windows administration, deployment and virtualization. For more tips by Mitch you can follow him on Twitter or friend him on Facebook.

The Author — Mitch Tulloch

Mitch Tulloch is a widely recognized expert on Windows administration, networking, and security. He has been repeatedly awarded Most Valuable Professional (MVP) status by Microsoft for his outstanding contributions in supporting users who deploy and use Microsoft platforms, products and solutions. Mitch has published over two hundred articles on different IT websites and magazines, and he has written or contributed to almost two dozen books and is lead author for the Windows 7 Resource Kit from Microsoft Press. For more information, see www.mtit.com .

Latest Contributions

Featured Links