MS SQL Error: 17883, severity: 1, State: 0

Source: Internet
Author: User
Tags pack server error log sql error knowledge base microsoft download center

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
  1. SELECT serverproperty (' ProductVersion ') as ProductVersion,
  2. Serverproperty (' ProductLevel ') as ProductLevel,
  3. Serverproperty (' edition ') as edition
  4. ProductVersion ProductLevel Edition
  5. ---------------------------------------------------------------------
  6. 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.