Home
»
Microsoft Dynamics NAV
»
Microsoft Dynamics NAV Team
»
All Tags
»
SQL
»
Performance
Browse by Tags
Announcement
Configuration
Development
Help
Hotfix
NAV 2009
NAV 2009 R2
NAV 2009 SP1
NAV 5.0
Related Posts
Blog Post:
SQL Server Data Compression and Microsoft Dynamics
Microsoft Dynamics NAV Team
I am pleased to announce the release of the SQL Server Database Compression Analyzer for Dynamics. This tool was created to help Dynamics partners and customers leverage the benefits of SQL Server Data Compression and to make the processing of analyzing and implementing compression quicker and easier...
on
21 Jul 2011
Blog Post:
Microsoft Dynamics NAV Changes by Version
Microsoft Dynamics NAV Team
Microsoft Dynamics NAV has had multiple changes to the underlying code in order to optimize performance of NAV on SQL Server. The chart below shows the changes by version. REPEATABLEREAD In order to use the REPEATABLEREAD, changes are needed after installing the latest hotfix to enable the option...
on
12 May 2011
Blog Post:
Microsoft Dynamics NAV and SQL Server Database Compression
Microsoft Dynamics NAV Team
Microsoft SQL Server 2008 introduces two new compression features (available in Enterprise Edition) that are of interest to users with large databases. Data compression applies to individual tables and indexes within a database and comes in two options: ROW and PAGE. Backup compression is a new option...
on
11 Feb 2011
Blog Post:
Degraded Performance on Dynamics NAV and the SQL Server TokenAndPermUserStore
Microsoft Dynamics NAV Team
I have recently come across an issue with a large Dynamics NAV customer where queries that normally ran VERY quickly became slower and slower over time and blocking was increased significantly. After going through the normal troubleshooting activities there seemed to be no easily explainable cause for...
on
13 Jan 2011
Blog Post:
Performance Analyzer 1.0 for Microsoft Dynamics
Microsoft Dynamics NAV Team
The Microsoft Premier - Dynamics team has created and compiled a set of scripts and tools for helping analyze and troubleshoot SQL Server performance issues on the Dynamics products. These are the same tools that we use on a daily basis for collecting SQL performance data and troubleshooting SQL performance...
on
4 Nov 2010
Blog Post:
Microsoft Dynamics NAV/SQL Server Configuration Recommendations
Anonymous
Michael De Voe , a Senior Premier Field Engineer at Microsoft, has compiled a set of recommendations for SQL Server configuration to improve performance when running Microsoft Dynamics NAV 5.0 and later versions with one of the following versions of SQL Server: Microsoft SQL Server 2005 SP3 x64...
on
28 Sep 2010
Blog Post:
Books! Four Options for Learning More About How to Create RoleTailored Solutions with Microsoft Dynamics NAV
Anonymous
This month the fourth English-language book on Microsoft Dynamics NAV 2009 is being released. For those of us working on Dynamics NAV, it is exciting to see that partners are so invested in our product that they eagerly spend months writing a book to help other partners be more productive when creating...
on
8 Jun 2010