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 Table when our users trying for invoicing (Attach
Sales Tax) at a time.
This kills the user experience...
Plese help.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
