Home Forums SQL Server 2012 SQL 2012 - General What do you use to find out what's slowing down your instance right now RE: What do you use to find out what's slowing down your instance right now

  • January 20, 2014 at 10:31 pm

    #1681728

    smitty-1088185 (1/20/2014)

    There is so many variables to your question I'm not sure where to start. How do you know it's SQL verses some other process?

    How much available memory?

    How much paging?

    What are the processors doing?

    Is there any blocking going on?

    Are you running any Indexing maintenance jobs

    etc, etc, etc......

    You are in a bad situation my friend.

    That's why sp_WhoIsActive is such a valuable tool. It shows a lot of that in a nice, tight result set.

    --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)