Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 1 Answers
- 6748 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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How would you best determine why your MVIEW couldn't FAST REFRESH?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is a crs resource?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Can you redefine a table online?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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
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 is the use of ocr?
Query processing is slow(eg select query)how will u solve that
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
