-
When You create a NAV-database You end up with tables, clustered indexes and non-clustered indexes in the same filegroup. That's not optimal from a performance perspective. You can gain performance by separating the actual data (tables/clustered indexes) from Your non-clustered indexes by moving...
-
As I wrote last week in part 1 " ...I thought I might spend a blog post (or two) and go into details including some sample coding (see Part 2) " and thereby putting myself in debt. So here I am with part 2. Since last week I had spent some time reviewing and revising the code samples I wanted...
-
Like probably many of us, every now and then I sit down to search and browse through some of the old postings on dynamicsuser.net or mibuso.com . To learn new things, to get inspiration for a new blog post or just to see what's going on. That's what I did this snowy Sunday morning sitting at...
-
Index tuning in Dynamics NAV is often done by analyzing indexes and how they are used. There's a nice tool from the MS NAV Team that You can run from inside NAV to analyze You existing indexes. But what if You are missing indexes and are facing read problems rather than problems write performance...
-
Hi, I am using the NODBC driver in a .net application to connect to a Navision 4.0 SP3 database server. The KB931841 hotfix for the driver has been installed (Vista). No matter what query I perform, there seems to be an initial 'delay' for about 4 seconds when executing the reader. Does anybody...
-
After upgrading a 3.7 - to 5.0 I have a performance issue during restore on SQL. After upgrade a restore to a navtive db takes 6 min. When I do the same on my SQL server - the restore takes 4 hours! This is a db with 110 companies, but not very many transactions in each. Next weekend I will do the same...
-
The most important thing is to use the most recent build of your NAV version to make sure it is supported to run with SQL 2008. If you are just migrating a "normal" NAV database, then it is basically "detach DB 2000 - copy to SQL 2008 - attach DB 2008" - then adjust config (Compatibility...
-
Hi Guys, I'm so happy to find this very helpful site,finally i'll get some help in MS NAV 3.7.Actually we are NAV 3.7B on SQL 2000.I have been struggling to maintain few tables in SQL,mainly the TRANS_ SALES ENTRY,TRANSACTION,BIN ENTRY and the most problematic ACTIONS tables,i set a SQL job to...
-
Microsoft Dynamics CRM 4.0 Suggested Hardware for Deployments of up to 500 Concurrent Users The purpose of this document is to summarize the performance test results of 500 concurrent users of Microsoft Dynamics CRM 4.0 executing a mix of sales, marketing, service, data management, reporting, workflow...
-
Dynamics CRM 4.0 ENTERPRISE PERFORMANCE AND SCALABILITY This white paper provides an overview of the results and benefits of performance and scalability enhancements in Microsoft Dynamics CRM 4.0.
-
Improve performance on the SQL Server option by easily creating, using and managing T-SQL statements and procedures directly from NAV. The NAV SQL Procedure Management add-on for Microsoft Dynamics NAV makes it easy to manage T-SQL calls and stored procedures from within NAV, and also makes it easy to...
-
Microsoft Dynamics™ NAV 4.0 Hardware Guide for Dynamics - NAV White Paper Version 4 (August, 2007) Table of Contents Acknowledgements Legal Notice Purpose, Terms & Conditions Microsoft Dynamics™ NAV Environment Overview Microsoft Dynamics™ NAV Database Server Microsoft Dynamics™ NAV option for Microsoft...