sql server replication: Log Shipping Performance -- sql server replication

Log Shipping Performance

Josh O'Brien
10/30/2007 5:37:10 AM

sql server replication:

We here at $SOFTWARE_VENDOR are putting some numbers to various
reporting database scenarios, one of which includes log shipping. How
long does it take to replay a log on a target database? What are the
influencing variables? It will be something like a 100MB log replaying
on a $10k dedicated MS-SQL box.

Re: Log Shipping Performance

Hilary Cotter
10/30/2007 8:50:11 PM

That depends on how many inactive transactions are on the log. In my
experience it takes slightly longer to apply the log than to dump it, but if
you have long running transactions it could take a lot longer. Dumping your
log at more frequent intervals will help reduce log restore times.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]