SP_WHO2
|
It shows blocking by the presence of blkby column value.
|
Sysprocesses
|
select * from master..sysprocesses where blocked >0
|
Activity Monitor
|
Open Activity Monitor at any time by pressing CTRL+ALT A.
|
Backup my known things and restoring it into DBA Learners.......
Subscribe to:
Post Comments (Atom)
MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
Post scripts to implement after successful SQl Server installation in a new server: 1. Listing the advanced configuration options and ...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
-
Scenario: I am looking to remove the characters value ‘SQL Server’ from the ‘SQL Server 9.00.4060.00’ in one column on the tablix...
No comments:
Post a Comment