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
Database Performance
vikram7_dabas
Member Posts: 611
Dear concern
one of my client using Navision SQL Database and their database size is 35GB.They have 2GB RAM in server and their Database performance is too slow.Plzz guide me that if I will increase my RAM.Will it improve the performance?
one of my client using Navision SQL Database and their database size is 35GB.They have 2GB RAM in server and their Database performance is too slow.Plzz guide me that if I will increase my RAM.Will it improve the performance?
Vikram Dabas
Navision Technical Consultant
Navision Technical Consultant
0
Comments
The OS requ. min 1GB. So you have ~ 750MB only for the SQL Server (the other 250MB are for some other processes ...) Read the also the Hardware REq. for Navision on SQL Server it's on product cd.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!