 |
 |
Profile
The 2-day workshop explores all areas of optimizing Dynamics NAV (Dynamics NAV) on SQL Server - planning the infrastructure, designing the application, troubleshooting hardware and software.
It is based on real life experience from various optimization projects and focuses on the best practices of running Dynamics NAV on SQL Server. The theory will be supported by demos and hands-on exercises.
After completing the course, you will have an overall understanding of potential problems, have completed some application changes, and will be able to identify priorities and focus areas.This workshop is designed primarily for Dynamics NAV consultants who work on development and performance related projects using Dynamics NAV on SQL Server.
Workshop Syllabus
Introduction:
-Dynamics NAV SQL Server Option History
-Dynamics NAV Server and SQL Server differences
Part I – Application:
- Design
Indexes, sorting, data retrieval, SIFT, buckets, etc
Cursors, FINDFIRST, FINDLAST, FINDSET, implicit/explicit locking, etc..
Locking, blocking, deadlocks
Suboptimum coding
Hands on Exercises
- Troubleshooting
Performance Troubleshooting Guide
SQL Server Resource Kit
Application Benchmark Toolkit
Hands on Exercises
Part II – Infrastructure:
- Planning
HW - sizing, memory, disks, RAID, DAS/NAS/SAN, IDE/ATA/SCSI/FC, CPU, Network, etc
SW - versions, settings, etc
Hands on Exercises
- Maintenance
Reindex, defrag, update stats, fill factors, etc..
Hands on Exercises
- Troubleshooting
Tools, common performance problems, identifying performance problems, SQLdiag, Profiler, Session Monitor, etc..
Hands on Exercises
Prerequisites
Dynamics NAV development experience
Knowledge of SQL Server would be an advantage Contact us now to book your place in the workshops! |
 |
|
 |
|
|
|