We have a client with 160 users spread across 2 AOS and they also have
an EMC SAN for SQL. Based on the DB growth your showing and your
expected additional users you should start working with MBS and your VAR
to help you optimize your Hardware config, and also optimize Axapta's
indexes and code to the way your using it. With our client we did a lot
of tweaking on table indexes to avoid full table scans on SQL, and also
a lot of work around the salesFormletter classes and others to minimize
table locks and increase performance for the way our client most
frequently interacted with the data. As far as SQL and Axapta goes
'more spindles, more ram' is the mantra. Our client has 12 disks in a
raid 10, 2 sets of 6, MBS is recommending more disks or take it down to
a raid 5, going to a raid 5 will give a write performance hit, but will
spread the reads across 12 disks instead of 6, and this client has more
reads than writes. We are actually going to add more disks to the SAN
since we don't want to take a perf hit in any aspect. If you have SQL
enterprise available throw the ram at it. Our client is currently on
Standard, but they will be moving to enterprise.
-Preston
-----Original Message-----
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 7:26 AM
To: Axapta Dev
Subject: [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 Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129eudhtt/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1088773168/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=279112564>
_____
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]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> 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.
