I was excluding the size of the log. Our DATA is 21 Gb. Our transaction log
has 6Gb allocated (to allow for optimisations), of which it is utilising
about 100 Megs.
If it makes any difference, our DB is running on an emc SAN with fibre
connected drives, and 4Gb caching enabled on the SAN.
Matt Benic
Axapta Developer
UTi Sun Couriers Division
-----Original Message-----
From: Andrae, Tobias [mailto:[EMAIL PROTECTED]
Sent: 01 July 2004 03:07 PM
To: [EMAIL PROTECTED]
Subject: AW: [development-axapta] Database size, number of users
How much is data, how much is log? Maybe you should consider shrinking
your logfile from time to time?
Hth, Tobias
> -----Urspr�ngliche Nachricht-----
> Von: Matt Benic [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 1. Juli 2004 14:26
> An: Axapta Dev
> Betreff: [development-axapta] Database size, number of users
>
> Hi all,
> The bulk of our installation has been live for about four months, and
our
> DB
> has reached a little over 20 Gb. Our monthly growth is about 3-5 Gb a
> month.
> In a busy period such as our month-end we have 50-plus users capturing
> payments and credit notes and running reports. We have found that in
such
> a
> period, our DB server is taking strain, not ITO processing or memory
> usage,
> but in terms of physical disk usage (Note that our AOS is not taking any
> kind of strain, it is handling the load without breaking a sweat). This,
> as
> well as what seems to be contention over tables, is slowing down our
> users.
> This is extremely worrying, as our user base will only keep growing!
>
> We are curious as to the size of other installations out there.. surely
> Axapta is capable of more than 50 users working heavily? What sorts of
db
> sizes and user bases are the rest of you dealing with?
>
> Regards,
>
> Matt Benic
> Axapta Developer
> UTi Sun Couriers Division
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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.
