Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirroring, Fragmentation & Buffer Cache Expand / Collapse
Author
Message
Posted Wednesday, May 01, 2013 12:13 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:57 AM
Points: 875, Visits: 1,760
I have a few questions regarding mirroring:

1. is the data laid down page for page on the mirror? I.e if there is a very fragmented index on the primary, will it be fragmented on the secondary?

2. Is the buffer cache mirrored? i.e will all pages in cache on the primary be in cache on the mirror, so the cache is not "cold" on failover?


Thanks!
Post #1448554
Posted Wednesday, May 01, 2013 12:27 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 4:17 PM
Points: 439, Visits: 1,094
Think of mirroring as really fast log shipping. The transaction log replay includes the target pages of the modifications. The buffer cache is not part of the transaction log.

So, to answer the questions:
1. Yes - a restored database is a copy of the source, including fragmentation
2. No - the target instance has its own buffer cache, and that will be used for the processes in use by that instance. Duplicating the buffer cache would require that the target have enough free cache space to maintain all of the entries in the source, and would also require all of the pages read by the source to be transmitted to the target. If this were a feature of mirroring, I would shut it off immediately.

-Eddie


Eddie Wuerch
MCM: SQL
Post #1448559
Posted Wednesday, May 01, 2013 12:30 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:57 AM
Points: 875, Visits: 1,760
Thanks for the super quick reply Eddie, exactly what I needed to know!
Post #1448562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse