I am specifying hardware requirements for 2 database servers to a hardware vendor and would like some opinions on how to choose hardware options.
There are 2 scenario's.
One - A production database with up to 200 users hitting the database simultaneously.
Two - A read only production database with up to 100 users hitting the database simultaneously. Should the read only database have a seperate mirrored drive for the transaction logs? Are transaction logs necessary for read only databases?
Can anyone give recommendations? Thanks.