-
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...
-
It's good practice to program dialogs to inform users on the state or progress of a process. Like in standard NAV when posting a sales invoice: or a journal: But did you ever had to post dozens (or even hundreds or thousands) of sales invoices or journal lines? Or had programmed a batch job for you...
-
NAV Performance is often discussed in technical terms like index tuning and hardware sizing. I would like to share some thoughts on how settings in the application also side affect performance. I hope this post can be of interest for some non-technical people who is engaged in system setup. Performance...
-
One important area in performance tuning is the setup of keys and indexes. A key in NAV is by default maintaned as an index in SQL Server Index Tuning Indexes help the user to get data out of the database fast, but needs to be updated as soon as data is changed which cost performance. Therefore index...
-
As with the release of Microsoft Dynamics NAV 2009, I was also deeply involved in the TAP for Microsoft Dynamics NAV 2009 SP1. My primary role in the TAP is to assist ISVs and partners in getting a customer live on the new version before we ship the product. During this project we file a lot of bugs...
-
The query below combines these three queries into one: Index Usage Query Recent Bocking History Table Information Query It can be used to just see the number of records in each table. But also by just changing "ORDER BY", it can be used to see which index cause most blocking / wait time / updates...
-
I know that this blogpost is far from orriginal but I am always looking for this information so I am putting it in my blog The table $ndo$dbproperty has a field DatabaseVersionNo. This is a list of recent versions. With special thanks to Dean McRae! / Database versions for: 2.50 // 1 : Beta 1 data formats...
-
As promised I have some results from the tests. So we compared HP ML 370 with 14 SAS disks dedicated to a HP DL380 with data on a HP MSA2000 SAS SAN running on VMWare with the same amounts of disks. The DL380 is running on VMWare. The OS is on a shared storrage with the OS of the other VMWare machines...
-
Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in separate tables, Dynamics NAV 5.0 SP1 uses a SQL feature called indexed views. Indexed views will automatically be maintained by the SQL Server. With SQL Server 2000, updating an indexed view can be a...
-
I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1 database conversion for a customer. The process went very smoothly and the customer was very excited about the increase in performance we were able to achieve. Just as an illustration of our success,...
-
Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What...
-
SQL and NAV is hot these days. More and more knowledge becomes available and more companies and freelancers start helping customers tuning their databases. Most of the problems exist in "older" databases. Especialy early version 3 databases have difficulties performing. Fortunalely version...