SQL Server Performance

Perf Monitor Log

Discussion in 'Performance Tuning for DBAs' started by rweinstein, Aug 11, 2004.

  1. rweinstein New Member

    In my Perf Monitor log I am saving as a .CSV, the Time Stamp column is not in the right format. It says Eastern Daylight time in the column heading, but it counts from zero to 60 minutes and then wraps to zero again. It is not in the proper current datetime format. Does anyone know how to change this or correct? Is it a setting, can it be done, or does the .CSV file not save it properly?

    Also, the log file has some of the data in decimals. When I convert to % for the "% disk Time" I get numbers in the Thousands of percent and it does not seem right. Is the output data in the log file already in percent?

    Thanks.
  2. Twan New Member

    Hi ya,<br /><br />in Excel you'll have to set the format to whatever you want to see hh:mm<img src='/community/emoticons/emotion-7.gif' alt=':s' />s? In some countries you may also have to manipulate the csv file to swap day and month... <br /><br />% disk time is already in % so setting the column format to % will require you to divide it by 100<br /><br />Cheers<br />Twan
  3. Luis Martin Moderator

    When you import to excel check date format (last tab in wizard).


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page