-
I have to say though, that many of those problems are because of misinterpretations. It recommends RAID 5 for up to 30 users, and many companies then conclude that RAID 5 is also good for 100 users (what's the difference right). I also don't recommend this document, because it doesn't make...
-
[quote user="Jörg Stryk"]Please browse these forums and you'll find plenty hints how to configure & size your SQL Server system.[/quote] Definitely searching the forum is a great place to start try here: http://dynamicsuser.net/search/SearchResults.aspx?q=sql+ SQL SQL Server [quote...
-
As far as I know, it is not possible to connect with a 3.70 NAV Client to a SQL Server 2005, at all - I think the database compatibility mode is irrelevant ... but I never tested. As Nuno said, you need NAV 4.00 at least SP3(!) - or 5.00 with Hotfix 1. If you consider a technical upgrade, I would recommend...
-
Besides RADI 5 being bad for performance, NAV 3.70 isn’t compatible with SQL 2005. You could run SQL 2005 in SQL compatibility mode but I think this configuration isn’t supported by Microsoft. The better option it to make a technical upgrade to Navision 4.0 SP3 or 5.0
-
I said very clearly that SANs can be made to work, but only if the IT department has a good understanding of exactly how Navision Works. How SQl works, and how SANs work. My issue with SANs, is that I often see that the IT department builds a SAN puts in a nice RAID 10 array for the DB and a nice RAID...
-
Hi! Here some advice: First, a database server should always be a dedicated server - no TS or Citrix or PrintServer running there ... You should use two CPU: The NAVISION server can only use one, but normally the OS is handling the network traffic with the last CPU in the system. Means, the first CPU...
-
Hi David, Thanks for you reply, and to everyone else who replied. Can you please expand on your comment about SANs and why you don't recommend them. Why will RAID5 corrupt the database? Currently the database is on the SAN, is it still exposed to corruption? Thanks O'Neill3
-
Oniell3,you really need to get off RAID5, it is just too slow, and there is a high chance of you corrupting the database. SANs can work, (though I really don't want to recommend them), but you MUST have RAID 1 if you want any chance of speed. PS I have posted a LOT of threads on this topic, just...
-
We recently moved our DB from a RAID5 Array to a RAID1 Array (thanks to suggestions from others on this list) and the performance difference has been dramatically better. quote: Originally posted by oneill3 Hi All, I have a windows 200 server running navision. 2gb of memory xeon cpu raid 5 The database...
-
Update. I did some testing creating 250MB files on both the RAID5 & RAID1 arrays and the file create process was about 3 - 3.5 times faster on the RAID1 Array (10 seconds compared to 35 seconds). I've moved the DB to a RAID1 Array and it seems to be behaving nicely. Thanks for the help. quote...