Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8192 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the collation?
what is the difference between openrowset and openquery?
Find first and last day of current month in sql server
What is the sql server agent?
What are different types of replication in sql server?
How to list all objects in a given schema?
What are joins in sql and what are the different types of joins?
Explain error and transaction handling in sql server?
How to include date and time values in sql statements?
tell me the disaster recovery plan
Does a server store data?
How to execute function in stored procedure sql server?
where can you add custom error messages to sql server? : Sql server administration
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to modify an existing stored procedure in ms sql server?
