Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7894 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rajkumar
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is an inner join?
What are the restraints imposed on the table design by a merge replication?
Explain about unique identifier data type in sql server?
What is dml command?
What are diverse clauses that form a part of sql?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
What is sql server replication? : sql server replication
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
Why I am getting this error when renaming a database in ms sql server?
Can we have more than one NULL in a column having unique constraint?
What does the on update no action do?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
