The following code generates the same information found in sp_who2, along with some additional troubleshooting information. It also contains...
Showing posts with label running queries. Show all posts
Showing posts with label running queries. Show all posts
15/11/2013
11/10/2013
Tìm transaction đang mở
Đoạn script tìm những long running transaction đang mở SELECT ST.transaction_id AS TransactionID ,DB_NAME(DT.database_id) AS DatabaseName...
21/03/2013
Tìm những cursor đang được mở
SELECT S.host_name AS ClientMachine ,S.program_name AS ApplicationName ,S.original_login_name AS LoginName ,C.name AS CursorName ,C.propert...
20/03/2013
Who Is Active?
'WhoIsActive' là 1 tool hữu ích cho ta biết cái gì thực sự đang xảy ra trong SQL Server, cùng với rất nhiều thông tin hữu ích khác n...
15/03/2013
Running queries on SQL Server
Mấu chốt ở đây là DMV sys.dm_exec_request The script to find the running queries in SQL Server. We can answer the following questions: W...
Subscribe to:
Comments (Atom)