Database sizing

[Former Member]

Hi,

what do you think is it possible to run on Windows machine SQL Anywhere 16 server with about 1000 clients?

Client application is using database for storing data (1000 tables with 4500 indexes), but mainly also for processing - 3000 triggers, 2000 procedures, 2000 views.

Client statistics:

network traffic between 6 and 130 kb/s

requests average 60/s

received bytes avg 10K (min 57 max 25K)

sent bytes avg 63K (min 62 max 350K)

Currently there are 5 servers (ASA 9) with programmed replication.

any suggestions?

[JasonHinsperger]

Your numbers don't sound out of line for what a properly designed database and application could do, but without more details it is hard to give quality advice.

As a reference which may help you, we published a TPC-C benchmark for SQL Anywhere last fall:

http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=114112501

--Jason