What is blocking and how would you troubleshoot it?
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 you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Why would you use sql agent? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what do you understand by fine-grained auditing?
Can you redefine a table online?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain about your sql server dba experience? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is fill factor? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?