|
viperbyte
Posting Yak Master
USA
101 Posts |
 Posted - 12/14/2012 : 13:25:16
|
Hello everyone, second week and still here, whew.
What's the effect, damage if any on having a couple of SPIDs hanging around? When I run this script:
SELECT LTRIM (st.[text]) AS [Command Text],[host_name], der.session_id AS [SPID],
der.[status], db_name(database_id) AS [Database Name],
ISNULL(der.wait_type, 'None') AS [Wait Type],
der.logical_reads, der.cpu_time, der.total_elapsed_time
FROM sys.dm_exec_requests AS der
INNER JOIN sys.dm_exec_connections AS dexc
ON der.session_id = dexc.session_id
INNER JOIN sys.dm_exec_sessions AS dexs
ON dexs.session_id = der.session_id
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st
WHERE der.session_id >= 51
AND der.session_id <> @@spid -- eliminate this connection
ORDER BY der.[status]
I get these two rows of output:
Command Text host_name SPID status Database Name Wait Type logical_reads cpu_time total_elapsed_time
create procedure [sys].[sp_cdc_scan] xxxxx 52 suspended myDB WAITFOR 587108 22479 208296248
create procedure[sys].[sp_cdc_scan] xxxxx 53 suspended Document Management WAITFOR 704333 49655 208296247
Am I supposed to do something about this? |
|
Hung spid question.
