Unable to load .csv file in System Monitor

  • Hi Everyone,

    I'm finally starting to dabble in Performance Tuning.  I've read through various articles and forums to try and get an understanding of where I should begin.  Right now I'm following the "Start to Finish Guide to SQL Server Performance Tuning" by K. Brian Kelley and I've created a .csv file for some basic counters for monitoring Hardware/OS.  Now I'm trying to load this hours worth of monitoring, a .csv file, in the Microsoft Management Console so that I can look at the diffenent views (Chart, Histogram, Report). 

    I go to the Properties dialog box for System Monitor Properties and select the Source Tab.  I browse and put in the correct location of the .csv file but then when I try to click on OK, or any other tab I receive the following error window:

    Data Source c:\Hardware_061906.csv is either invalid or cannot be found.  System Message:  The specified log file type has not been installed on this system.

    I have tried looking on the internet for this error message with no luck.  I am able to open this file up in Excel and do graphs that way but I'd really like to be able to have the 3 different views available to me.  Can anyone please tell me what I am doing wrong?

    Any help is greatly appreciated - Thank you in advance,

    Barbara

  • Barbara

    I think if you want to be able to view your counters in Performance, then you need to save them as a binary file (.blg) when you set them up.

    I always save my counters as csv... you should be able to do everything in Excel that you can in Performance (charts, histograms etc), plus lots, lots more.

    John

  • John,

    I figure better late than never.  Just wanted to thank you for your reponse to my post so....

    Thank you!!

    I apologize for the delay.

    Barbara

  • Happy to help.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply