Chapter
1:
Chapter 1: Introduction
This chapter illustrates the course outline and explains the order of the chapters. It also describes the integration between Microsoft SQL Server and the Microsoft Dynamics NAV Object Designer.
Lessons:
- An overview on how the course is structured
- What is in the scope of the course outline
|
|
Chapter
2:
Chapter 2: Setting Up and Installing
This chapter starts with an overview of the software requirements to implement Microsoft Dynamics NAV 2009 and SQL Server. After that the hardware requirements are explained in detail. It also explains the security and synchronization process.
Lessons:
- How to evaluate the software and hardware requirements for Microsoft Dynamics NAV 2009.
- Understand the Microsoft Dynamics NAV two-tier and three-tier architectures.
- An overview of the recommended settings for a Microsoft Dynamics NAV database.
- The security models and the synchronization process.
Labs:
- Change the Recovery Model
- Set Trace Flags
- Create a Login Stored Procedure
- Use Filegroups to Change the Storage Location of a Table
- Create Users and Synchronize Security
After completing this lesson, students should be able to:
- Evaluate the software requirements for Microsoft Dynamics NAV 2009
- Evaluate the hardware requirements for Microsoft Dynamics NAV 2009
- Review the Microsoft Dynamics NAV 5.0 architecture
- Configure the components in a Microsoft Dynamics NAV implementation
- Explain the security model and security synchronization
|
|
|
Chapter
3:
Chapter 3: Advantages of the SQL Server Option
This chapter focuses on the available backup facilities that come with SQL Server and how to implement a backup strategy. The chapter also explains how you can access the database using tools such as Microsoft® Excel®. This chapter also includes a high-level overview of a number of performance monitoring tools. These tools will be explained in more detail in the next chapter.
Lessons:
- The differences between the two database platforms.
- The different types of backups in Microsoft SQL Server and the tools you can use to monitor performance for a Microsoft Dynamics NAV 2009 database on SQL Server.
Labs:
- Create a Backup and Restore to a Point in Time
- Transfer Data from Test to Live Database (Transact-SQL)
- Transfer Data from Test to Live Database (SSIS)
After completing this lesson, students should be able to:
- Define an adequate backup strategy
- Access a Microsoft Dynamics NAV database from third party tools
- Describe the available Performance Monitoring tools
- Evaluate the scalability requirements of a Microsoft Dynamics NAV implementation and anticipate future growth
|
|
|
Chapter
4:
Chapter 4: Performance Audits
This chapter focuses on performance and troubleshooting performance bottlenecks. In addition, it contains detailed demonstrations on the available performance monitoring tools and how and when to use them. This can be used as a guideline or workflow on how to handle performance problems.
Lessons:
- This chapter explains how to create a test environment that can be used to troubleshoot performance issues.
- It also explains different tools that can be used to monitor system performance and code execution.
Labs:
- Set up and Schedule System Monitor
- Create an SQL Server Profiler Trace
- Correlate System Monitor and SQL Server Profiler Data
- Analyze an SQL Server Profiler Trace using DTA
- Analyze an SQL Query using DTA
- Find Missing Indexes using DMVs
After completing this lesson, students should be able to:
- Create and set up a test environment for troubleshooting purposes.
- Run a performance audit using System Monitor.
- Monitor performance using the Client Monitor tool.
- Identify the clients that cause performance problems using Session Monitor.
- Create trace files using Microsoft SQL Server Profiler and analyze the trace files.
- Use the Database Engine Tuning Advisor to analyze indexes and data partitioning.
- Use Dynamic Management Views to analyze performance data.
- Collect performance-related data using additional scripts, tools, and reports.
|
|
|
Chapter
5:
Chapter 5: Improve Application Performance
This chapter discusses the available techniques to improve application performance and how to avoid performance bottlenecks. It goes into detail about optimizing C/AL code, keys, and indexes. It also contains information about best practices and a workflow explaining how to conduct a performance audit.
Lessons:
- The key areas in application development that are important for performance.
- How to create optimized keys and how to read data in an optimal way using FINDFIRST, FINDLAST, and FINDSET.
- How to avoid deadlocks.
- Tips, techniques, and methods to more easily perform troubleshooting and tuning exercises.
Labs:
- Optimize C/AL Code for Performance
- Find Index Usage
- Find Unused Indexes
- Disable Unused Keys
- Create a Deadlock Trace
After completing this lesson, students should be able to:
- Write optimized C/AL code
- Optimize SIFT tables
- Optimize cursors by using the right C/AL code statements
- Optimize key design and usage in Microsoft Dynamics NAV
- Avoid locks and deadlocks
- Troubleshoot performance issues related to the graphical user interface
- Set up index hinting
- Optimize data entry using the Bulk Insert feature
- Use some tips and tricks that are useful when optimizing Microsoft Dynamics NAV on SQL Server.
|
|
|
Chapter
6:
Chapter 6: Maintenance
This chapter discusses why and how to implement maintenance tasks on SQL Server. It also contains a number of demonstrations showing how to monitor database and transaction log growth.
Lessons:
- How to set up and schedule maintenance plans to perform important maintenance tasks on SQL Server.
- How to execute specific maintenance tasks using Transact-SQL scripts.
Labs:
- Create a Maintenance Plan
- Change the Fill Factor for Hot Tables
- Compare Query Execution Before and After Deleting Statistics
After completing this lesson, students should be able to:
- Evaluate how to optimize a Microsoft Dynamics NAV database.
- Set up a maintenance plan for a Microsoft Dynamics NAV database to optimize indexes, update SQL Server statistics, and set index fill factors.
- Maintain an SQL Server by monitoring performance, database, and transaction log growth.
|