Post reply

Questions about Mirroring /w Snapshots

  • February 28, 2008 at 3:49 pm

    #203802

    Hello, I am interested in setting up a Safety OFF mirrored environment /w snapshots for reporting use. These snapshots will be accessed by report users that will query it throughout the day.

    My question is, in cases of long batch queries (especially ones without nolock) will it affect the mirroring process in anyway (i.e. buildup of redo queue, or send queue on principle)?

  • February 29, 2008 at 9:24 am

    #783896

    There might be a chance when the data in the mirrored server changes. AS the snapshot file grows thoug it wwill not affect the database mirroring directly. Your snapshot might have performance hinges.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply