??????? ??????? ??? ???????? ??? ????? ????? ????? ??????? ?????? ??????? ???? ???? ?? ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 917043 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

?? ???? ??????? ????? ??????? ?????? ??? ??? ?????? ???? ????? ?????? Microsoft SQL Server ??? ????? ???? ????. ???? ????????? ??? ???? ??? ??????? ?? ??? ???????? ?? ???? ????? ?????? SQL Server ????? ?? ??? ??? ?? ????? ????????. ??? ?? ??????? ???? ???? ?????? ????? ?????? ?? ????? ???????? ????????.

????????? ?? ??? ???????? ??? ?? ??? URL ?????? ????? ??? ??????? ???? ??????? ??? ?????. ?? ?? ??? ?????? ?? ??? ???? ???? ?? ??????? ?? ???????? ? ?????? ? ????? ??????, ?????? ?????? ?????????? ?? ???????? ??????? ??????? ???????? ?????? ????? ?? ??????? ???????? ??? ?????. ?? ????? ?? ???? ? ??????? ? ??????, ??? ?????? ? ????? ?????? ?????????? ? ???? ? ????? ?? ???? ?? ??? ????? ?? ?? ??? ??????? ??? ?????? ?? ??? ?????. ???? ??????? ?????? ??? ???? ?????? ???? ????? ??????? ??? ??? ???? ????????. ??? ????? ???? ??? ???? ?????? ?? ??? ?? ??? ??????? ?? ???? ????? ??????? ?? ??????? ?? ?? ?????? ??? ???? ??????? ?? ???? ??? ??? ?? ???? ????? (????????? ?? ????????? ? photocopying ? ??????? ?? ???? ???) ?? ??? ??? ???? ??? ????? ???? ?? ???? Microsoft.

?? ????? ??? Microsoft ???????? ?? ??????? ?????? ?????? ?????? ???? ????? ?? ???? ???? ?????? ???????? ??????? ???? ??????? ?? ??? ???????. ???????? ?? ??? ???? ????? ??? ??????? ????? ?????? ?? Microsoft ??? ??????? ?? ????? ?? ????? ????? ???? ?????????? ?? ???????? ???????? ???? ????? ?? ??? ????? ????? ????.

© ???? Microsoft Corporation. ???? ?????? ??????.

Microsoft Windows Windows Server ????? SQL ?? ?????? ?????? ????? ?? ???????? ???????? ?? ???? Microsoft ?? ???????? ??????? ?/?? ??????? ??????.

????? ??? ??????? ??????? ???? ??? ?? SQL Server ???? ???? ??? ??? ????? ?????? ?????? Jet ????????? ?? ??? ?????? Active Directory ? Exchange Server ?????.

??????? ????

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

??????? ???????/??????? (I/O) ?? SQL Server

?? ??? ????? ???????? "??" ????? ????????? ?? SQL Server ????? ????????? ??????? ???? ???????? ??????? ????? ????? (WAL). ??? ????? ??? ????????? ?? ???????? ???????:
??????? SQL Server 2000 I/O
http://technet.microsoft.com/en-us/library/cc966500.aspx
?????? ????? ??????? ???? ??? SQL Server 2005.
230785????? SQL Server 2005 ? SQL Server 2000 ?? SQL Server 7.0 ? ????????? ????? ???????? ????? ?????? ????????
?????? ????? ??? ????????? ??????:
  • ??? ???????? ??? ???????.
  • ??? ???????? ??????? ???? ???????.
  • ??? ?? ???? ???? ?????? ??????? ????? ?? ?? ??? ????? ??????????.
  • ??? ?? ??? torn ??? I/O.

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

???? ????? ?? ???? ??? ???? ???? ???? ????? ???? ?? Microsoft. ??? ???? ?????? ???? ?? ???? Microsoft ????? ?? ???? ??????? ???????? ?? ???????? ???? ???? SQL Server ?? Exchange Server ?? "Active Directory".

FILE_FLAG_WRITETHROUGH ? FILE_FLAG_NO_BUFFERING

?????? Microsoft ????? ???????? ???? ??? ??????? ??? ?? ?????? ??????? ?????? ??? ??? ????? ????? ?????? ???? ????? ????????. ??? ?? ???? ???? ?? ??? ??????? ??? ??? ??????? ??? ????? ??????????. ????? ???? ?? ???? ????? ????????. ???????? ????? ????? ????? ???? ?? ????? ????? ????? ??????? ?????? ??????? ?????:
  • ????? ??? ??????? ????? ?????
    ?????? ????? I/O ??????? ????? ??????? ??????? ???????? ??? ??? ???????? ?????? ?? ?? ????? ????? ?????? ??????? ??????? ??? ??????? ???????? WAL.
  • ??? ???? ?? ?????? ???????/???????
    ???? ????? ??????? ?? ????? ????? ??? ?????? ?????? ???????/???????. ?????? ?????? ??????? ?????? ????? ?????? ???????/??????? ???????? ??? ??? ???? ???? I/O. ??? ????? ??? ???? ????? ????? ???? ???? ??? ??? ????? ???????? ??? ??? ????? ??????? ???????? WAL ??????.

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

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

???? 1: ????? ???????? ? ??? ?????? ?? ???????

???? ??? ????????? ??????:
  1. ??? ????? ??? ??? ???? 100 ?? ????? ????????.
  2. ??? ????? ??? ??? ?? ????? ??????? ?????? ??? ???????? ???? ??? ???????? ???? ????? ?????? ??? ????? ??? ???? "???? ?????? ???????".
  3. ????? ???? ????? ???????? LSN hardened ? ?????? ??????? ????? 100.
  4. ??? ????? 100 ?????? ????? ?? ????? ??????? ?????? ???????? ??? ??? ????????.
  5. ???????? ????? ???????? ??? ?????.
????? ???? ????? ?????? ?????? ??? ?? ??? ????? ????? ?????? ??????? ??? ??????? ??????????. ?????? ???? ??? ??? ??????? ??? ???? ????? ??? ????? ???????? ???????? ??? ????????? ????? ?????? ????? ???? ????? ??????? ?????? ????? ??? ????????. ?? ???? ??????? ?????? ????? ??? ??? ???? ??????? ?????? ????? ?? ???? ??? ????? ????? ?? ????? ????? ?????. ?? ?????? ??? ?????? ??????? ?????????? (??????? ??????? ??? ???? ??????, ????? ????? ?????) ??? ????? ?????? ?? ??? ????? ???????? ???? ???? ?? ????.

???? ?????? ?? ???????? ?????? ???? ?? ???? ?? ????????? ??????? ??? ????? ?????? ????? ??????? ?????? ?? ?????? ???????/???????. ????? ?????? ??????? ???????? ?? ????? ???? ?????? 100 ????? ??????? ??? ???????. ??????? ?????? ????? ??? ???? ?? ???? ??? ????? (??? ????? ??? ?????? ???????) ? ???? ?????? 100 ???? ?? ????? ?????? ????? ????? ??????? ?????? ????? ??? ????? ???????? ??????? ??? ??????? ?? ???? ?????? ?????.

???? 2: ????? ?????? ????? ???

??? ????? ?????? "???????? ?? ?????" ??????? ?????? ?? ??? ??? ??? ????? ???????? (.ldf ?? SQL Server) ???????? ?? ????? ??????? ??????. ??? "????????" ???? ??? ??????? ??????? ???? ????? ??? ????? ????? ?????? ?????? ??????? ??????. ????? ??? ???????? ????? ?????.

??? ?????? ????? ? ??? ????? ??????? ???????. ???? Microsoft ???? ???????? ????? ???????? ????? ????? ????? ????????? ???? ??? ??????? ????.
  1. ??? ???????? ??? ??? ?????? ? ??? ??? ?????? ??? ?????? ??????? ??? ??????? ??????????.
  2. ??? ????? ?????? 100.
  3. ????? ???? ????? ???????? ????? ???? ????.
  4. ??? ???????? ?????? ???? ????? ???????? ??????? ???? ????? ??????? ??? (???? ?? ????? ??? ???? ?????? ?????? hardened). ??? ???? ????? ???????? ??? ???? ??????? ??? ?? ?? ??????? ??????????.
  5. ????? ?????? SQL Server ?? ??? ????????? "????" ??? ???? ?????? ??????? ????? ??????? ????.
  6. ??? ????? 100 ???? ?? ???????? ??? ???? ??? ????.
??? ??? ????? ???????? ??? ??? ???????? ??? ?????? ???????? ????? ???? ??? ?? ????? ?????? ????? ???. ??? ????? ??? ?????? ???? ???? ??????? ?????? ????? ?? ??? ????? ????? ????? ?? ??? ?????? ????? ????????. ???? ????? ???????? ??? ??? ??????? ???? ??? ?? ???????? ???? ??? ?? ???? ???? ?? ???? ????? ???? ???????? ????? ????? ???????? ?????. ??????? ?????? ????? ????? ????? ??????? ?????? ??? ?????? 100 ???? ??? ??? ?????? 100 ??? ???? ???? ????? ??? ????? ?????????? ?? ??? ???? ????????.

?????? ??????? ?????? ????? ?????? LSN ??????? ?? ??? ?????? ????? ???????? ?????????.
  • ??? ??? LSN ??? ?????? ????? ?? ???? ??? ??? ? ?? ??????? ?? ??? ????? ??? ?????? ??? ?????? ??????? ?? ??? ???????? ??? ?????? LSN ??????.
  • ?? ???? ???? ?? ??? ??? LSN ??? ?????? ??? ??????? ?????? ?????? ???????? ?????? ?????? ??? ???? ????????. ??? ????????? ??? ??? uncovered ??? ?????? ?????? ????????? ?? ???? ????? ???? ???? ?????? ??? ????? rightful.
?? ??????? LSN ??????? ??????? ?? ????? ???? ??????? ?????? ?????? 100 ??? ????? ?? ??? ?????? ??? ???? ?? ??? ??? ???? ????? ????? ??????. ????? ????? ???????? ?? ??? ????? ??? ??? suspect ? ??? ?? ???? ?????? ??????? ?????.

???? 3: ????? ?????????? ??? ????? - ???? ????? ????? ????????? ????????

?????? 2 ?? ??? ??? ??????? ?? ??????? ???? ?? ?????. ??? ???? ??????? ????? ?? ??? ????????? "????" ?????? ??? ????? ???????? ?? ??? "????????? FULL" ???? ?????? ????? ?????????? ??????? ?? ????? ?????? ??????. ?? ???????? ???? ??? ?? ???? ??? ???? ??? ???? ???? ????? ??? ???? ????? ??? ??? ????? ????? ??????? ??? ?? ???????.

?? ?? ???? ??? ?????? ????, ??????? ??? ????????? ????? ??????? ?????? ??? "????????" ???? ??? ????? ??? ????? ????????? ?? ????? ???? ???? ?? ???? ???? ??? ????? ??????. ????? ???? SQL Server ??? ????? ????????? ? ????? ???? SQL ???? ??? ????? ???? ?????? ??????? ??? ????? ????? ????????? ??? ???? ???? ??? ?? ?? ??????? ?????????? ???????? ?????? FlushFileBuffers Win32 API. ????????? ??? ??? ?? ???? ?????? ????? ??????? ?????? ???? ???? ??? ??? ???? ?????? ??????? ? ????? ??????? ?????? FlushFileBuffers ?????? ??????? ??? ??????? ????? ????? ????? ???????? ????? ???? ??????? ????? ???? ????? ??????? ????. ??? ????? ???? ?????? ???? "?? ??? ??? ?????? ????? ??????? ???????? ? ???? ??????? ?????? ????? ???" ?? ??? ???????. ?? ?? ???? ????? ?? ??? ?? ?? ????? ??????? ?????? ????? ?? ????? ?? ??? ????? ????? ??????? ?????? ?? ????? ???????? ?? ???? ??????? ????? ????? ????????? ???? ??????. ??? ?????? ??????? ?? ?????? ?????????? ???? ????? ?????? ?????? ???? ??? ??? ????? ?????????.

???? 4: ????? ????? ???????? ??? ????

????? ????? ?????? ????? ??? ?????? ??? ????? ????? ??????? ??? ???????? ??????? ?????? ?????? ???????. ???? ?????? ? ????? ??? ??? ????? ????????? ?????? ??? ????? ?????? ? ???? ????????? "????? ?????" ??? ??? ??? ??????? ????? ???????? ???????? ???? ????? ??????? ???? ???? ??? ????? ???????? ????? ???? ??? opting ???? ??? ????? ?????? ??? ????.

??? ???? ?????? 5: ?? ??? ??? ???????? ????? ???????? ???? ? ??????

???? SQL Server 2005 ????? ?????? ???? ???? ?? ????????? ?????. ??? ?????? ????? ????? ?????? ????? ??? ??????? ???????? ?? ????? ???? ???? ???????? ?? ????? ???????? ???? ??? ????? ????? ????? ??? ???? ???????? ?? ????? ???????? ????????. ????? ??? ??????? ????? ?????? ?? ????? ?????? ???? ??? ?????? ????????. ??? ?? ??? ????? ?????? ?? ?? ??????? ?????????? ? ??? ????? ???????? ??????? ???????. ?? ????? ????? ???????? ???? ??? ?????? ???? ??????? ?????? ?????. ??? ??? ??? ?? ??? ?????? ???? ?? ???? ?? ?????? ????? ?????? ????? ???????? ???????? ???? ?? ???? ?????? ?????? ??????? ???? ????? ??????? ??????? ??????.

????? ?????

????? ????? ???? ????? ??? ????? ??????? ?????? ?? ??? ?? ??? ????? ????? ??????? ?????? ??? ???????? ????? ??? ????? ??????. ???? ????? ??? ??????? ??? ????? ?? ????:
  • ??? ????? ???? ?????? ??????? ?? ?? ??? ????? ?????????? ??? ????? ??????? ?????? ?????? ???????/??????? ???? ??? ???? ???????.
  • ???? ?? ???? ??????? ?????? ???????? ????? ??? ????? ???? ?? ??????? ?? ????? ??????? ?????? ?????? ??? ?????? ??? ?????? ?? ?? ??? ????? ??????????.
???? ??? ??????? ???? ????? ?? ???? ????? ??????? ??????? ????? ??????? ?????? ????? ??? ???????? ???? ??? ??? ??? ??????? ????? ???????. ?? ??????? ?????? ??? ?? ???? ????? ???? ???? ????? ????????. ??? ??? ? ???????? ?????? ? ??? ????? ?????? ??? ?? ??? RAM ???? ???? ????????? ?????? SQL Server ?? ??? ?????? ?????. ?? ???? ???? SQL ?????? ??? ??????? ??????? ???????? ?? ??? ???? ?? ???? ??? ????? ??????? ????.

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

?? ???? ????? ???????? ??????? ??? ???? ??? Excel ??? ??????? ?? ????????. ??? ?? ????? ????? ???????? ????? ?? ????? ?? ?? ??????? ?????????? ????? ????? ???????? ????? ALTER ????? ?????? ???????? ???? ????? ??? ????? ???????? "??????? ???" ?????? ???? ??? ????? ???? ??????? ??????, ?? ???? ??????? ??????. ???????? ??? ????????? ????? ??? ?? ????? ????? ???????? ?? ????? ??????? ??????? ?????? ???????? ??????? ???? ??? ????????? ?? ????? ??????? ?????? ?????? I/O ???????.

????? ??? ????? ????? ???????? ?????? "????? ???????" ??? ?????? ??? ????? ??????? ????? ???? ?? ????? ???????? WAL.

??????

????? ??? ????? ??????? ??????? ??? ????? ??????? ?????? ????? ???????? ???????? ??? RAM ???? ???? "?? ???????" ??? ????????. ?? ????? ?????? ??? ???? ????? ?????? ?? ?????? ?? ?? ??? ????? ?????????? ???????? ?????? ????????? ????? ????? (ACL) ???? ???? ?????? ???? ????. ?? ???? ????? ??????? ??????? ???????? ??? RAM ???????? ??? ?????? ?? ??????? ???????? ??????? ????? ????????? ?? ??????? ??????????. ??? ???? ??????? ??? ?? ????? ??????? ???? ??? ???????? ??? ?? ??? ?????? SecureZeroMemory ?? ?? ??? ??? ???????? ?? ??????? ????????? ?????? ???? ????? ??????? ??? ???? ?? ???????? ?? ??? ??????? ?? RAM. ??? ???? ??? ??? ???? ?? ???? ????? ?? ???????? ??????? ?????? ??? ??????? ??????? ?? ???? ?? ?? ??? ????? ?????????? ? ?? ????? ???????? ??????.

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

???? Microsoft ?????? ?????????? ????? ?????? ???? ?????? ???????. ??? ??? ?? ????? ???? ??? ????, ??????? ????? ?????????? ???????? CHECKDB DBCC ??????? ??? ?? ?? ??????? ????? ?????? ??? ?????????.

??? ???? Microsoft ????? ???? ????? ??? ?????????? ???? ??? ????? ????? ????????? ??? ?????? ?? ??? ???? ?? ???????? ???????? ??????? ??????.

?????? ??? ???? ?? ????????? ??? ????? ??????? SQLIOStress ?? ?????? ???????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
231619????? ??????? ?????? ???????? SQLIOStress stress ?????? ???? ????? ??? SQL Server

????? ?????? tempdp

?? ?????? ????? ???? ????? ?????? TEMPDP ??? ??? ????? ??????? ??????. ?????? ?? ??????? ??? ?? ???? ?????? ?????? ????????? ??? ????? ???? ??????? ????? ?????? TEMPDP ?? ??? ???????. ???? ????? ????? ??????? ??????? I/O ???? ????? ??????? ? ??????? ???? ????.
917047??????? sub-system Microsoft SQL Server I/O ????? ?????? tempdp

?????

??? ????? Microsoft SQL Server ??? ??????? ???????? ?????? ????????? ???????? ????????. ??? ?????? ???????? ??????? ??? ????????? ??????? ?? ???? ????? ???????? ??? ????, Microsoft SQL Server Active ???? Exchange ???? ????? ????? ?????? ? ???? ?? ??????? ?? ????? ????? ????? ??? ??? ??? ???? ?? ??? ????? ??????? ??? ?????? said.

?? ???? Microsoft ?? ?????? ?? ??? ?? ?????? ??? ?????? ???? ???? ???? ?? SQL Server. ???????? ??? ???? ?? ???? Microsoft ??? ???? ?? ???? ?? ????? ?? ?? ???? ??? ?????? ???? ????????? ?? SQL Server.

?????

?????? ?? ???? ???????? ????????? ???????? ???????? ?? ??? ??????? ??????? ?????? ????? ???? ???? SQL:

826433????? SQL Server ?????? ????? ????? ?? ????? I/O unreported
828339?? ???? ??? ????? ????? 823 ????? ??????? ?? ????? ?????? ?? ???? SQL
234656??????? ??????? ?????? ???? ??????? ?? ???? SQL
110352?????? ?????? Microsoft SQL Server
304261??? ??? ????? ????? ?????? ???? ??????? ?? ???? SQL
910716??? "????" ????? ???????? ?????? "??? ??????" ????????? ?? SQL Server 2000 ?????? ???????? 2005
913945?? ????? Microsoft ?????? ??? ?????? ????? ?? Microsoft SQL Server
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 917043 - ????? ??? ??????: 21/????/1428 - ??????: 1.5
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbexpertiseadvanced kbinfo KB917043 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????917043

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

 

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