Post reply

which dmv's I need to use in order to resolve performance issues with respect to CPU,Memory,I/O bottlenecs?

  • January 18, 2011 at 11:53 am

    #157396

    Can someone guide me in the following concepts?

    how to find which sql query/sql instance/sql session is taking much cpu,memory,I/O.....?

    how to analyse the reports

    how to resolve the issues with out disconnecting any user's session...?

    Thanks in advance

  • January 18, 2011 at 1:00 pm

    #1274950

    You should check out the procedure that Adam Machanic produced called sp_WhoIsActive. It will do what you are describing and has some great features to look at activity over time which will show deltas in categories like reads, memory and CPU.

    Some usage information can be found in a SQL Mag article.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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