--- 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/