Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7896 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 is normalization? : Sql server database administration
Which database stores information about replication?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are data files?
what's the maximum size of a row? : Sql server database administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
what is the system function to get the current user's user id? : Sql server database administration
What is the importance of concurrency control?
What happens when converting big values to integers?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What do you understand by user-defined function in the sql server?
Can foreign key be deleted?
What is normalization? What number of normalization shapes are there?
How many databases can we create in a single server?
what's sql server? : Sql server database administration
