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 many triggers you can have on a table? : Sql server database administration
What are the transaction properties?
What is a DBMS, query, SQL?
Tell me about builtinadministrator?
What is normalization? Explain different forms of normalization?
What is ssrs?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Can you get second highest salary from the table?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is extended stored procedures?
What is a mixed extent?
Name few of the dcl commands in sql?
Can I delete event logs?
How do I start sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?