Our database (MS SQL) is now 9.35Gb and the logs are 4Gb.  Logs are growing and shrinking but never go over 5Gb.  The DB is growing 1Gb a month and on a normal day we have about 45 users.  No server overload for us yet.

Steeve...


-----Message d'origine-----
De�: Matt Benic [mailto:[EMAIL PROTECTED]
Envoy�: 1 juillet 2004 08:26
��: Axapta Dev
Objet�: [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
click here


Yahoo! Groups Links

Reply via email to