SQL guidelines

vasilis6669

Hi,

is there any docoment regarding how SQL server 2005 should be setup for navision 5.0 SP1 (do and don't)?

Also, how are common problems solved like file growth, partitioning data, fill factor etc.

Any links will be usefull.

Currently we have a table of 15 milion records and is growing (database growth 22GB in 8 months). What are the standard procedures for minimizing disk space and have optimum performance?


Regards,
Vasilis

stryk

Hi!

Did you search the forum for "SQL Performance"? You should get tons of usefull advices, hints and recommendations!
Here some additional Links:
http://dynamicsuser.net/blogs/stryk/default.aspx
http://dynamicsuser.net/blogs/waldo/default.aspx
http://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/default.aspx
http://www.sql-server-performance.com
http://www.sqlservercentral.com
And last but not least some advertisement: http://www.stryk.info/english/fieldguide.html
Hope you'll find lots of info at least for a start!
Best regards,
Jörg

David_Singleton

stryk wrote:

And last but not least some advertisement: http://www.stryk.info/english/fieldguide.html

Definitely I can recommend this book.

stryk

Thanks David

DenSter

David Singleton wrote:

stryk wrote:

And last but not least some advertisement: http://www.stryk.info/english/fieldguide.html

Definitely I can recommend this book.

Yep me too. I was onsite at a customer, who had purchased it, and I was impressed with how well written it is. Very to the point, with clear explanations. Sometimes a 'germanism' or two here and there, but hey my German is terrible

Definately a must-have for any NAV consultant/developer who does anything on SQL Server.

vasilis6669

Yeap,

This is what I was talking about . Of course i read the SQL Performance forums!!

Thanks for the links
vasilis