Locking problems

ironluc
ironluc Member Posts: 11
edited 2011-04-23 in SQL Performance
I have some locking problems with a NAV 5 database. A lot of Clients (about 40 to 60) and 5 NAS are connected to the database. Since few days from time to time the users can not work because the table "Sales Shipment Header" is locked (sometimes other tables also affected but most of the time it is table 110). The fastest way to remove the locking is to delete all sessions.
I am still not able to identify which session causes the locking. I used some reports of the SSMS, but they did not helped me.
What can I do?

Comments

  • rhpnt
    rhpnt Member Posts: 688
    That's odd. Using SQL server a deadlock should never occur unless someone layed hands on the table and "modified" something. You can always see the deadlock in the activity monitor in SSMS.
  • kriki
    kriki Member, Moderator Posts: 9,121
    An easy way to find out who is locking who is to run the database sessions (File=>DataBase=>Information=>Tab sessions=>click on the "Current sessions" to show the form.
    It shows who is blocking who. But if you want also the resource that is blocked, you need to use sql server profiler. But at least you have an easy start to see who is blocking who.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • tenantfile
    tenantfile Member Posts: 2
    This the same problem that i am also facing with my sql . So plz provide me the solution for thies problem.
  • stryk
    stryk Member Posts: 645
    Check out this one:
    http://dynamicsuser.net/blogs/stryk/archive/tags/Locking/default.aspx

    I hope this could help you to identify the blocking and deadlocking issues.

    Cheers,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories