June 20, 2006 at 12:04 pm
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
June 22, 2006 at 7:19 am
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
July 28, 2006 at 10:15 am
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
July 28, 2006 at 10:36 am
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