we plan to build ASE server for OLTP application and we need really quick response time ( 100-300 ms). Database will be quite small (less than 2GB) , as well as number of active connections (less than 5). In fact, it will be kind of automatic quotation machine - there's inflow of information about situation on market and we have to react to this situation very quickly. All the logic is in stored procedures.
We have limited budget, so we are limited to Intel.
I have prepared some HW specification:
2 x Xeon 3.2 GHz with 1 MB Level2 cache
2 GB of RAM
SCSI Ultra320 RAID adapter with at least 256 MB cache (preferably 512 MB)
4 x 36 GB 15krpm Ultra320 SCSI disks with 8 MB cache configured as RAID 10 (e.g. strip + mirror)
We will use Red Hat EL 3.0 and ASE 12.5.2 for Linux. I plan to assing 200 MB for tmpfs device for tempdb, 200 MB for OS and remaining RAM (cca 1.6 GB) for ASE.
I think, that it will be quite quick, but I wonder, if it will be as quick as possible with given limits.
So my question is: Is this the optimal setup for small quick OLTP server on Intel architecture ? Would you recommend any changes ? More ( or less ) RAM, disks, cache on RAID adapter ? Quicker disk subsystem ? Different RAM allocations ?