Checkpoint Pages\Sec counter question

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  January 6, 2012 at 4:05 am

  #262571

  Hi all

  I am struggling to understand this counter. Our SCOM implementation flagged this during a nightly job. My understanding of this counter is exactly what it says on the tin i.e. the number of pages per second flushed to disk when a CHECKPOINT occurs.

  As the database in question is in full recovery, a CHECKPOINT only ever occurs when:

  The active portion of the log exceeds the size that the server could recover in the amount of time specified in the recovery interval server configuration option.

  If this is the case then why would the pages\sec be higher at certain times. Surely the amount of pages required to trigger a checkpoint would always be the same?

  Thanks for any explanation.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  January 6, 2012 at 7:19 am

  #1429615

  To learn more about CHECKPOINTS I suggest reading Paul Randal's:

  http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1530)-checkpoint-only-writes-pages-from-committed-transactions.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  January 6, 2012 at 6:02 pm

  #1429916

  ok thanks will check it out