What is blocking and how would you troubleshoot it?
Answer Posted / 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 |
Post New Answer View All Answers
What is query cost in sql server?
What types of Joins are possible with Sql Server?
What is efficiency data?
How to write a query with a left outer join in ms sql server?
What do you mean by table and field in sql?
How to filter records of table in SQL SERVER?
Data table as parameter in sql server?
what is package and it uses and how can u call a package
How do I create a stored procedure in sql server?
Why use view instead of a table?
How to create “dependant” parameter “make, model, year”
Which tcl commands are available on the sql server?
What is the difference between a function and a stored procedure?
What is sleeping status in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?