Checkpoint

How can i know exactly when checkpoint is occuring ?
If i wanted to have checkpoint run more often say every 1 min, how can i
change it ? Will the setting change require a restart of SQL ?
Using SQL 2000.Hassan
> How can i know exactly when checkpoint is occuring ?
I use SQL Server Profiler

> If i wanted to have checkpoint run more often say every 1 min, how can i
> change it ? Will the setting change require a restart of SQL ?
Read this article "recovery interval Option" in the BOL
"Hassan" <Hassan@.hotmail.com> wrote in message
news:Osodx%236VGHA.4960@.TK2MSFTNGP12.phx.gbl...
> How can i know exactly when checkpoint is occuring ?
> If i wanted to have checkpoint run more often say every 1 min, how can i
> change it ? Will the setting change require a restart of SQL ?
> Using SQL 2000.
>
>|||You can use the checkpoint pages/sec counter in Perfmon. When it goes from 0
a checkpoint is occurring. I don't believe it requires a restart.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:Osodx%236VGHA.4960@.TK2MSFTNGP12.phx.gbl...
> How can i know exactly when checkpoint is occuring ?
> If i wanted to have checkpoint run more often say every 1 min, how can i
> change it ? Will the setting change require a restart of SQL ?
> Using SQL 2000.
>
>|||DBCC TRACEON(-1, 3502) will cause SQL Server to record an entry in its
errorlog every time a checkpoint is issued.
Linchi
"Hassan" wrote:

> How can i know exactly when checkpoint is occuring ?
> If i wanted to have checkpoint run more often say every 1 min, how can i
> change it ? Will the setting change require a restart of SQL ?
> Using SQL 2000.
>
>