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 | | Last Review | : | August 30, 2005 | | Revision | : | 1.1 |
SUMMARYWhen 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 INFORMATIONIn 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.
APPLIES TO| • | Microsoft SQL Server 2000 Service Pack 4 |
 Back to the top
| Other Support Options- Need More Help?
Contact a Support professional by Email, Online or Phone. - Customer Service
For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more. - Newsgroups
Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
|
|
Help and Support
