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

Is database mirroring used much in the industry? Expand / Collapse
Author
Message
Posted Tuesday, December 25, 2012 7:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 28, 2013 5:45 PM
Points: 94, Visits: 96
I'm curious because some features of SQL Server are not used that frequently in businesses. What types of business environments use database mirroring?

Also, do database checkpoints occur automatically? Or are they just done manually for databases in simple recovery mode?
Post #1400120
Posted Wednesday, December 26, 2012 3:03 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 709, Visits: 1,412
I know that we use it in our environment for a HA scenario, but cannot speak for an industry as a whole. If you are looking at upgrading soon you may want to look at Always-On as it is replacing Database Mirroring as the preferred HA option.

Checkpoints happen both automatically by the SQLOS, automatically for certain operations and can happen manually.

CHECKPOINT (Transact-SQL)


Joie Andrew
"Since 1982"
Post #1400191
Posted Wednesday, December 26, 2012 3:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 1:28 AM
Points: 2,105, Visits: 5,393
Most chances are that it will get used much more. Partly because it is needed for SQL Server 2012's always on and partly because now the secondary database can be read and used for reports.

Adi



--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1400197
Posted Thursday, December 27, 2012 7:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:19 AM
Points: 4,320, Visits: 6,113
1) database mirroring can be a WONDERFUL HA tool to put in place. But before ANY entity embarks on an HA implementation they need to REALLY spend some grey matter determining what they NEED and can PAY FOR. Then make a plan, implement, TEST, and monitor. In my 15+ years of SQL Server consulting almost NO entities have done that, from mom-and-pops all the way through Fortune 100 global companies.

2) Yes, checkpoints are done automatically. Look them up in Books Online (a MARVELOUS resource). They can also be done manually.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1400613
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse