Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8049 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rajkumar
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / harikrishna
Blocks will occur when one processes holds a lock and
second processes requires a conflicting
lock type, then it blocks, check weather the I/O is moving
or not for the blocked processes.
use the below command to know the route block.
select spid,blocked from sysprocesses where blocked>0
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you understand by the denormalisation?
Which index created when Create Index on table(col), Why
How do I save a stored procedure in sql server?
What is the native system stored procedure to execute a command against all databases?
What is the difference between a "where" clause and a "having" clause?
What are the different types of columns types constraints in the sql server?
what's the difference between delete table and truncate table commands? : Sql server database administration
Do you know what is a linked server in sql server?
What is the full form of ddl?
What is 4nf in normalization form?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Tell me what is the stuff and how does it differ from the replace function?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
