Hundreds of "AWAITING COMMAND" records
a.higgins
Posts: 90 Bronze 2
This morning I ran sp_who2 on my server, and was alarmed to see 351 SPID values being used by "Red Gate Software - SQL Tools". After some frantic digging, I eventually realized that all of these threads were from the two databases being monitored by DLM Dashboard.
It appears that each of the date/time values in "LastBatch" are schema changes on the tracked database. Each SPID has a status of sleeping, and a Command of "AWAITING COMMAND". Thankfully, both CPUTime and DiskIO are very low, but I'm still alarmed to see so many of these on my server, some almost two weeks old.
What's going on here? Is this because I haven't been to the Dashboard recently to acknowledge changes?
Representative sample from sp_who2:
It appears that each of the date/time values in "LastBatch" are schema changes on the tracked database. Each SPID has a status of sleeping, and a Command of "AWAITING COMMAND". Thankfully, both CPUTime and DiskIO are very low, but I'm still alarmed to see so many of these on my server, some almost two weeks old.
What's going on here? Is this because I haven't been to the Dashboard recently to acknowledge changes?
Representative sample from sp_who2:
SPID Status BlkBy Command CPUTime DiskIO LastBatch ProgramName
63 sleeping . AWAITING COMMAND 78 38 08/14 06:00:13 Red Gate Software - SQL Tools
65 sleeping . AWAITING COMMAND 15 0 08/14 06:00:21 Red Gate Software - SQL Tools
66 sleeping . AWAITING COMMAND 78 16 08/15 06:00:18 Red Gate Software - SQL Tools
67 sleeping . AWAITING COMMAND 0 0 08/15 06:00:23 Red Gate Software - SQL Tools
69 sleeping . AWAITING COMMAND 0 0 08/15 06:00:31 Red Gate Software - SQL Tools
70 sleeping . AWAITING COMMAND 16 0 08/15 06:00:44 Red Gate Software - SQL Tools
72 sleeping . AWAITING COMMAND 0 0 08/15 06:00:57 Red Gate Software - SQL Tools
73 sleeping . AWAITING COMMAND 0 0 08/15 06:01:45 Red Gate Software - SQL Tools
74 sleeping . AWAITING COMMAND 0 0 08/15 06:01:54 Red Gate Software - SQL Tools
75 sleeping . AWAITING COMMAND 15 0 08/15 06:02:20 Red Gate Software - SQL Tools
