I need help making sense of some performance monitor data I have recorded in .csv format. On two different Windows 2003 SQL Database Servers I have two sets of Performance Counters running, once counter is for hardware (free memory, disk read/write etc.) and the other counter is for monitor our SQL Database.
I have been recording the data to the longs the "Text File (Comma delimited) format taking data samples every 1 minute. I have been running these counter for about 2 weeks and during teh 2 weeks we have made multiple changes to see how to improve performance on the server... the problem is now I'm having trouble putting together all of my gather counters in a way that shows performance trends.
I can't graph that many different data samples in excel. I could manually go through and get the highest number for every 60 minute period or all 30 or so counters but you can imagine how long that could take.
Does anyone have any idea's how I can put this captured data into a presentable format? I have attached a smaple file of these .csv files