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.
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!
@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.
“…just far too useless…” – lapsus lingua, or is your subconscious trying to tell us something? 🙂
OMG!!! 🙁 totally a lapsus linguae… My apologies for this… 🙁