Company an old SQL SERVER 2000 database, a few times a week will occur (one or more) CPU duration 100%, causing the application does not respond to the situation, as shown in:
The error message is as follows:
View Code
The database version, patch situation is as follows:
Code Snippet
- SELECT serverproperty (' ProductVersion ') as ProductVersion,
- Serverproperty (' ProductLevel ') as ProductLevel,
- Serverproperty (' edition ') as edition
- ProductVersion ProductLevel Edition
- ---------------------------------------------------------------------
- 8.00.760 SP3 Enterprise Edition
Check the official Microsoft documentation for the cause of the error: Checkpoint process forces SQL Server to write all dirty pages to disk. Systems that support and maintain fast I/O rates and do not cause I/O attempts to be suspended can trigger a situation whereby the checkpoint process does not have to wait for the I/O process to complete. When checkpoints are not built correctly, it affects the entire database activity and performance. This can lead to reduced transactions and a reduced bulk commit rate. The following error message may appear in the SQL Server error log:
Error: 17883, severity: 1, State: 0
Dispatcher 0 appears to have been suspended. SPID 7,ecid 0,ums Context 0x045530b8.
Solution:
From the official Microsoft documentation, this is a bug in SQL SERVER 2000 and needs to be patched, the specific reference is as follows:
Service Pack Information
To resolve this issue, obtain the latest Microsoft SQL Server Service Pack. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 (http://support.microsoft.com/kb/290211/)
How to Obtain the latest SQL Server Service Pack
Security Patch Information
This hotfix is provided with the security patch for Microsoft security bulletin ms03-031. For additional information about how to obtain this security patch from the Microsoft Download Center, click the following article number to view the article in the Microsoft Knowledge Base:
815495 (http://support.microsoft.com/kb/815495/)
Ms03-031:sql Server Cumulative Security patch
821277 (http://support.microsoft.com/kb/821277/)
Ms03-031:sql Server Service Pack 3 Security patch
--------------------------------------------------------------------------------------------------------------- -------
Since the patch, the problem has not occurred in recent days, the follow-up need to observe a period of time to see if such problems will occur, to determine whether the patch really solves the problem.
Resources:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/821277
http://www.microsoft.com/zh-cn/download/details.aspx?id=18384
Http://support.microsoft.com/kb/824430/zh-cn
MS SQL Error: 17883, severity: 1, State: 0