Let's say we have two Stored Procedures A & B within the same database.
Stored Procedure A:
- Executes for a long time
- Has transactions within
- Makes Calls over Linked Server
Stored Procedure B:
- Simple SP that inserts/updates a table
- Quick. Within 1 second
A & B execute on the same database but DO NOT have any common tables.
Yesterday, B was blocked by A and I found that the
- wait_type was LATCH_EX
- wait_resource was LOG_MANAGER
What does this LOG_MANAGER mean? What kind of resource are they waiting on? Plus, does it have anything to do with with transactions within the 'A' SP.
A quick Googling indicates that it has something do with growth of logs, but I would appreciate a more indepth explanation.