Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8190 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
Do you have any idea about the tcl commands?
What is sql server english query?
What is report server project?
What is SQL Azure Fabric?
what happens on checkpoint? : Sql server database administration
How can I know what locks are running on which resource?
What are secondary xml indexes?
How can you insert null values in a column while inserting the data?
How will you hide an attribute? : sql server analysis services, ssas
What are the new data types are introduced in sql 2000?
What is a performance monitor?
Can an entity have two primary keys?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What are alternate keys?
How to insert multiple rows with a subquery?
