YOUR's SQL SERVER
Thursday, 26 September 2013
Checking for Blocking issues
Checking for Blocking issues by using
sp_who2
select
*
from
sys.dm_exec_requests
select
*
from
Sys.dm_os_waiting_tasks
SQL Server Management Studio Activity Monitor
SQL Server Management Studio Reports
SQL Server Profiler
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment