Showing posts with label links. Show all posts
Showing posts with label links. Show all posts

Thursday, March 22, 2012

Database Mirroring

Can you give me some details or links on the improvements to database mirroring in SQL 2008?

I don't know if this is the complete list of database mirroring improvements planned for Katmai, but the What's New (Database Engine) topic in Books Online lists the following improvements implemented in the July CTP.

Database Mirroring

Log Performance Enhancements

Compression of stream data for which at least a 12.5 percent compression ratio can be achieved.
Write-ahead on the incoming log stream on the mirror server.

In SQL Server 2008, when receiving incoming log records, the mirror server hardens them (that is, writes them to disk) asynchronously. At the same time, the mirror server processes log records that have already been hardened.
Improved use of log send buffers.

In SQL Server 2005, every log-flush operation on the principal server reserves a whole database mirroring log send buffer for its log records. In SQL Server 2008, if the most recently used log cache contains sufficient free space for the log records of the next log-flush operation, they are appended to that log cache. Otherwise, a new log cache is allocated.
Page read-ahead during the undo phase.

After a failover, the new mirror server must undo every change for which a page was written to disk locally but for which the log record might not have reached the former mirror server (the new principal server). To undo such changed pages, the mirror server must first request and receive the corresponding pages from the new principal server. Performance of this part of the undo phase is enhanced in SQL Server 2008. Early in the undo phase, the mirror server sends read-ahead hints to the principal server to indicate which pages will be requested later. After receiving a read-ahead hint for a page, the principal server puts that page in its send buffer. On receiving the corresponding page request, the principal server can respond immediately.

Automatic recovery from corrupted pages

Tuesday, February 14, 2012

Database Link

Hi!
Is it possible to use database links on MS SQL-Server 2000, like on Oracle? If its possibe, what is the syntax and can i create a database link from Microsoft SQL Server 2000 to Oracle?
NickI think what you are talking about is a Linked server . Look up more on linked servers in Books Online.And ... Yes ... you can create a linked server to Oracle