Options

NAVISION Database size, company wise

vsalotvsalot Member Posts: 47
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

Comments

  • Options
    kinekine Member Posts: 12,562
    File-Database-Information-Tables and copy all into excel and use excel to calc sums for each company.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    vsalotvsalot Member Posts: 47
    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
  • Options
    kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    strykstryk Member Posts: 645
    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 :wink:
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Options
    ouredpouredp Member Posts: 56
    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.
  • Options
    vsalotvsalot Member Posts: 47
    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!!!
  • Options
    jaja_bingsjaja_bings Member Posts: 16
    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
Sign In or Register to comment.