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 (906121)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP4

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.
Modification Type:MajorLast Reviewed:8/30/2005
Keywords:kbinfo KB906121 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.