Post reply

another question regarding performance dashboards..

  • November 10, 2008 at 10:31 pm

    #201088

    i was told to generate performance dashboard reports on two different databases. I never used performance dahsboards before. I request sql gurus here to help me with finding the threshold values for CPU tim,i/o contention,memory contention..like i need to know how much shoould be th cut of for these ...i wld rlly appreciate ifsmeone cld give me a link or give me the values directly here.

    tx in advance

  • November 10, 2008 at 10:36 pm

    #896730

    iqtedar (11/10/2008)

    i was told to generate performance dashboard reports on two different databases. I never used performance dahsboards before. I request sql gurus here to help me with finding the threshold values for CPU tim,i/o contention,memory contention..like i need to know how much shoould be th cut of for these ...i wld rlly appreciate ifsmeone cld give me a link or give me the values directly here.

    tx in advance

    do you want to check the performances of databases??

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • November 20, 2008 at 4:08 am

    #900961

    a simple google search for --sql server performance monitor counters-- will give you a lot of hits.

    for instance:

    http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

    http://www.windowsitlibrary.com/Content/77/15/1.html

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply