SQL Server 2014

A lot of blogs have already been written about the upcoming new version of SQL Server.
For starters: It will not be SQL2012 R2 but SQL2014.
One feature seems to be directly interesting to NAV. The feature has the codename "Hekaton". So it was called when they started the new version. Now they have a better name […]

SQL Server Performance problem created by the ORDER BY statement

Today I had a problem with a table that has around 5 million records. The table has as primary key “Header No.”,”Transaction No.”.
In the table is a field “Order No.” that at the moment is blank for all records.
I also had an index on that field, because I will need to search for it. I […]

Changing native DB-cache/commit cache

Who is still on native DB? You really should think of migrating to SQL Server.
I still find some customers that are still on native DB. Some of them have problems with performance but mostly because the database is quite old and keeps growing. When they started, they maybe had 100 or 200MB of memory and […]

Too few VLF’s in the transaction log

Someone remembers I wrote about too many VLF in the transactionlog (http://mibuso.com/blogs/kriki/2008/12/23/some-tips-tricks-for-the-transaction-log/ ) and how to fix it?
Well, I just found a blogpost, stating that also the contrary can create performance problems.
Basically : if your VLF is too large, it takes too long before SQL Server can clear it and it takes too long to […]

Review:Microsoft Dynamics NAV Administration written by Sharan Oberoi and Amit Sachdev

If you need to do something that smells like administrating NAV and you have little experience, this book is a very good start. Instead of searching through (and inside) all the pdf’s on the installation CD or googling/binging/yahooing blogs/white papers/articles all over the internet, you have all the basic information TOGETHER(!) in 1 book!
It won’t […]

What is the difference between Private memory, Working set and Virtual size?

What do you mean with “I don’t know”?
 
Well, actually, neither did I until I saw these movies:
http://player.microsoftpdc.com/Session/1689962d-dea2-48bd-80d8-96e954fa5329
http://player.microsoftpdc.com/Session/1c97b279-d7e3-4a3e-9a76-0dac23dfddb5
 
It shows you the different counters (and different terminologies used by different programs for the same thing [I am using Process explorer and Mark Russinovich (the writer of Process explorer) advices to use it instead of the Windows taskmanager […]

Find in NAV : performance

We all know that “Find as you type” = true is bad for performance. At least I hope so….
 
But there is another problem with performance.
 
A lot of people use “Any part of field” to search a field. So, if you want to search for Customer “Deerfield Graphics Company” (customer No. ‘40000′ in W1), you type […]

Downgrading after accidental upgrade

How much times we have the question on the forum to downgrade a DB after someone accidently opened a DB with a newer NAV version and upgraded the DB?
 
Lot’s of times.
 
Downgrading is not so easy and it can be slow.
 
I needed to do it some time ago (luckily NOT for production but just for some […]

Clustered or not clustered

Do you remember the Clustered Index bug of 4.0SP1 (see also http://www.mibuso.com/dlinfo.asp?FileID=594)?
In short: 4.0SP1 forgot to set the index-property “Clustered” on the primary key (the default is that the primary key is clustered). The result is that the tables were heap-tables and that is (generally) bad for performance.
The fix was to put the key-property Clustered […]

Did you know table 36 has a BLOB field?

It is field 8725:”Signature” and it seems to be used in F8726:”Mobile Order Signature”.
 
Question: Why a post about this field?
 
Answer: Because it can (and sooner or later) will cause performance problems.
 
What happened?
A colleague calls me to tell a customer has performance problems open the sales order form. But not always.
I found out that when opening […]

Create a new blog and join in the fun!