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
- 310 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
Slow performance on MS SQL 2000 SP2 option
Dalius
Member Posts: 2
We have a problem with MS SQL 2000 (SP2) option.
Client worked with Navision server, but the database reached 64GB.
We migrated to MSSQL. Users are about 40. database size is: 72GB.
Server specification:
Xeon 2.5GB 512K/2M cache x 4, 4GB RAM, 8 x 73GB HDD (RAID1 and RAID 10 for data).
Disk queue length on data HDD is average 2. On log HDD is near 0.
Now the sales invoice registration takes about 5 minutes at day time.
At night time, sometimes registration takes 10 seconds!
With “Performance monitoring tools” I see these bad things:
1. One user blocks other users for a long time > 20 seconds
2. Commands like rec.LOCKTABLE and rec.FIND(‘+’) take, at day time, from 100 sec. to 400 sec. It is true for General Ledger, Item Ledger, Value entries and Item application entries.
How to reduce the time for document registration?
How to reduce waiting time for the table locking?
Dalius Matiukas
Client worked with Navision server, but the database reached 64GB.
We migrated to MSSQL. Users are about 40. database size is: 72GB.
Server specification:
Xeon 2.5GB 512K/2M cache x 4, 4GB RAM, 8 x 73GB HDD (RAID1 and RAID 10 for data).
Disk queue length on data HDD is average 2. On log HDD is near 0.
Now the sales invoice registration takes about 5 minutes at day time.
At night time, sometimes registration takes 10 seconds!
With “Performance monitoring tools” I see these bad things:
1. One user blocks other users for a long time > 20 seconds
2. Commands like rec.LOCKTABLE and rec.FIND(‘+’) take, at day time, from 100 sec. to 400 sec. It is true for General Ledger, Item Ledger, Value entries and Item application entries.
How to reduce the time for document registration?
How to reduce waiting time for the table locking?
Dalius Matiukas
0
Comments
We saw that you have wroten the question last year.
Did you solve the problem?
Elena