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
    sbockheim, Apr 18, 2007
    #2

  2. MohammedU New Member

    MohammedU, Apr 18, 2007
    #2

  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.
    satya, Apr 19, 2007
    #2

Share This Page