dthansen
asked on
SQL 2008 Lock Escalation
We have a table with 30,000,000 rows that periodically gets a mass-insert of 500,000 rows.
From what I can tell from the behavior is that a table lock is occurring on this table during the insert.
Is there a way to tell for sure if this is happening?
Thanks,
Dean
From what I can tell from the behavior is that a table lock is occurring on this table during the insert.
Is there a way to tell for sure if this is happening?
Thanks,
Dean
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.