Post reply

Applications touching Database server

  • January 17, 2008 at 10:35 am

    #378080

    Hi Gauys

    what is the way to examine which applications are touching Database server and which making performance hit to the Database server. please let me know precise way to look into this kind of performance issues.

    Thanks in advance.

  • January 17, 2008 at 10:51 am

    #769338

    Hi Nivas,

    You can run a profiler and see what all applications and what Stored Procs or Raw SQL (I hope you dont have any ) is hitting the DB. You can also see which statements are the culprits.

    Profiler is a pretty stron tool. Look for the CPU usage, Pagereads and Timetaken. Time taken is in Milli seconds. These are the basic things to look for.

    Check this article out.

    http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

    This was written by one of the guys here. Grant Fritchey

    -Roy

  • January 18, 2008 at 1:38 pm

    #769873

    thanks for your help

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

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