Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7958 Views
- HCL, I also Faced
- E-Mail Answers
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 do you open a cluster administrator?
What are the benefits of normalization?
How to create a local temporary stored procedure?
What do you mean by 'normalization'?
how would you store your query in an SSRS report or a Database server?
How to check if a table is being used in sql server?
What is a trigger what are the advantages of trigger?
what kind of lan types do you know? : Sql server database administration
What is a natural primary key?
What language is sql server written in?
Is sql different from sql server?
What is the use of for clause?
How to use union to merge outputs from two queries together in ms sql server?
How to remove duplicate rows from table except one?
What is log in sql server?
