In Databse Information, Database Used Size (KB) is shown as 66682112. But in Database Information (Tables) , Total size (KB) of the tables shows 61410544. Why its showing 5271568 KB difference?
What version?
NAV 2009 R2 only…
In VSIFT versions of NAV, the difference is made up of things like rounding and long word alignments and other things that can add up. I realize now looking at your numbers that its only 8% of the size, so a SIFT DB would generally be more.
So to answer your question, the sum of the tables is approximately the amount of space use by the data in your database, the DB info is showing how much is it actually using out of the database.
Actual Database Size is 102627392KB and used size is 66808192KB
Is this some kind of question?
|--------------------------------------------------------------| Database Size 102627392KB
|-----------------------------------------| Database Used 66808192KB
|-------------| Database Free 35819200KB
Means that 65% of actual database has been used. My doubt is that why 5126720 KB size difference shows in Database Used size (66902528 KB) and Total Database Table size 61775808 (KB) [Sum of each table size from Database Information (Tables)]. It doesn’t mean total database size.
Remember Database->Information->Tables
does not show you all the SYSTEM TABLES
http://msdn.microsoft.com/en-us/library/dd355358.aspx
Perhaps that’s a contributing factor to your size difference.
All the 8 system tables are showing in Database Information (Tables). See the below tables which are available. Any more table is there other than these?
2000000002 User
2000000003 Member Of
2000000004 User Role
2000000005 Permission
2000000006 Company
2000000053 Windows Access Control
2000000054 Windows Login
2000000203 Database Key Groups
Jithin, what exactly are you trying to achieve here? Is there an objective?
From your answer (the sum of the tables is approximately the amount of space use by the data in your database, the DB info is showing how much is it actually using out of the database.) , actually I couldn’t able to understand the difference between Sum of Table size and DB used size.
My question is that the ‘amount of space use by the data’ and actually using size out of the database should be same, ryt??
No.
Then what exactly the difference?
Do you just need me to repeat this then?
What are the remaining contributing factors to DB used size after allocating the total table data.
What is the goal of finding every KB? Piece of mind?
Why do you need to know this?
Just for information…
I would guess for the same reasons why Windows says that my 300GB local hard drive only has 287GB in total, my 300GB USB drive has 298, and my 1TB MyBook has 931GB. If I were to take a guess, the database used number is a number straight from SQL Server, and the table totals are calculated by max. space used per field times number of records, or something stupid like that.
It’s really unimportant information if you ask me.