What is blocking and how would you troubleshoot it?
- 3 Answers
- 6692 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
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What are the key configuration files for sql server reporting services ?
How to create user defined functions with parameters?
Explain what is the main purpose of having conversation group?
Who is the owner of a schema in ms sql server?
What does select 1 mean?
How to delete an existing database user?
Explain activity monitors
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
what are the important architecture components of SSRS?
What are the new features are introduced in sql server 2012 reporting services?
What is Transparent Data Encryption?
Is the primary key column of a table an index in ms sql server?
What are basics of policy management?
