I have had same problems. In Administration - Inquiries - Database - locking database users. This helps identify the SPID of the user that's causing the locking. If you go to Query Analyser - type in sp_who "bmssa" or sp_who. This gives you the user list and you can figure out which user (spids) are locking or blocking each other. from this you can figure out the user and therefore the process that is causing the blocking.
You could switch on the transaction locking, there is a document out there somewhere which tells you how this works. This might help. Other wise i think the only solution is to go into x++ code and play around with the TTS statements to reduce the scope and length of the locking. Also changing x++ code to native sql code is much quicker but can be tricky. Ive done this in a couple of places, using the connection and statement objects and updating axapta tables using SQL instead of x++ updates. hope this helps somewhat, mike --- In [EMAIL PROTECTED], "subhamit59" <[EMAIL PROTECTED]> wrote: > Anyone knows how to get rid off exclusive table locking in SQL > because our users cannot work due to X TAB locks. > The system is heavily loaded with transactions on SQL2000 SP3a. > The memory usage on SQL seems to stay at around 100% from the 3Gb. > > The SQL server has DUAL processors > > The SQL is about 13Gb in 3Months, with 1.6 Million inventTranses. > We have X TAB locks mostly on inventSum, inventTrans, salesline, > inventJournalTrans,InventdimId,SalesTable. > > Mostly on Sales when our users trying for invoicing (Attach Sales > Tax) at a time. > This kills the user experience... > > Plese help. ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
