Documents on all 3 DBs are created/updated by a number of ETL processes running on very frequent schedules. A set of web apps read from the DBs and provide info to users. 99.9% of the web side of the system is all read only.
Server runs on SSDs. Requests per second hover around 2-5 per second on the database itself. We cache a lot on the web app to reduce hits to the DB, but the cache isn't long lived as the data is frequently changing.
I don't have response time metrics, but we do notice that response time slows under heavy indexing. Especially when a large # of documents change in a short period of time.
DB 1: 210,000+ docs. 16 indexes. Transactional storage used size
1.95 GBytes
Transactional storage allocated size
1.96 GBytes
Index storage size
213.5 MBytes
Total database size
2.17 GBytes
DB 2: 11,378,000+ docs, 3 indexes
Transactional storage used size
68.05 GBytes
Transactional storage allocated size
68.06 GBytes
Index storage size
1.84 GBytes
Total database size
69.89 GBytes
DB 3: 85,895+ docs 2 indexes
Transactional storage used size
5.06 GBytes
Transactional storage allocated size
5.07 GBytes
Index storage size
12.11 MBytes
Total database size
5.08 GBytes