Hi Matt,
there is a fill factor on database and on index. (e.g. 80 % - means that each block has 20 % free space at creation and reorg) In database maintenance you can change the factor or do it interactive in SQL manager.
Otto
>From Help:
BM__how_to_set_a_fixed_fill_factor__28_enterprise_manager_29How to set a fixed fill factor (Enterprise Manager)
To set a fixed fill factor
1. Expand a server group.
2. Right-click a server, and then click Properties.
3. Click the Database Settings tab.
4. Under Settings, select the Fixed check box, and then position the fill factor slider.
-----Urspr�ngliche Nachricht-----
Von: Matt Benic [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 17. November 2004 13:46
An: [EMAIL PROTECTED]
Betreff: RE: [development-axapta] Database size vs Size of company accounts
(relatively) tiny..194Megs. It's the damn indexes. I fail to see how an
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 <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= <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/ <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/ <http://docs.yahoo.com/info/terms/> > Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129svccg2/M=298184.5584357.6650215.3001176/D=groups/S=1705006764:HM/EXP=1100782172/A=2426683/R=0/SIG=11eeoolb0/*http://www.netflix.com/Default?mqso=60185400> click here
<http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=groups/S=:HM/A=2426683/rand=241942652>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/ <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! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| 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.
