We are currently working with MSSQL which is behind a load-balancer.
We have a new project which requires a high speed data storage and retrieve. we thought of using our MSSQL (running on Windows 2008 R2) which is of a high availability and replicates himself among two servers.
In our new project we are dealing with ~1000 requests per second which needs to be replicated in order to support high-availability environment (so if one server goes down the backup server will have all of the required data)
my question is: is the MSSQL is fast enough in order to support this pace of transactions while replicating?