Microsoft KB Archive/906121

= Checkpoint resumes the behavior that it exhibited before you installed SQL Server 2000 SP3 when you enable trace flag 828 on a computer that is running SQL Server 2000 SP4 =

Article ID: 906121

Article Last Modified on 8/30/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 4

-



SUMMARY
When you enable trace flag 828 on a computer that is running Microsoft SQL Server 2000 Service Pack 4 (SP4), checkpoint resumes the behavior that it exhibited before you installed SQL Server 2000 SP3.



MORE INFORMATION
In SQL Server 2000 SP3 and later versions, checkpoint tries to use the recovery interval setting as a target for the length of time that checkpoint will take. Checkpoint adjusts to the I/O bandwidth to limit the time that checkpoint will take to the period of time that is reflected in the recovery interval setting.

When you enable trace flag 828, you enable checkpoint to ignore the recovery interval target and to keep a steady I/O pace when checkpoint is executed.

This behavior is the default behavior for checkpoint in SQL Server 2000 SP2 and earlier versions.

Keywords: kbinfo KB906121

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.