Search SupportSQL

Data Futures - on the value of data
Performance Solutions for SQL Server
Methods & Tools for SQL Server
« Omnipotent Re-indexing Visualized | Main | Performance Hog – small table missing a clustered index caused 80% CPU Consumption »
Sunday
12Apr2009
AuthorAlek Kirstein

Stolen Pages - DBCC – Log Shipping

DateSunday, April 12, 2009 at 1:18AM

Log Shipping DBCC commands issues during log restores here is showing to be flushing the cache every 15 minutes. This can sometimes cause intermittent performance issues that are hard to identify without correlating the cache hit levels to the performance lag.

Stolen Pages - DBCC - Log Shipping

Print ArticlePrint Article

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.
Member Account Required
You must have a member account on this website in order to post comments. Log in to your account to enable posting.