FIX: ?? ?? ????? ????? ?????? ???? ?? 100?000 ??? ?????? ??? ??????? ????? ?????? SQL Server 2005 ????? ?????? ?? ????? ???????? ?????

?????? ????????? ?????? ?????????
???? ???????: 917971 - ??? ???????? ???? ????? ????? ??? ???????.
50000162 bug #: (Hotfix SQL)
???? Microsoft ??????? Microsoft SQL Server 2005 ???? ??????? ????. ??? ???????? ??????? ? ????? ?? ??????? ?????? ??? ???? ????????? ???????? ???????? ???? ??????? ?????? ?? ?????? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

??????

??? ??? ??????? ??????? ??? ??? ??????? ???????:
  • ??????? ???? ??? ????? ?????? ???? ????????? ??????? ???
  • ??????? ?????? ???? ????????? ???????
  • ??????? ??? ?? ??? ??? ??? ????? ????? ????????? ??? ????? ?????? ????????? ???????
  • information about whether you must make any changes registry
  • ??????? ???? ??? ??????? ?? ???? ????????? ???????

???????

??? ?????? ??? ??????? ????? ?????? SQL Server 2005 ????? ?????? ?? ????? ???????? ?????, ?? ????? ?? ??????? ???????:
  • ????? ???? ?? 100?000 ????? ???????.
  • ????? ???????? SQL Server ???? ???? ?? stalls.

    ?????? when occurs this problem, time mode user is a percentage large of the CPU utilization.
The error condition may resemble the following:
2006-04-05 17:52:04.46 Server *
2006-04-05 17:52:04.46 Server * BEGIN STACK DUMP:
2006-04-05 17:52:04.46 Server * 04/05/06 17:52:04 spid 0
2006-04-05 17:52:04.46 Server *
2006-04-05 17:52:04.46 Server * Non-yielding Scheduler
2006-04-05 17:52:04.46 Server *
2006-04-05 17:52:04.46 Server * *******************************************************************************

2006-04-05 17:52:04.46 Server Stack Signature for the dump is 0x00000000000000A8
2006-04-05 17:52:18.92 Server External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.
2006-04-05 17:52:18.92 Server Process 62:0:0 (0x3e14) Worker 0x0000000005DBE1C0 appears to be non-yielding on Scheduler 3. Thread creation time: 12788747103671. Approx Thread CPU Used: kernel 12437 ms, user 61593 ms. Process Utilization 16%. System Idle 76%. Interval: 75000 ms.

?????

occurs this problem because is recorded the history database in the database msdb . when you have a database that contains lots of files and groups file, regularly clear the history backup database msdb .

????

????? ??????? ?????? ?? Microsoft. ????? ??? ??????? ??????? ?????? ??????? ???????? ?? ??? ??????? ???. ??? ????? ??? ??????? ??? ??? ??????? ???? ?????? ??? ??????? ?????. ?? ????? ??? ??????? ?????? ??????. ????? ??? ??? ?? severely ????? ??? ???????, ???? ?? ??????? ??????? ??????? ??????? ????? ??? ???????.

??? ??? ??????? ????? ???????, ???? ???? 'Hotfix ????? ?????? ?? ???? ????? ????? ????? ???. ??? ?? ???? ??? ?????? ???? ???? ??????? Microsoft ?????? ?????? ??? ???????.

?????? ?? ???? ???? ????? ?????? ?? ?? ??????? ????? ???? ????????, ??? ???? ?????? ??? ???? ??????. ???? ????? ?????? ????? ??????? ??? ??????? ??? ????? ???????? ???? ?? ????? ?? ??? ??? ??????? ?????. ?????? ???? ????? ????? ????? ??????? ?????Microsoft ?????? ?? ?????? ??? ???? ?????? ?? ?????? ???? Microsoft ??? ??? ??????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ??????? 'Hotfix ??????? ???????? ?????? ????? ???? ???????. ??? ?? ????? ????? ?????? ??, ??? ??? ??????? ??? ????? ?? ??? ??? ?????.

???????

?? ???? ?? ??????? ?? ??? ??? ???????.

????? ????? ?????????

??? ???? ?????? ????? ????????? ??? ????? ??? ???????.

??????? ???????

??? ???? ?????? ???????.

??????? ????? Hotfix

??? ??????? ????? ??? ??? ????? ??? ???? ?????? ?????? ??????? ???? ???? ??? ???????. ?? ?? ????? ??? ??????? ???? ??????? ???? ??? ?? ???? ???? ??????? ????? ???? ??????? ????.

????? ????? ?????????? ?? ??? ??????? ????? ??? ???? ????? (?? ???? ????? ??????) ???????? ?? ?????? ??????. ???????? ???????? ?????? ??? ?????? ?? " ??? ??????? ??????? " (UTC). ??? ??? ??????? ?????, ???? ????? ??? ????? ??????. ????? ????? ??? UTC ?????? ?????? ?????? ????? ??????? ??????? ??????? ?? ?????? ??????? ?????? ?? " ???? ?????? ".
??????? 32 ??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.replication.dll2005.90.1541.01,608,48018-????? - 200616:05?? Applicable
Microsoft.sqlserver.smo9.0.1541.01,559,32818-????? - 200616:05?? Applicable
Microsoft.sqlserver.sqlenum9.0.1541.0895,77618-????? - 200616:05?? Applicable
Osql.exe2005.90.1541.051,48818-????? - 200616:06?? Applicable
Replrec.dll2005.90.1541.0781,08818-????? - 200616:05?? Applicable
Sbmsmdlocal.dll9.0.1541.015,599,90418-????? - 200616:07?? Applicable
Sbmsmdredir.dll9.0.1541.03,929,88818-????? - 200616:07?? Applicable
Sqlaccess.dll2005.90.1541.0349,47218-????? - 200616:04?? Applicable
Sqldiag.exe2005.90.1541.0960,28818-????? - 200616:05?? Applicable
Sqlservr.exe2005.90.1541.028,790,10418-????? - 200616:07?? Applicable
??????? 64 ??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.replication.dll2005.90.1541.01,813,79218-????? - 200611:02?? Applicable
Microsoft.sqlserver.smo9.0.1541.01,551,13618-????? - 200611:02?? Applicable
Microsoft.sqlserver.sqlenum9.0.1541.0863,00818-????? - 200611:02?? Applicable
Osql.exe2005.90.1541.083,74418-????? - 200611:01?? Applicable
Replrec.dll2005.90.1541.01,007,39218-????? - 200611:02?? Applicable
Sbmsmdlocal.dll9.0.1541.015,599,90418-????? - 200616:07?? Applicable
Sbmsmdredir.dll9.0.1541.03,929,88818-????? - 200616:07?? Applicable
Sqlaccess.dll2005.90.1541.0356,64018-????? - 200611:02?? Applicable
Sqldiag.exe2005.90.1541.01,127,71218-????? - 200611:02?? Applicable
Sqlservr.exe2005.90.1541.039,500,06418-????? - 200611:03?? Applicable
??????? 64-bit ????????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.replication.dll2005.90.1541.02,521,88818-????? - 200608:09?? Applicable
Microsoft.sqlserver.smo9.0.1541.01,551,13618-????? - 200608:09?? Applicable
Microsoft.sqlserver.sqlenum9.0.1541.0863,00818-????? - 200608:09?? Applicable
Osql.exe2005.90.1541.0123,16818-????? - 200608:08?? Applicable
Replrec.dll2005.90.1541.02,137,88818-????? - 200608:09?? Applicable
Sbmsmdlocal.dll9.0.1541.048,472,35218-????? - 200608:10?? Applicable
Sbmsmdredir.dll9.0.1541.06,079,26418-????? - 200608:09?? Applicable
Sqlaccess.dll2005.90.1541.0351,52018-????? - 200608:09?? Applicable
Sqldiag.exe2005.90.1541.01,637,15218-????? - 200608:09?? Applicable
Sqlservr.exe2005.90.1541.072,166,68818-????? - 200608:10?? Applicable

?????

????? Microsoft ????? ?? ??? ?? ????? ?? ???????? Microsoft ???????? ?? ?????? "????? ???".

??????? ????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684 ??? ????????? ???????? ???? ?????? ???? ??????? ????? Microsoft

???????

???? ???????: 917971 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 2.7
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
????? ??????: 
kbmt kbautohotfix kbbug kbfix kbtshoot kbhotfixserver kbqfe kbpubtypekc KB917971 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????. ??? ?? ???? ??? ??????? ????? ?? ???????? ?? ??? ???????? ?????? ????? ????????? ??????? ???? ??? ???????
???? ??? ????? ??????? ?????? ??????????917971

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com