SQL Options

ryanatwork

Hi Chaps,

Anyone seen this ?

http://blogs.msdn.com/b/nav/archive/2010/09/28/microsoft-dynamics-nav-sql-server-configuration-recommendations.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+MicrosoftDynamicsNavTeamBlog+(Microsoft+Dynamics+NAV+Team+Blog)


Only read a bit of it, but find it strange that Statistics options are not the same as Jorgs !

I personally would stick with Mr. Stryk ;-)

bbrown

I've seen it and while it makes many good points, I also do not agree with the Statistics recommendations. My apporach is to disable all the "Auto create" and "Auto update" stuff and run a nightly scheduled job.

ryanatwork

Seems that we are not the only ones to disagree.

See this :-
http://dynamicsuser.net/blogs/westman/a ... tions.aspx

David_Singleton

When in doubt ... trust Jorg. :thumbsup: