When you collect performance data from perfmon you have a choice to save the file as a certain format.  The most common format I run across  is .blg.  This format works great when you looking at the performance data through perfmon.  Sometimes though it would be nice to pull this data into excel or another program in order to manipulate the data.  This is were the program from Microsoft called Relog can be used.  It has to be run from the command prompt.  Below is the command that would need to be run in order to convert a .blg file to a .csv file.  The process is quick and easy.

relog filname.blg -f CSV -o newfile.csv


  • Share/Bookmark

Pingtest.net was just launched to help you determine the quality of your broadband internet connection.  This tool can be used by everybody as the site breaks your test results down for you.  It assigns the letter A-F for your test results.  There is also a grade of N/A if the site can’t determine your connection rating.  The test is composed of packet loss, ping times, and line jitter.  So follow the link below and check out what your connection is graded at.  My personal connection was rated at a C which is what I expected as my ISP does not have the greatest reputation in the world.

Pingtest.net
http://www.pingtest.net/index.php

Pingtest.net Detailed Info
http://www.pingtest.net/learn.php

  • Share/Bookmark

Jimmy May has a great post over on his website that goes along with my last post about performance counters.  Jimmy works allot with SQL performance but also included some of the Vital Signs information is his spreadsheet.  Below is the link for the post which as that spreadsheet attached to it.  I would get over and download and keep it tucked away on your desktop so you can look like a genius.

Jimmy May’s Performance Post – Spreadsheet Attached In Post
http://blogs.msdn.com/jimmymay/archive/2008/10/15/perfmon-objects-counters-thresholds-utilities-for-sql-server.aspx

  • Share/Bookmark