arthury_6363
Nov 03, 2009Nimbostratus
Mirroring to two Dbs
We are constructing a new instance of SQL Server DBMS on a separate machine with some changes in terms of schema and architecture. Before we go live in production (after the complete QA cycle), we want to use BIGIP do some mirroring so that we can characterize the Db instance's perf with live workload.
Here's the chain we have in mind:
ApplServers --> BIGIP --> (Db1 and Db2)
If BIGIP is used to mirror db calls, whose returnCodes are the ApplServers getting back from --- Db1 or Db2 or both?
We don't really care about the retCode from Db2 (the new instance).
We just want a live workload to hit it.
Questions:
1) Is this possible?
2) Any bad side-effects which we should be aware of? Please note the rate at which calls are passing thru BIGIP (in the above scheme) is about 20-30 per sec.
3) Any other advice would be appreciated.
Thanks,
Arthur