Networks

Ask something
Discussion Locked

MS Navision & RAID

0 helpful
3 replies

by an_it_guy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,

Would like to get suggestions on using Microsoft Navision on SQL Server and the hardware it can work best on.

Have read several articles that mention RAID-10 being a good choice for Navision & SQL, it improves the read/write speeds.

When database sizes grow (like I have a db upto 44gb, running on an IBM x235/2gb ram, etc); what RAID would you suggest?

Thanks,
Ash.

3 replies

by Member 22070467

It really depends on your scenario and your budget. RAID 10 offers good redundancy and performance, but you are going to pay 2x as much because twice the amount of disks are used. If you cannot afford it, you may want to consider RAID 5 or 10 for data files, and RAID 1 for log files.

by saguthrie

RAID 10 is the recommended configuration for Navision whether using the native database or SQL. The more drives you use in the array, the better performance will be and depending on the size and structure of your database, performance can improve dramatically. Compare drives and drive systems based on IOPs and interface capacity. SAS (Serially Attached SCSI) or U320 SCSI are good choices.

When calculating your budget, remember that Navision is a two-tier client/server app so most of the calculations are performed on the client workstation, not the server. That may change slightly in the upcoming 5.1 version due out in the fall, but generally speaking you are better off putting money into drives than the CPU.

The same applies to Memory. Navision is not a memory intensive application and unless you have a very large install (more than 100 users) you will see little benefit by exceeding 2gb of memory. Additional memory can be used by the OS for caching, but caching will not help with rights and isn't terribly efficient when it comes to random access database applications.

by steve florko

Hello,

Currently we have a database of 60gig and are running raid 1+0 / 10 using Navi's database. This setup so far has outperformed every setup we have had in the past. (raid 3, raid 5).

This discussion is closed to new replies.