SQL Server Configuration Recommendations for Microsoft Dynamics NAV

Microsoft Dynamics NAV Team Blog has just published a mega-useful post about recommendations for configuring Microsoft SQL Server for optimum Microsoft Dynamics NAV Performance. If you haven’t yet, you should check it here.

The blog post delivers a PDF document summarizing certain important parameters, configuration settings and suggestions for improving and maintaining a speedy SQL Server for your NAV installation. The recommendations have been written for x64 version of SQL Server 2005 SP3, SQL Server 2008 SP1 and SQL Server 2008 R2. The document was compiled by Michael De Voe, a Senior Premier Field Engineer at Microsoft specializing in performance, scalability, infrastructure and high-availability for in NAV and AX.

Vjeko

Vjeko has been writing code for living since 1995, and he has shared his knowledge and experience in presentations, articles, blogs, and elsewhere since 2002. Hopelessly curious, passionate about technology, avid language learner no matter human or computer.

This Post Has 4 Comments

  1. Soren

    That is valuable document. Having this information consolidated is going to be very useful for setting up new installations, as well as existing. Thanks for the link!

    1. Vjekoslav Babic

      @Soren: you’re welcome! I rarely re-post stuff, but this time this was just far too useful, and I still know people who for some reason do come to my blog, but are not clicking further to the NAV Team Blog, which is a shame.

  2. Jurica Bogunović

    “…just far too useless…” – lapsus lingua, or is your subconscious trying to tell us something? 🙂

    1. Vjekoslav Babic

      OMG!!! 🙁 totally a lapsus linguae… My apologies for this… 🙁

Leave a Reply