SELECT [Spid] = session_Id
, ecid
, [Database] = DB_NAME(sp.dbid)
, [User] = nt_username
, [Status] = er.status
, [Wait] = wait_type
, [Individual Query] = SUBSTRING (qt.text, er.statement_start_offset/2,
(CASE WHEN er.statement_end_offset = -1
THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
ELSE er.statement_end_offset END - er.statement_start_offset)/2)
,[Parent Query] = qt.text
, Program = program_name
, Hostname
, nt_domain
, start_time
FROM sys.dm_exec_requests er
INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as qt
WHERE session_Id > 50 -- This is to ignore system SPID's.
AND session_Id NOT IN (@@SPID) -- This is to ignore this current Statement/Session.
5 comments:
Mua vé tại Aivivu, tham khảo
vé máy bay đi Mỹ giá rẻ
các chuyến bay từ mỹ về việt nam hôm nay
ve may bay tu canada ve viet nam
vé máy bay về việt nam từ nhật
Có chuyến bay từ Hàn Quốc về Việt Nam không
Vé máy bay từ Đài Loan về Việt Nam
khách sạn cách ly
vé máy bay cho chuyên gia nước ngoài
You provide the informative information related to database in detail. I learn more through this post. Further, The power washing services Boston present the outstanding work.
In short time, we got best knowledge from your article. We are always here to provide you Professional Floor Repair Services Chicago IL that are trusted and budget-friendly.
I had read your reviews. developers are happy from you. You keep them update toward the SQL updations.
Likely, I am updating you about the Local Moving Services in Atlanta GA. This give you reliable service and rapid response.
Unquestionably believe that which you said. Your favorite reason seemed to be on the net the simplest thing to be aware of. I say to you, I certainly get annoyed while people think about worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will probably be back to get more. Thanks hackers for hire reviews
Post a Comment