December 25, 2012 at 7:16 pm
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?
December 26, 2012 at 3:03 am
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.
Joie Andrew
"Since 1982"
December 26, 2012 at 3:32 am
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/
December 27, 2012 at 7:13 am
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 on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply