The NAV/SQL Performance Field Guide

stryk

No 8)

Well, I'm currently updating the PFG, editing/correcting this & that, adding some stuff about 5.0 SP1, updating the version lists etc. ...

I guess the updated version will be available in September/October ...

couberpu

stryk wrote:

Hi all!

Even though I already "blogged" about my little book, I would like to boldly announce it here, as well:

I published a little booklet named "The NAV/SQL Performance Field Guide" which should be availabel by now; e.g. via Amazon, etc.
http://www.amazon.de/Performance-Guide-Trouble-Microsoft%C2%AE-Dynamics/dp/3837014428/ref=sr_1_1?ie=UTF8&s=books&qid=1197564359&sr=1-1

2. Edition (Version 2.02)
ISBN: 978-3-8370-1442-6
136 Pages (Paperback, English, b/w), 15,90 EUR
Printed & Published by "Books on Demand"

“The NAV/SQL Performance Field Guide” is a booklet for the experienced NAV/SQL administrator which explains in a simple and easily understandable way the known (and unknown?) performance problems encountering with Microsoft® Dynamics™ NAV (Navision®) and Microsoft® SQL Server™ and gives practical advices, solutions and recommendations to fix and avoid problems; covering all major areas of performance optimization and troubleshooting:

+ Platform Setup & Configuration
+ SQL Server Configuration
+ Database Setup
+ Index- and SIFT Tuning
+ Block- and Deadlock Detection
+ C/AL™ Code Optimization
+ and much more!

Applies to

Navision® Financials™ 2.60/2.65
Navision® Attain™ 3.01/3.60/3.70
Microsoft® Business Solutions Navision™ 4.00
Microsoft® Dynamics™ NAV 5.00

with

Microsoft® SQL Server™ 2000
Microsoft® SQL Server™ 2005

I'm really looking forward to getting your feedback! Thank you in advance!


I hope Admin is not considering this as a sort of bold advertisement

Need help on how to order in US! I did a search on "978-3-8370-1442-6" of amazon.com and did not find any match.

Thanks

ghane

ghane wrote:

Finally ordered off amazon.de. Google Translate and cut/paste is doable.

Thanks,

Just for the record, the book is awesome. Check boxes that were never explained anywhere, are clear.

Thanks, and waiting to buy the revised edition.

--
Sanjeev Gupta

stryk

Another English speaking site for international orders is this:

http://www.amazon.co.uk/NAV-SQL-Performance-Field-Guide/dp/3837014428

stryk

Hi!

The updated version is available now:

3. Edition (Version 2.03)
ISBN: 978-3-8370-1442-6
152 Pages (Paperback, English, black/white); 17,90 EUR
Printed & Published by "Books on Demand"

In total it's 16 page more, that's why the price is slightly higher. Here an excerpt about the changes:

• Performance Counters: selection changed
• Hardware recommendations updated
• Storage: more about using SAN technology
• Moving Databases corrected/enhanced
• Optimizing "tempdb"
• Memory configuration: explanation expanded
• Index Statistics: clean up & potential issues
• NAV DB Config: About "Security Model"
• Indexes: expanded
• Fillfactors: corrected/changed
• Index Maintenance: expanded
• About VSIFT; comparing SIFT with VSIFT
• Using "Linked Objects"
• Comparing SQL with NAV Data-Types
• List about important DMV
• Appendix: Performance Checklists changed (now including also "Best Values")
• Appendix: Updated SQL 2005 versions
• Appendix: Updated C/SIDE versions
• Appendix: Added NAV Database Version Numbers

Appreciate your feedback!

Best regards,
Jörg

Tomas

stryk wrote:

Hi!

The updated version is available now:

3. Edition (Version 2.03)

...

Appreciate your feedback!

Best regards,
Jörg

Hi,

I have just got your book this morning.

Thumbs up for your English - as English is not your native language, your text are easily understanble and straight to the point - which for other non-native English readers is an advantage.

Information is really interesting and useful. I am not sure I agree with everything, but that's where I need to try it myself and check.

Definitely a good value for your money.

stryk

Tomas wrote:

Thumbs up for your English - as English is not your native language, your text are easily understanble and straight to the point - which for other non-native English readers is an advantage.

Hi Tomas,
thank you very much for your feedback - I really appreciate this And thanks a lot for your comment about the language, I try my best!

Tomas wrote:

I am not sure I agree with everything, but that's where I need to try it myself and check.

Please don't hesitate and come up with your opinion and experiences! The basic idea of that "Field Guide" is to put information from various sources together and combine it with experiences and "best practices" to support NAV administrators and developers on the job. Well, the only experiences I have are my own ones.
But when it's up to "performance optimization" we have to face new challenges nearly every day, so we need to learn and improve constantly. And off course I would like to learn from others, as well!

Cheers,
Jörg