Search SupportSQL

Data Futures - on the value of data
Performance Solutions for SQL Server
Methods & Tools for SQL Server
« Performance Hog – small table missing a clustered index caused 80% CPU Consumption | Main | Wait Stats Analysis - Before/After Comparison for Job Schedule Change »
Tuesday
17Mar2009
AuthorAlek Kirstein

Checkpoint Pages/Sec High

DateTuesday, March 17, 2009 at 12:58AM

High checkpoint pages/sec can hurt performance regarding logs and i/o wait times. Several factors can contribute to checkpoint pages being written to disk at high rates. The correlations are easy to identify with other activity at the same time.

Checkpoint Pages High

--by Alek Kirstein – SupportSQL.com

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.