NAv 3.7 and SQL 2005 compatibility and issues

Reply

suzanazb Posted: 10-23-2007 20:21

rated by 0 users

Hi,

 I need to know for sure what are the issues or errors with running  3.7 on SQL 2005  with a Raid 5 configuration !

Thanks for help,

Suzana

Reply

Nuno Maia replied on 10-23-2007 21:28

rated by 0 users

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.

Reply

Jörg A. Stryk replied on 10-24-2007 6:15

rated by 0 users

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 to use 4.00 as it is technically more advanced than 5.00. Except if you need the new features provided by 5.00 ...

When it's up to the disk-subsystem RAID 5 is never an optin for a database system. According to the reight RAID configuration it is also crucial to place the different databases and files on the right disks/volumes, which also depends on your db size, transaction volume, etc..

Please browse these forums and you'll find plenty hints how to configure & size your SQL Server system. As a start you should also look into the "NAV Hardware Guide" http://www.mibuso.com/dlinfo.asp?FileID=587 which gives you some feasible advice (but IMHO these are partly insufficient or wrong).

Hope this helps you a little.

Regards,

Jörg

Reply

David Singleton replied on 10-24-2007 9:49

rated by 0 users

Jörg Stryk:

Please browse these forums and you'll find plenty hints how to configure & size your SQL Server system.

Definitely searching the forum is a great place to start try here:

http://dynamicsuser.net/search/SearchResults.aspx?q=sql+

 SQL

 SQL Server

Jörg Stryk:

As a start you should also look into the "NAV Hardware Guide" http://www.mibuso.com/dlinfo.asp?FileID=587 which gives you some feasible advice (but IMHO these are partly insufficient or wrong).

But I really would never recommend this document. I think that it has been changed many many times due to the vast number of errors in it. This document has cuase so much damage out there, that the one or tow correct statements in it are just not worth al the batant mistakes and confusion it has caused.

The only good thing that has come out of that document, is the amount of clean  up work it has created for SQL Performance Freelancers.

PS I have been to a number of sites where servers were built based on this,  and they were mostly disasters.

Reply

DenSter replied on 10-24-2007 16:15

rated by 0 users

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 a big enough point to NOT use certain settings in larger installations. When I hear that a customer used it, then I always ask for hardware specs, just to see if they used it the right way.