SSC : The Ultimate Running Requests Reporter

Jesse Roberge, author of many SqlServerCentral scripts, has come up with this, 'The Ultimate Running Requests Reporter'.

I mention as I was impressed and I've susbsequently implemented in my tools database.

It expands on the multiple variations of sp_who3 available to download, providing you with a more detailed snapshot of what is running at an instant.

Executing it returns the following -

• SessionID
• RequestID
• DatabaseID
• DatabaseName
• LoginName
• HostName
• ProgramName
• ClientInterfaceName
• BlockedBySessionID
• BlockingRequestCount
• WaitType
• WaitTime
• CPUTime
• ElapsedTime
• Reads
• Writes
• LogicalReads
• PendingIOCount
• RowCount
• GrantedQueryMemoryKB
• Score
• BatchText
• BatchTextLength
• StatementStartPos
• StatementEndPos
• StatementTextLength
• StatementText
• QueryPlan

Link : The Ultimate Running Requests Reporter