Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8077 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
What will be query used to get the list of triggers in a database?
What is the default schema of your login session in ms sql server?
Explain different types of Normalization.
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is bulkcopy in sql?
What do you understand by hotfixes and patches in sql server?
what is the difference between Tabular and Matrix report?
Can the query output be sorted by multiple columns in ms sql server?
Can you type more than one query in the query editor screen at the same time?
Is truncate autocommit?
What is data set in report?
What are database states in ms sql server?
How does clustered and non clustered index work?
What are the results of running this script?
What is an expensive query?
