Enhanced database mirroring in sql server 2008

Explain Enhanced database mirroring in sql server 2008

Data base mirroring in SQL Server 2008 is enhanced by:
- Automatic Page Repair: The principal is enabled and mirror computers for recovering transparently from 823 and 824 errors on data pages, with a request for a fresh copy of the page that is corrupted from the mirroring partner.
- Improved Performance: The outgoing log stream is compressed by SQL Server 2008 for minimizing the network bandwidth that is required by database mirroring.
- Enhanced Supportability: Additional performance counters for enabling more granular accounting of the time, which is spent across the different stages of DBMS log processing. Dynamic Management Views and extensions of the existing views are included, for exposing additional information that is concerned to mirroring sessions.
Hot Add CPU in sql server 2008
CPUs can dynamically be added to a running system, by using Hot Add CPU feature...........
Extended events in sql server 2008
Extended Events are the enhanced event handling system in SQL Server. It is an architecture that is highly scalable, highly configurable..........
Explain SQL Server 2008 backup compression - Sql server 2008
A compression backup is smaller than uncompressed backup. The backup speed significantly increases because it needs less disk space and I/O operations..........
Post your comment

Related Content

Follow us

▲