Exclusive Table Locks in Axapta & SQL
beno
Member Posts: 2
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 1.7Gb from the 2Gb possibile.
The SQL server has 2 processors and the processors are not loaded. The winchesters are quite well, and the AOS servers are also about 40-80%.
The SQL is about 13Gb in 7Months, with 1.6 Million inventTranses.
We have X TAB locks mostly on inventSum, inventTrans, Inventsumliktts, salesline, inventJournalTrans.
This kills the user experience...
:oops:
The system is heavily loaded with transactions on SQL2000 SP3a.
The memory usage on SQL seems to stay at around 1.7Gb from the 2Gb possibile.
The SQL server has 2 processors and the processors are not loaded. The winchesters are quite well, and the AOS servers are also about 40-80%.
The SQL is about 13Gb in 7Months, with 1.6 Million inventTranses.
We have X TAB locks mostly on inventSum, inventTrans, Inventsumliktts, salesline, inventJournalTrans.
This kills the user experience...
:oops:
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions