Post reply

database metric

  • March 4, 2013 at 8:34 am

    #394302

    Is it possible to produce any sort of database level performance metric in SQL Server. Let's say how many queries are being processed by that database? what's the response time. average response time or processing time. Anything that can help me track performance of a specific database on the SQL Server instance.

    thanks

  • March 4, 2013 at 8:39 am

    #1593036

    There are lots of DMV's that you can use to get these metrics. For instance sys.dm_exec_procedure_stats.

    The activity monitor shows these details as well.

    -Roy

  • March 4, 2013 at 9:37 am

    #1593072

    Can I do that at database level?

  • March 4, 2013 at 10:18 am

    #1593098

    Yes, you can. You can specify which DB you want the metrics for.

    Just specify the database_id

    -Roy

  • March 4, 2013 at 4:35 pm

    #1593217

    On that note, get into SSMS and press the {f1} key. Select the index mode. Type "sys.dm" in the index box and start reading. There's not much you can't find out about SQL Server from T-SQL.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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