I am looking at both the SQL Server expensive queries report and the query below, but both are showing this mysterious NULL
query as the slowest query on my server.
Is there any way I can find out more about this NULL
query and why it might be so slow?
Is this some internal query? It doesn’t seem like this should be showing up in the report if so.
This is the query which is also showing NULL
as the slowest query on my server:
select
r.session_id,
r.status,
r.command,
r.cpu_time,
r.total_elapsed_time,
t.text
from
sys.dm_exec_requests as r
cross apply
sys.dm_exec_sql_text(r.sql_handle) as t
How can I find out what this query is and why it’s so slow?
Go to Source
Author: user1477388