running NAV & SQL 2005 in Virtual Server for Life

rust

Is it recommend to run Life NAV with SQL 2005 in a Virtual Server ?

KYDutchie

Hi,

simple answer here: No, it is not.

Performance will be affected too much by installing SQL2005 on a Virtual server.

Regards,

Willy

DenSter

I think you'll find many different opinions about that. The fact of the matter is, most people in here (except a very few) know close to nothing about virtualization in enterprise settings, which is why the advice is 'no'.

The key to virtualization is that you have to understand how performance is affected by the setup. You can virtualize a RAID10 configuration with 36 disks, but if the virtual server is one file that sits on a dinky little 2 processor, 4 disk server, it's not going to perform at all.

You need to find an expert in enterprise class virtualization, and make sure that they have proven experience with SQL Server, and freferably even with NAV. Until you find someone like that I think NAV implementations should stay away from virtualization, or take the risk that you don't have good performance at the start.

Marije_Brummel

Yes it can work like a charm and even boost performance, but Daniel is correct, you need an expert in all fields to make it work. Performance is complex enough without virtualisation, let alone with.

Please read my blog for tips and tricks on both SQL, NAV and virtualisation.

http://dynamicsuser.net/blogs/mark_brummel/default.aspx

If there are any more questions do not hesitate to contact me.

kriki

[Topic moved from Navision forum to SQL Performance forum]