Friday, June 4, 2010

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

No comments: