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 --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/