What is blocking and how would you troubleshoot it?
Answer Posted / 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 |
Post New Answer View All Answers
How to create prepared statements using odbc_prepare()?
Do you know what is openxml in sql server?
How to disable a login name in ms sql server?
Give the query of getting last two records from the table in SQL SERVER?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Data table as parameter in sql server?
Difference between group by clause and having clause in SQL?
Tell me what do you understand by a view? What does the with check option clause for a view do?
what is a correlated sub-query? : Sql server database administration
When should you use an instead of trigger?
What is meant by referential integrity?
How many types of built in functions are there in sql server 2012?
How to rebuild master databse?
Explain sql delete command?
What is forward - only cursors / read only cursor?