SQL Server Performance

Database Mirroring Limits

Discussion in 'SQL Server 2005 Database Mirroring' started by sbockheim, Apr 18, 2007.

  1. sbockheim New Member

    I have read that there should not be more that 10 databases in a single instance that are mirrored. Is this a real limitation. If so it criples the database mirroring capibility in my mind.

    Please give feedback.

    Thanks,

    Scott
  2. MohammedU New Member

  3. satya Moderator

    THe best practices is to limit upto 10 databsae in the database mirroring session, as explained it always depends on the configuration of the server.
    See my presentationhttp://sqlserver-qa.net/blogs/bc/ar...rroring-by-ssqa-in-sql-server-open-world.aspx in this regard about using the DBM effectively.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page