SQL Server Performance

Summarizing Performance Stats

Discussion in 'Performance Tuning for Hardware Configurations' started by fullomschf, Jul 29, 2005.

  1. fullomschf New Member

    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!
  2. Luis Martin Moderator

    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.



  3. fullomschf New Member

    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?
  4. Luis Martin Moderator

    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.



  5. fullomschf New Member

    <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=':)' />% Disk Read Time<br /><br />Displays this value<br />632.02208988275<br /><br />The counter is <b>%</b>, 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.<br /><br />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.<br /><br />Thanks,

Share This Page