we are thinking to implement databases mirroring for SQL Server 2008 database, Size 550GB, Average transaction/sec - 250 & Max Transactions/sec -350 (perform counters). This database is Audit database ....Mostly used for the inserts....every action
in the application is audited in this database....i mean inserts every fraction of second.
I would like to know if synchronous database mirroring (witness ) is good choice to implement as DR for this database. As far as i know database mirroring is committing of the transaction in the mirror first and then in the principal.
For such a high transactional database how performance can be affected using mirroring on the primary database ???
Also I have a doubt if fail-over occurs to the mirror in this database ....Can it take too much time to get the mirror exposed because of the high transaction rate......Can you please give me some idea on it ...What would happen when fail over would occur
in very transactional database......
View Complete Post