What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4568 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / wazid ali
Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / shyamsri83
When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between grant and with grant while giving permissions to the user?
how to select a field with firstletter as capital and remaining are small letters
What is inline table-value user-defined function?
What is the architecture of ms sql reporting service?
Explain error and transaction handling in sql server?
How to rebuild master databse?
How you can change a cross join into an inner join?
What do you mean by an execution plan?
Tell me what are the advantages of using stored procedures?
what is an extended stored procedure? : Sql server database administration
Define tempdb database?
What is transactional replication?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
