Sorry, the total is correct, but the conversion to plain text messed up the
formatting and the numbers. Correct values:
Company 1 2,534,872,129
Company 2 8,697,761,157
Company 3 553,224
Company 4 366,211,524
Company 5 7,877
Company 6 384,598,768
Total 11,984,054,679
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: Holger K. Pedersen [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 12:07 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] RE: Database size vs Size of company
accounts
The total is wrong. Try to sum up the "size in bytes" , and the result is
more than 54 Gb. The report is in err. That's my opinion.
>From: "Matt Benic" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "Axapta Dev" <[EMAIL PROTECTED]>
>Subject: [development-axapta] RE: Database size vs Size of company accounts
>Date: Wed, 17 Nov 2004 14:14:44 +0200
>
>
>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 Links
| 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.
