SQL Server 2008 R2 - Standard Vs Enterprise for Nav 2009 R2

paramb

Hi All,

I am working for a client and we have currently installed Nav 2009 SP1 and SQL Server 2005. The management is considering a complete upgrade of hardware and software. We plan to upgrade to Nav 2009 R2 and SQL Server 2008 R2.

We are currently debating on whether to implement SQL Server 2008 R2 Standard Edition or Enterprise Edition. I am aware that Microsoft Dynamics NAV and SQL Server Database Compression is a very important factor in decision making as it is only comes with Enterprise Edition. I am also currently reviewing the Features Supported by the Editions of SQL Server 2008 R2.

Considering that Enterprise Edition is very costly than standard edition, the management wanted to know which version is recommended in Nav World. Looking for valuable inputs from all of you.

Alex_Chow

Standard version is more than good enough.

bbrown

While I agree that "Standard Edition" fits the needs of the vast majority of NAV sites, "Enterprise" does offer some features that can be useful with larger more complex sites. However the cost difference can be a showstopper. That cost difference gets even worse with SQL 2012.

We can hope that more of these desirable features migrate down to "Standard Edition". Much like backup compression did between SQL 2008 and SQL 2008 R2.

paramb

Thanks for the replies. I request more replies from all of you.

Alex_Chow

paramb wrote:

Thanks for the replies. I request more replies from all of you.

Use Standard.

Unless you're familiar with the differences, you should not be using Enterprise.