My mistake. The indexes are HUGE. One index on CustTrans (on Dataareaid,
accountnum, transdate) is about 10Gb. The table is under 4Gb!
That would kind of explain where all that space is disappearing to..
Regards,
Matt Benic
Axapta Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
-----Original Message-----
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 17 November 2004 12:42 PM
To: Axapta Dev
Cc: Hennie Potgieter; Annette Colbran
Subject: Database size vs Size of company accounts
Hi all,
I recently ran the Size of company accounts report (Admin->Reports->Size of
company Accounts), and received the following:
CompanyDatabase | size (bytes)
--------------------------------
Company 12,534,872,129
Company 28,697,761,157
Company 3553,224
Company 4366,211,524
Company 557,877
Company 6384,598,768
--------------
Total 11,984,054,679
That's just under 12Gb of company data. Yet SQL server enterprise manager
reports our current database size at 58290.44Mb (approx 58Gb) of used space.
Can anyone explain where the other 46+ Gigs of database space is going!? Is
there something that is not counted by the report?
FYI, the total of size reported for all indexes (if I am reading it
correctly) is 13Mb.
Regards,
Matt Benic
Axapta Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
