Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Mirroring a Large Number of Databases in a Single SQL Server Instance

Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number of Databases in a Single SQL Server Instance on the SQLCAT web site. This paper explores what happens to performance as you mirror more and more user databases on a single x64 instance of SQL Server. They wrote this paper to address a common misconception that you cannot mirror more than 5-10 databases on a single instance of SQL Server.

According to their benchmarks, performance is not really an issue (on x64). What I have seen in my own experience is that the administrative overhead of having high numbers of user databases (that may be dependent on each other) is the real challenge. I was one of the technical reviewers for this paper, which was a lot of fun.

Comments

Posted by Dugi on 18 February 2010

Thanks for the notice and very nice team on this technical note!

Posted by Theo Ekelmans on 14 October 2013

Hi Glenn,

SQLCAT has removed the technote on "Mirroring a Large Number of Databases in a Single SQL Server Instance", but it looks damn interesting, since i ran into a brick wall with 350+ db's to mirror and running out of threads and getting hit by minidumps of the sql kernel :P

Do you still have it ?

Theo Ekelmans (theo@ekelmans.com)

Leave a Comment

Please register or log in to leave a comment.