Last Checkpoint

Hi:
I am trying to find when last checkpoint was done by sql server. I don't
see this in sql server log. Is there any way to find out when last
checkpoint was done or frequency of checkpoints?
Thanks
I don't know about the last one but you can certainly use perfmon to view
when checkpoints occur.
Andrew J. Kelly SQL MVP
"Sal" <Sal@.discussions.microsoft.com> wrote in message
news:84109BB5-9167-49D9-87EF-8DC30FB08105@.microsoft.com...
> Hi:
> I am trying to find when last checkpoint was done by sql server. I don't
> see this in sql server log. Is there any way to find out when last
> checkpoint was done or frequency of checkpoints?
> Thanks

Last Checkpoint

Hi:
I am trying to find when last checkpoint was done by sql server. I don't
see this in sql server log. Is there any way to find out when last
checkpoint was done or frequency of checkpoints?
ThanksI don't know about the last one but you can certainly use perfmon to view
when checkpoints occur.
Andrew J. Kelly SQL MVP
"Sal" <Sal@.discussions.microsoft.com> wrote in message
news:84109BB5-9167-49D9-87EF-8DC30FB08105@.microsoft.com...
> Hi:
> I am trying to find when last checkpoint was done by sql server. I don't
> see this in sql server log. Is there any way to find out when last
> checkpoint was done or frequency of checkpoints?
> Thanks