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

  • sys.dm_exec_requests is my bestest buddy in the whole world. It's my go to position for this type of scenario. Assuming no long running query or blocking scenario, I might expand out to look at system resources to see if something is going on with the server, but you've already nailed it, sys.dm_exec_request.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning