SQL Server Performance Forum – Threads Archive

Summarizing Performance Stats

Newbie Question… I have collected perfmon stats in a .csv file (stat collected every 15 seconds). I am using Excel to analyze the results, however I’m not sure how to convert the resulting data into the proper format. For Example, % Processor Time is in a decimal format, if I want to display the % used in a 0% – 100% range, what formula to I use to convert the decimal. I’d also like to display the memory usage in the same format. Please advise if I’m taking the wrong approach to analyzing this info. I’ve read several articles relating to what the stat’s mean…however none that I have found have covered the topic of converting the .csv file to an easy read format. If I have overlooked an article, please let me know. Thanks in advance…your advice and help is greatly appreciated!

I think your problem is Regional settings.
In last screen of excel import data, you can change "." by "," and viceverza and that will fix your problem.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I was thinking more along the lines of this example: Total Server Memory: 7179816 If I have 8GB of memory…how can I show this as a percentage of used memory in a chart? (Something like 99% used of 100% available) Maybe I’m asking a silly questions…math was never my best subject[:I] Would it make more sense to create a chart with GB’s in the Axis and convert this number from KB to GB?

May be I missing something, but if you have setting memory to dynamic, you can trace Total SQL Server Memory (real time value) and Total Target SQL Server Memory.
Also you can trace Total Memory Available (that’s for OS) and with those 3 values you can graphics what you want. Appoligies if I donÂ´t write exactly what the counters names are, but I’m far away from any documentation righ now. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Our memory setting is not dynamic (AWE enabled), however my question has more to do with all counters not just memory. Here’s another example of what I’m looking to do… This counter PhysicalDisk(1 Q: N<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />% Disk Read Time Displays this value 632.02208988275 The counter is %, I thought the formula to convert this value to a percentage was ([Value]])/100. But that still doesn’t give me a percentage between 0 and 100. If I’m using the wrong method to chart our stats, please let me…if you know where I could find some examples of what finalized charts should look like, it would be greatly appreciated. Thanks,

]]>