Hey folks,

With high availability being so “high” on everyone’s list mirroring is a hot topic. This article by Sanjay Mishra and Prem Mehra talks about all the ways you can implement mirroring with a large number of databases without scaling to multiple instances.

The articles’ overview is here” A frequently asked question regarding database mirroring is: How many databases can be mirrored in a single instance of Microsoft® SQL Server®? This question is often raised by customers who are consolidating many databases into fewer instances and the high availability or disaster recovery service-level agreement (SLA) requires deployment of database mirroring.

Sometimes the question is raised when readers misconstrue the restriction documented in the SQL Server Books Online stating that “On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session.“

Check out the article here:http://sqlcat.com/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

It’s well written and informative.

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.