October 6, 2012 at 12:02 am
Hi,
Principal server hosted number of 6 database configured an one sigle default instance.
1. Can we able to configure database mirroring for 4 database on same instance?
2. How many databases can be mirrored in a single instance?
3. What is the necessary setting for database properties, instance properties and advanced option setting, best practices recommendations? If configure mirroring multiple database in single instance
Thanks
ananda
October 6, 2012 at 12:38 pm
ananda.murugesan (10/6/2012)
Hi,Principal server hosted number of 6 database configured an one sigle default instance.
1. Can we able to configure database mirroring for 4 database on same instance?
Yes.
2. How many databases can be mirrored in a single instance?
It is limited by your hardware but there is a soft limit when it comes to worker threads. On a 2008 64-bit system, even with ample ram and cpu, this seems to be somewhere in the neighborhood of 50 databases. Once you bump into the worker thread issue you can increase those, but there is a great debate about whether you should.
Here is an old thread I refer to from time to time where the worker thread issue is discussed at great length:
http://www.sqlservercentral.com/Forums/Topic900833-1549-1.aspx
3. What is the necessary setting for database properties, instance properties and advanced option setting, best practices recommendations? If configure mirroring multiple database in single instance
Start with this Whitepaper from Microsoft plus Books Online for setup info.
Database Mirroring Best Practices and Performance Considerations
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 6, 2012 at 2:20 pm
Follow opc.three's recommendations. Four shouldn't be an issue, but understand what you are trying to accomplish and how it works before you enable this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply