1) Unable to connect to SQL Server
2) Unable to access a database
3) Unable to identify a table
4) Want to run a script, but need DBA assistance
5) Queries are running slow
6) Queries are failing due to space issues (Logfile full or Data file full)
7) Server is running/responding slow
8) Customers not able to find replicated data in subscribers. Reports are failing.
9) Customer trying to access the table in another instance through Linked Server, but not able to query it.
10)Customer asks for Adhoc restore in another server.
1) Space issues (Log File Full, Data File Full) 90% Full
2) Job Failures
3) CPU 100%
4) Memory 100%
7) Database Crash
8) Corruption (DB, Page)
9) Log Shipping Out of Sync
10) Mirroring Out of Sync
11) Replication Out of Sync
12) Node failures in a cluster.
What is blocking Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency….