Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
installation
Chris
Member Posts: 7
Hello everybody,
We’ve got a customer who is upgrading from nav 2.60 to 5.00. They do have a lot of external program’s who communicate with nav true dataports. Now the customer wants to implement new external tools which they write themselves. They want to use the SQL-server version of Navision. It’s a small company, only 12 nav-users.
Their current installation is on a HP-server with:
- Processor :
* Type = Xeon
* Internal speed = 3,2 GHz
* External speed = 800 Mhz
* Std/Max = 1/2
* L2 cache = 2 MB
- Geheugen
* Totaal = 3 GB
* Geheugenmodules totaal: 8
- RAID Controller
* HP Smart Array 641
* Gesupporteerd : RAID 0, 1, 5, 10
* SCSI kanalen : 1 intern
- Hard disks
* 2 x 72 GB 10.000 rpm (hot -plug)
* Netto schijfcapaciteit met RAID 1 = 72 GB
128MB Battery-Backed Write Cache Enabler
36GB U320 Hot Plug Hard Disk 15000 rpm
72GB U320 Hot Plug Hard Disk 15000 rpm
Totaal beschikbare hard disk capaciteit in RAID 1 = 36GB + 72GB = 108GB
Now they are testing Navision in a sql-test environment but it’s really slow to use.
I’ve searched the net maybe not enough but I don’t seem to find any minimal systemrequirements.
Does anybody know if it could help to add memory to the server or is the server simply to weak?
Thanks,
Chris.
We’ve got a customer who is upgrading from nav 2.60 to 5.00. They do have a lot of external program’s who communicate with nav true dataports. Now the customer wants to implement new external tools which they write themselves. They want to use the SQL-server version of Navision. It’s a small company, only 12 nav-users.
Their current installation is on a HP-server with:
- Processor :
* Type = Xeon
* Internal speed = 3,2 GHz
* External speed = 800 Mhz
* Std/Max = 1/2
* L2 cache = 2 MB
- Geheugen
* Totaal = 3 GB
* Geheugenmodules totaal: 8
- RAID Controller
* HP Smart Array 641
* Gesupporteerd : RAID 0, 1, 5, 10
* SCSI kanalen : 1 intern
- Hard disks
* 2 x 72 GB 10.000 rpm (hot -plug)
* Netto schijfcapaciteit met RAID 1 = 72 GB
128MB Battery-Backed Write Cache Enabler
36GB U320 Hot Plug Hard Disk 15000 rpm
72GB U320 Hot Plug Hard Disk 15000 rpm
Totaal beschikbare hard disk capaciteit in RAID 1 = 36GB + 72GB = 108GB
Now they are testing Navision in a sql-test environment but it’s really slow to use.
I’ve searched the net maybe not enough but I don’t seem to find any minimal systemrequirements.
Does anybody know if it could help to add memory to the server or is the server simply to weak?
Thanks,
Chris.
0
Comments
In the first test SQL will always be slow since it has to warm up. Post the same order again and use that for measuring.
How big is the database and how large are the posted tables?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Configuring a 36GB + 72Gb as RAID 1 will not give you 108GB usable. It will result in 36Gb usable (the smaller of the 2 drives).
The SQL Server Resource Kit (available through partnersource) also provides a lot of different pointers on dealing with deadlocks, defragging indexes and optimizing tables. This is definately something you should check out.
Epimatic Corp.
http://www.epimatic.com