Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 1 Answers
- 6841 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
BLOCKING MEANS ONE PROCESS HAS LOCKS ON ONE OR MORE RECORDS
AND ANOTHER PROCESS TRIES TO ACQUIRE LOCK ON THE SAME SET OF
ROWS. SO BASICALLY SECOND PROCESS HAS TO WAIT TILL FIRST
PROCESS FINISH WORKING ON THE RECORDS AND THEN SECOND
PROCESS CAN TAKE OVER AND FINISH IT'S TASK. BLOCKING IS
DIFFERENT THEN DEADLOCK. BLOCKING CAN LAST LONGER AS IT IS
NOT AUTOMATICALLY STOPPED BY SQL SERVER LIKE DEADLOCK.
HERE'S GOOD SITE WHERE YOU CAN FIND INFO ABT BLOCKING.
http://www.builderau.com.au/program/sqlserver/soa/Find-blocking-processes-using-recursion-in-SQL-Server-2005/0,339028455,339286600,00.htm
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Why would you use sql agent? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is transparent data encryption? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the steps you will take to improve performance of a poor performing query?
What is fill factor? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
what are the types of connection load-balancing?
How do you open a cluster administrator? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you enable flashback feature?
when does an alert gets signaled?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
