Post reply

queries for perf monitoring

  • April 15, 2007 at 10:54 pm

    #123546

    Hi

    I need queries  to find the following  in MS sql server.

    1) which queries are consuming the most CPU

    2) Which process is currently using the most LogicalReads (and what's it doing?)

    3) Which process is currently using the most PhysicalReads

    4) for Measuring # logical I/Os  for a process

    5) To find most frequently accessed/executed tables/procedures

    6) To find out what the highest-I/O-consuming process is doing

    7) which are the currently executing SQL statements

    8) To identify the Transact-SQL statements that are currently consuming CPU

    9) Which process is currently using the most CPU (and what's it doing?)

    10) To  find most frequently accessed/executed tables/procedures

     

    Please help me

    Thanks in advance

  • April 17, 2007 at 3:29 pm

    #701033

    What version of SQL Server?  If 2005, all of this information is available in data management views (dmv's).

    However, if it's 2000 you'll need to set up some tracing usinng profiler or rml traces.

    You could query system tables to get some of this data too.

  • April 17, 2007 at 7:07 pm

    #701054

    Hi Clive thnaks for the reply...

    i am using sql 2000 and 2005. i am new to this. and hv no idea  , could you help me to get these queries

     

     

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

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