Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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