How to identify locked tables and how to release the locks?
One of the SPs in my database takes long time to execute. The same SP executes faster in another DB. My colleague suggests that the tables could be locked in my DB and I've to release the locks (in which the SP refers) from the tables. How to identify the issue is due to locks and how to release them?
Please do suggest. Thanks.
Please do suggest. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER