This cookie is set by GDPR Cookie Consent plugin. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. I’m more of a technical person than a functional one, but I encourage you to search our site for more about costing, and to discuss some of these settings with your NAV Partner. There are also settings inside NAV, such as costing method, posting expected cost to the G/L, and change log being enabled that can affect how quickly your database grows.
Even if your NAV Partner does advise deleting some data, make sure that is done through NAV and not directly from SQL so that NAV business rules are obeyed use your superpowers for good, not evil.
It’s my opinion that it makes more sense to throw disk drives at the problem since they are so cheap these days (I will cover how to move SQL data around in a future blog). Consult with your NAV Partner and come up with a plan. I am not going to talk about what to do to reduce your database size, but I will caution you: do not just start deleting things. This output is similar to the NAV option, sorted by size descending.įigure 3 – Screenshot of the SSMS Disk Usage by Top Tables report In SQL Server Management Studio (SSMS), right click on the NAV database, click Reports, then choose Disk Usage by Top Tables.įigure 2 – Screenshot of SSMS Disk Usage by Top Tables menu SQL has a canned report that can show you space used. Option 2: Using SQL Server Management Studio (SSMS) If you total it up, it will be smaller than the actual database file size because it doesn’t include keys, indexes, and transaction log space. This particular solution works whether you are using SQL or the old-school NAV database server (why are you still doing that? Switch to SQL!) Do note however, that the table size you see here is for the data only. You can create a new Page or Form that sits on top of that table, and that’s all there is to it! You can even apply a filter on the Size (KB) field.įigure 1 – Screenshot of Database Spaced Used from inside NAV One of these is table 2000000028, named Table Information. NAV has several hidden tables, numbered in the 20 million range. There are two ways to figure out which tables are to blame – one is from inside Microsoft Dynamics NAV, and the other is using SQL Server Management Studio. Whatever the reason, sometimes it’s nice to know what is using up all of that database space.
The log will only truncate after a log backup (in full or bulk-logged recovery models). Model is a system database and there should be no transactions at all occurring in it!!!įind out what is writing to model and stop it.