In High Safety mode there can be considerable latency on each write operation which may degrade the performance of an application using a database which is part of a database mirroring topology. Microsoft recommends using short running transactions, using many connections as opposed to a single connection and ensuring that you have a high speed network.
High Performance mode offers high performance but may result in some data loss during failover. If you are using database mirroring keep in mind that all your databases must be using the full recovery model, you cannot mirror to the same server (but you can mirror between instances on the same mirror), and your source and destination databases must have the same name.
Mirroring does consume some resources on the principal server and is not scalable to a large number of databases on a single server. Mirroring does support automatic failover and the failover times are generally quick -- typically less than 10 seconds. To perform automatic failover you must configure a failover partner in your application's connection string. You can optionally use a witness server which will arbitrate between the servers which form the database mirroring pair and determine who will be the principal and who will be the mirror.
When VARs deploy and manage database mirroring they must:
- Select the most appropriate mode for their mirroring operation
- Select the appropriate security – you can mirror over the internet and use certificate based security to secure the connection
- Ensure the network has available bandwidth and speed for the mirroring operation
- Monitor your mirroring topology using the mirroring DMVs or the database mirroring monitor.
- Monitor the network to ensure that it has available bandwidth and is not experiencing congestion.
- set appropriate thresholds and alerts to alert your DBA team when the mirroring operation performance becomes critical. Use the stored procedure sp_dbmmonitorchangealert for this.
Related Q&A from Retired Expert - Hilary Cotter
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ...continue reading
Choose which SQL Server security services to offer your customers. Our DBA site expert outlines your options.continue reading
Compatibility problems might crop up in a migration from SQL Server to MySQL. Our DBA site expert Hilary Cotter helps you prepare for them.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.