SQL ????? ?????? ????? 844 ?? ?????? ????? 845 ?? ??????? ???? ?? ?????

???? ?????? ???? ??????
???? ID: 310834 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

???? ???????? (????) ???????? ?? ??? ?? ??? ?? ???? ??, ?? ???? ??? ????? ?? ??????? ????????? ?? ??? ???? disruption SQL Server SQL ????? ?????? ??? ???? ?? ??? ???? latch ????????? ????? ?? ?? ?? ?? ??? ??? ?? ???? ??? ?????? ????? ?? ??? ??? ??? ?????? ?? ?? disruption ?? ??? ???:
???? latch ?????? % d, bp % ?? ????????? ???? ??? ?????? 844: ??? ????? ?? x, ????? % S_PGID, stat % # x, % d ???????? ID % d: %: % d #, waittime % d. ????????? ???? ?? ??? ???? ???
: 845 Time-out ??? ?????? ??????? ??? ???? latch ?????? %d ????? % S_PGID, ??????? ID % d ?? ??? ????????? ?? ??? ???
???????: EC 6ed70090, 2 waited 600 sec. latch 6ed834bc ??? ???? ??? BUF latch.

????

?????? ????? ???? ?????? ?? ????? ???????? ?????? ?? ?????? ???? ???? ??? overstressed ?????? ?? ??? ????? ???????????? ?? ???? ?? ??????? ?? ???? ??:
  • ????????? ?? ?????/?????? (i/O) ?? ?????? ???????? ???? ???? ?????

  • Improperly ???????? ???? ??? ?? ???????? ?????????

  • ?????? inefficient ???
?? ???? ?????? ??? ???? stress ??? ?? ??????? ?? ???? ?????? ?? ?? ???? ????????? ?? ?????? ?? ???? ????????? ?????? ?? ??, ?? ???? ?????? ???? ?????? ????? ?????? ?? ???? ??? ?? stressed ??????? ?? ???? ??????? ?????? ??? ?? ??? ???:

  • ????????? ???????
  • ??????? ???????
  • ???-??????? SQL ????? ??????????? ?????????
  • ??/inefficient ???????? ?? inefficient ??????????? ?????? ?????
  • ???? ???? ???????AutoGrow??,AutoShrink????????.

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

???? ?????? ?? ???? ??, ?????? ?? ?? ???? ?? ??? ????? ????? ??? ?? ?? ?? ???? ?? ???? ?? ?? ?? ?????? ??????? ?? ???:
  • ??? ???? ??? ??? ????????? bottlenecks ????????? ????? ??? SQL Server 2000 ???????? ?????? "????? Bottlenecks" ???? ?? ??????? ???? ?? ??? ?? ????? ????? ??? ??? ?????? ??, ?? ???????? ???? ????????? ????? ??????? ?? ???????????, ????????, ?? ?????????? ?? ???? ?? ??? ???? ?? ??? ???????? ???

  • ??? ?? ???? ??? ????????? ???? ???? ??? ?? ???? ????? ??? ??? ????????? ?? ???? ???? ?? ??? ????? ???? ????????? ???????? ?????? ?????? ?? ?? ??????

  • ????????? ???? ?? ???? ????? ?????? ???????? ???? ???? Storing data or log files on compressed drives is not supported as documented in the "Physical Database Files and Filegroups" topic in SQL Server 2000 Books Online.For additional information on compressed drive support, click the article number below to view the article in the Microsoft Knowledge Base:
    231347INF: SQL Server Databases Not Supported on Compressed Volumes
  • See if the error messages disappear when you turn off all these options:

    • The SQL Serverpriority boostconfiguration option.
    • Thelightweight ??????(fiber mode) option.
    • Theset working set size???????


    The preceding settings can often be counter-productive if you change them from their default setting of OFF. ???????? ?? ???? ??? ???? ??????? ?? ??? "?????? ??????????? ??????" ?? SQL Server 2000 ???????? ?????? ??? "sp_dboption" ???? ?? ?????????????? ??????? ?? ???, ???? ?? ???? ?????? ?? ????? ?? ???? ?? Microsoft ???????? ??? ?????::
    319942TO HOW: ???????? ???? SQL ????? ??????????? ????????
  • ?????? ?? ????? ???? ??? ?????? ?? ???? ?? ??? ?????? ????? ???????? ???????? stress ?????? ?? ?? ?? ???-??? ?? ?????? ???? ?? ??? ???????? ??? ??? ????? ?? ??? ??? ??? ????? ??????????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    224587TO HOW: ???????????? SQL ????? ?? ??? ????????? ????????

  • ??? ????AutoShrinkoverhead ?????????? ?? ???? ??????? ???? ?? ?? ???? ?? ??? OFF ???? ?? ??? ????

  • ????????? ???? ?? ?? ???AutoGrowinfrequent ???? ?? ??? ??? ???????? ???? ???? ?? ??? ???? ???? ??????? ??? ?????? ????? ?? ???? ???? ?? ??? ??? ????? ??????? ????, ?? ??? ???-???????? ????? ?? ????? ??????? ???? ???????

  • ??? 844 ?? 845 ?????? ????? infrequent ???, ?? ?? ?? ???? ??? ??????? ????????? SQL Server 2000 ???????? ?????? ??? ???????? ?? ??? ????

??????

??????? ?? ??? ???? ?????? ?? ??????? ???? ?? ??? ???? ?? ?? ??? ???????? ?? ???? ?? "??????" ??? ??? ?????? ?? ??????????? ???? ?? ??? ????, SQL Server 2000 ???????? ?????? ??? ????? ???? ?????:

"?????? ????? ???"
"??????? ???????? ?? ?????? optimizing"
"Evaluating ????????"
"?????????????"
"???? ??????????? designing"
"??????????? ???????? ???????"
"??????? ?? ???????? ?? ??? ??"

??? ???????????? ??? ???? ?????? ????? 844 ?? ??? ???? ??????? ????????????, ?? ??? ???????, 845 ?? ????? ??????????? ???? ?? ???? ??? ???????? ??????? ?? ??? ?????? ?? Microsoft ???????? ??? ????? ?? ??? ????? ???? ???????? ?? ????? ????:
309093: FIX ?? ???? ???? Latch ???????? ?? ????? Sluggishness ?? ?? ?? ??? ?? ???????????? ???????
303640FIX: Latch ???????? ?????????? ?????? ??? ??? ????? ??? ?? ???? SQL ????? ???????? AWE ????? ?? ??? ???? ??

???

???? ID: 310834 - ????? ???????: 04 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
??????: 
kbprb kbmt KB310834 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:310834

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

 

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