Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8047 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
If we delete pack Spec what will be the status of pack Body ?
What is subquery explain with example?
Explain having clause?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is a self join in sql server?
What is the purpose of grouping data in a report?
What are the advantages to use stored procedures?
Explain filtered indexes benefits?
How would you add a section to a table?
Do you know what is a linked server in sql server?
Describe the left outer join & right outer join. : sql server database administration
What are the new features of sql server 2012 reporting service?
What are the types of subquery?
Is it ok to shrink transaction log?
Why can there be only one clustered index and not more than one?
