index on three fields can be more than twice the size of the actual table..
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: Girish Bhatkal [mailto:[EMAIL PROTECTED]
Sent: 17 November 2004 02:17 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Database size vs Size of company
accounts
What about the transaction log , which is been created?
_____
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 17 November 2004 10:42
To: Axapta Dev
Cc: Hennie Potgieter; Annette Colbran
Subject: [development-axapta] 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
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1297nliam/M=298184.5584357.6650215.3001176/D=gr
oups/S=1705006764:HM/EXP=1100774682/A=2426683/R=0/SIG=11eeoolb0/*http:/www.n
etflix.com/Default?mqso=60185400> click here
<http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=groups/S=
:HM/A=2426683/rand=885177555>
_____
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]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
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.
