NAVISION Database size, company wise

vsalot

Hi I have Navision database (SQL), with size of 160GB, having 4 companies.

Now I want to check the size of each of the company. How's that possible?

Thanks

kine

File-Database-Information-Tables and copy all into excel and use excel to calc sums for each company.

vsalot

kine wrote:

File-Database-Information-Tables and copy all into excel and use excel to calc sums for each company.

But in that case, Total Database size is showing 160 GB used, in File -> Database -> Information, where as the option suggested by you is showing 115GB only. I want the exact size actually

kine

This is only way from NAV. Yes, the sizes are not exact, but it could give you the info about ratio between companies. If you want exact sizes, you need to go into SQL and read size of each table and sum them by company, but it is not as easy...

stryk

Well, to get the exact figures you might look into the "sp_spaceused" procedure (see "Books Online").
Basically you need to loop through all tables, exec the SP and save the result into a (temporary) table; then you cold run some queries to get the exact sums (= size) per "Company" ...
Requires some TSQL programming

ouredp

On SQL2008 , Server Management Studio you have a standard Report (Right Click on database)
-Disk Usage by Table- that can be exported to excel as well.

vsalot

ouredp wrote:

On SQL2008 , Server Management Studio you have a standard Report (Right Click on database)
-Disk Usage by Table- that can be exported to excel as well.

Thanks Very much!!!

jaja_bings

kine wrote:

File-Database-Information-Tables and copy all into excel and use excel to calc sums for each company.

Hi, I like to do that this way, but i get an error message:



EDIT: I missed our configuration: DB: SQL 2005/ Client: NAV5.0

I'm not sure what is the reason for that message. Does anyone have an idea?

Kind regards,

jaja_bings