Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7898 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
How to provide login information for a new odbc dsn?
List the types of recovery model available in sql server?
Equi join and non equi join is possible with sql server?
What is sql azure database?
Explain how would you store your query in an SSRS report or a Database server?
What does the not null constraint do?
What is lookup override?
Explain can SSRS reports Cache results?
what is package and it uses and how can u call a package
Explain how many types of relationship?
What is sql stored procedure?
Where cross join is used?
In what three ways is the return statement used in a stored procedure?
What is field with example?
How do I edit a stored procedure in sql server?
