What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4584 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 |
How can I create a plain-text flat file from SQL Server as input to another application?
What is autocommit mode in sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What does man by sql wildcard characters in sql server?
What is the stored procedure?
What is clr ddl trigger?
What is primary key index?
How will you hide an attribute? : sql server analysis services, ssas
How can sql server instances be hidden? : sql server security
Wht is SQL Injection Attack ?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How do I create an extended event in sql server?
-
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)
