Search code examples
sql-serversql-server-2005activity-monitor

Blank screen when looking at Activity Monitor details


I'm looking at the Activity Monitor in SQL Server 2005 and when I double click a specific process to view the SQL I am given a blank screen.

What does this mean?

What could be causing this?


Solution

  • The running SQL is not stored for long, so perhaps the process finished executing the SQL some time ago? Look at the 'Last Batch' column, anything over fifteen minutes old is likely gone already.