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.
<font face="Verdana"></font id="Verdana"><font size="3"></font id="size3">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…<br /><br />This counter <br />PhysicalDisk(1 Q: N<img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
]]>