????? ??????? ?? SQL Server 2000 ?????? ????? ?????? SP4 ??? ????????? ?????? ????? ?? ?????? ???????/??????? ???????? ? stuck

?????? ????????? ?????? ?????????
???? ???????: 897284 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ???? ????? ????? ?????? (DBMS) ? ??? SQL Server ??? timeliness ?? ??? ??????? ? ??????? (I/O) ?? ??????. ?? ???? ?????? ??? ??????? ??????? stuck ?? ????? ????? I/O. ???? ???? ??? ???????? ????? ?? ????? ????? ??? ??????? SQL Server ?????:
  • ???? ????? ?????
  • ??????? ???? ?? ??? ????? ???? ????
  • ??????? ??????? ???????
  • ????? ????? ???????
  • ?????
  • ???????
  • ??????? ?????? ?? ???? I/O
?? ????? ??? ??????? I/O ???? ?????? ??????:
  • ???
  • ????? ????? ? ???????
  • ??? ????????? ??????
  • ???????? ?? ???? ??????
??? ????? ?? Microsoft SQL Server 2000 ?????? ????? ?????? Service Pack 4 (SP4) ? ????? SQL Server ???? ??? ????? ????? ? ?????? ???? ????? ?????? ?????/????? ??????? "?" ?????? ??????? "?" ??????? ?????/????? ????? ??? "?" ?????? ???????. ??? ????? ????? ???????/????? ??????? 15 ????? ?? ???? ? SQL Server ?????? ??????? ???????:
  1. ???? ?? ????? ???????.
  2. ???? ????? ??????? ??? ????? SQL Server. ?? ??????? ????? ??? ???:

    11 ?????? 2004 00:21:25.26 ???? spid1 SQL Server occurrence(s) 192 IO ????? ?????? ????? ???? ?? 15 ????? ?????? ??? ????? [E:\SEDATA\stressdb5.ndf] ?? [stressdb] (7) ?? ????? ????????. ???? ????? OS ?? 0x00000000000074D4. ??????? IO ????? ????: 0x00000000022000 ?.

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

?? ??? ??????????? ??? ??????
?? ??????????
Number occurrence(s)??? ????? ???????/??????? ???? ?? ??? ????? ??????? ?? ????? ??????? ?? ??? ?? 15 ?????.
??????? ???????? ????? ??????? "?" ??? ????? ???????? ? ? "??? ????? (????) ????? ?????? (DBID) ????? ??????".
???????? ???? ?????. ????? ??????? ???? ???? ??????? ?? ?????? ?? ?? ????? ?????? ???? ???????? ?? ???? ????? (IRP) ???? ??? I/O.
?????????? ??????? ?????? ????? ???????/??????? ?? ????? ??? ????? ???????/???????. ????? ??????? ??????? ?? ?????? ?? ?? ????? ?????? ???? ???????? ?? ???? ????? IRP.

?????? ??? ????? ????? ??????? ??? ??? ??? SQL Server ????? ???????/??????? ?? ?? ???? ?????? ?? ?????.
????? ??? ??????? ??????? ??? ?? ????? ?????? ?? ?????? ???? ??????? ???????:
  • ?? ????? ??? ????? ????? ???? I/O.
  • ?? ????? ??? ????? ????? ?????? ??????.
  • ????? ???? I/O ??? ??? ???????; ???? ??????? ????? ?? ????? ?? ?????? ?????.
  • ????? ?????? I/O ??? ?????? ??? ??? ?? ??????.
????? ?? ????????? ??? SQL Server 2000 I/O ?????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://technet.microsoft.com/en-us/library/cc966500.aspx

??????? ????

I/O stuck ? ???????? I/O

stuck I/O

?? ????? I/O stuck ??? ??? ??? I/O ?? ?????. ???? ????? ?? I/O stuck IRP stuck. ??? ??? I/O stuck ??? ????? ????? ????? ???? ????????? ?? ????? ????? ?????. ???? ???? I/O stuck ????? ??? ??? ????????? ???????:
  • ???? ????? ?????.
  • ??? ?? ???? ???? I/O.

???????? I/O

??? ????? I/O ???????? ???? ???? ?????/????? (I/O) ???????. ??? ???? ???? ????? ???????/??????? ?????? ????? ??????. ???? ?????? I/O ???????? ????? ???? ??????? ???????:
  • ????? ???????.
  • ??????? ??????? ???????.
  • ????? ?????? ????? ???? ????? ???? ????? ?????? ?? ??????? ?? ????? ????? ?????? ???? ??.

????? I/O SQL Server ? ?????? I/O ????? ?????? ????????

????? Microsoft SQL Server ??? ?????? ?? ??????? ??? ??? ???? ????? ????? I/O stuck ?? ????????. ??? ?? ???? ???? ??? ? ???? ??? ??????? I/O ???? ??????. ????? I/O ??? ??????? ?????? ???? ?????? ???????. ????? I/O ???????? ?????? ????? ???????? ??????? ?? Microsoft ? ?? ??????. ????? ????? ????? ???????? ???? ??? ??????? ??? SQL Server 2000 ?????? ????? ?????? SP4 ??? ????????? ??????? ???? ????? ????? ??????? ?? ?????? ??? ????? I/O.

?? ????? ???????? ? ????? ????? I/O ??? ???? ??? ???. ????? ?? "?" ??????? ?? ????? I/O ???????? ? stuck ??????? ??????.

?????

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

????????

??????? ?? ???? ?? ??????? ??????? ???? ???? 5 ????? ?? ????? ?? ????? ?????. ??????? ?? ???? ??? ????? ??? ???????/??????? ??????? ??? ?????. ??? ??? ????? ??? ??? ????? 5 ????? ?? ???? ??? ??? ??????? ?????? ??? ????? ????? ??????? ???????? ?? ??? "??????" ??? "??? ????? SQL Server.

???? 15 ????? ??? ???? ?????. ??? ????? ?? ???? ????? ????? ????? I/O ???????? ? stuck ???????? ????? ???? 830 ??? ?? ???? ?????? ????.

?????? ????? ??? ??? ????? SQL Server ?????? T830 ??? ??????? ???????-. ???????? T830-??????? ??? ??????? ??? ????? ????? ?? ?? ??? ??? ????? ???? SQL. ?????? ????? ?? ???? SQL Server ??? ??????? ?????? ??????? ??????? ???????:

traceoff dbcc (830 ?-1)

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

?????? ??? ??? ????? ???? ?????/????? (I/O) ???? ???? ????? ?? ???? ?? ??? ????? ???. ??? ?? ??????? ???? ??? ???? ????? I/O 10, ?? ??? ??? ???????? 10 ??? ????. ??? ?? ??????? ??????? ???? ??? ???? ????? I/O 15, ??? ???? ?? ???? ????? 15 ????? ?????/????? ?????.

???? ???? ??? ???????/??????? (IRP)

?????? SQL Server ????????? API Windows Microsoft ???????? ?????? ?? ????? ????????. ??? ???? ??????? ?????? SQL Server ??????? ???????:
  • WriteFile
  • ReadFile
  • WriteFileScatter
  • ReadFileGather
??? ??????? ?? ??? ??????? ??? ???????? ?????? Windows ??? ???? ???? ??? ???????/????? (IRP). ?????? ???? IRP ???? ?????? ??? ????????? ????????:
  • ?????? ??? ?????? ??????? ?? Microsoft.
  • ???? ????? kernel.
?????? ??? ???? ?? ????????? ??? IRP IRP ?????? ? ?? ?????? ???? Microsoft ??? ??? ? ????? ?? ?????? ???????? "IRP" ???????:
http://support.microsoft.com
?????? ????? ????? kernel ???? ????? invasive ??? ????? ????? kernel ???? ????? ????? ????? ?????? ?????? ????????? ???????. ???? ???? ??? ??? ???? ??? ??????? ?????? ??????? ???????:
  • BIOS
  • ??????? ???????
  • ?? ?????? ???? I/O ????
???? ????? ??????? ??? ????? ??????? ?????? ???????. ?? ??????? ?? ????? ???? ????? ????? ?????? ????? ???? ???? ?????? ?? ??????? ??????? ?? ??? ?????? ?????? ????? ???? ?????.

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

????? ???? ?????? ???? ????? ????? ?? ?????? I/O. ????? ????? ????? ?????? ?????? ???? ???????? ????? ??? ??????? ?? ?????? ???????? ?? stuck ?????? ???????/???????. ???? ?? ???? ????????? ?????? ?????? ???????? ??????. ????? ??? ?????? I/O. ???? ?? ???? ???? ?????? ?? ??? ???? ??????? ???? ?????? ?? ????? ????? ???????. ??? ???? ??????? ??? ???? ??????? CPU ????? ?? ?? ???? ??????? ??????? CPU ???? ??? ???? ??? ??????? ?? ???? ??? ?????? ??????? ????? ??? ?????? ?? ?????? ???? ??? ????? ????? ????? CPU ???? ??????.

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

??????? ???? I/O ??? ?????? ?????? ??????? ?????? ??? ??????? ?????? I/O ?????:
  • ????? ????? ?????/????? ?????
  • ????? ??? ????? ?????? ?????
  • ??? ????? ?????? ????? ??????
??? ???? ??????? ????? ????? ??????? ????? ?????/Transfer ??? ???? ??????? ???? ????? ??????? SQL Server ???? ????? ??? ?? 15. ??? climbs ???? ??????? ????? ?????/Transfer ???? ??? ??? ?? ?????? ?????? I/O ?? ??? ?????? ?????? ???????? ?? ??? I/O.

?? ????? ?? ?????? ?????? ??? SQL Server ????????? ??????? ?? ????? I/O ??? ?????? ??? ??? ????? ?????? ????? ?????. ????? ?? ???? ????? ????? ?????? ????? ??? ??? ???? ?????.

????? ?????? ???????? ?? ?????? ?????? Windows, "????? ???????: ????? ????? ??????/???????"?????? ??? ?? ??? ???????? ? ?????? ???? ?????? ????? ????????"??????: IO ???????? ??????/???????"? ? ??????: IO ???? ????? ??????/??????? ? ??? ????? ?????? ?? ??? ??? ???? ?????? ?????? ????? ?? ?????? ???????/??????? ?????? ?????. ???? ???????? I/O ?????? ???????? ???????? ???????? ?? ?????? ?????? ???? ??? ????????? ???? ??????. ??? ???? ?? ???? SQL Server ??????? ?? ????? ???????/??????? ?????? ??? ??????, ???? ?????? ?????? ??? ? ????? ? Parallelism ?. ?????? ??? ?????? ????? ??? ????? ?? ???????? I/O ????? ?????? ?????? ? I/O ???????? ? ?? whitepaper MSDN Troubleshooting Performance Problems in SQL Server 2008 ?? Troubleshooting Performance Problems in SQL Server 2005.

????? ? parallelism

???? ????? ????? I/O ???? ???? ??? ???? ????. ???? ??? ?????? ??? ???? I/O ?????. ?? ????? ???? ?? ????? ????? ?? ?????? (ITW) ?? ????? I/O ??? ??????. ?? ??? ??????? ??????? ?? ???? ????? ?? ??? ???? ?? ???? ??? ?????? ????? ?? ????? ?????? ???? ?????? ??? ??????? ???????:
  • ????? I/O ???? ?????? ??????? ?????? ??????? ????? ?????? ?????????.
  • ???? ????? ??????? ??? ?? ????? ??????? ?????? ????????. ????? ??? ??? ??????? ???????? ?? ????? ??????? ?????? ???????? ??? ????? ??? ??????????? ?????.
  • ???? ?????? ??? ??????? ??? ???? ?? ???? ??????? ?? ??? ???????? ?????. ?? ???? ????????? tempdb "?" ??????? ?? ???? ????? ???? ???? ?? ????.
  • ????? ??????? ?? ????? ?????? ?????? ?? ??????. ?? ???? SQL Server ????? ????????? ?????? ?????? ??? ????? ??????? ??? ??????, ?? ?????? ????? ?????? ???? ??????????? ??????? ????????. ?????? ??????? ??? "??????? ????" ?????? ???? sp_configure ?????? ???? ???? parallelism ??? 1. ??? ?? ????? ???? ??????????? ?????? ????? ????? ??????? ? ??????? ???????? ?????? ????? ???? ???. ??? ???? ??? ????? ?????? ?? ????? ??????? ???????? ??? ??? ???????? ???? ???. ????? ?????? ??? ????? ?? ???? ????. ????? ?????? ???????? ???????? ?????? ???? ?????? ????? ????? ??????? ????. ??? ???? ???? ???? ???? ????? ??? ??????? ????? ??? ??????. ???? ????? ????? ??????? ?? ?????? ?? ???????? ???????? ???????? I/O ?? ??????? CPU ????????? ?? ???????? ???????? ??????. ???? ?? ????? ??????? ??? ???? ????? ???? ???? ? ??????? ????? ??? ??? ??? ????? ???? ?? ?? ???? ???? ????? ?????? ???.

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

??? ???????? ??????? ??????? ?????? Microsoft SQL Server ??? ???? ????? ??????? ????????. ?? ????? ??? ??????? ???? ???? ?? ???? ?????? ????????? ????? ?? ?????? ????? ????? ? ?????? I/O ??????? ??? ????? ?? ????? ???? ?? ?? ??????. ???? ???? ???? ?? ?????? ?? ????? ??????? ???? ???? ?? ??? ???? ?? ????? ???????? ??? ???. ???? ????? ?? ????? ?? ??? ??????.

???? 1: ????? ??? ???? ????? ???? 45 ?????

???? ???? ???? ?????? ?????? ????? ??? ????? ??? SQL Server ???? 45 ????? ???????. ?? ??? ????? ??? ??????? ???????? ?? ????? ???????. ????? ??? ?????? ??? ??? ???????? ??????? ?????? 30 ?????.

????? ??????? ????? ?? SQL Server ? ???? ?????? ??? ??????? ??? ????? ??? ???????. ???? ??? ?????? ?????????? ????????? ?? ????? ????? ??? ??????? ??????? ?? ????? ?????. ?? ????? ????? ????? ????. ??? compounded ??????? ???? ?? ??? ????? ??????? ??????? ????????? ??????? ??? ???? ???? ???????. ????? ??? ???? ??????? ???????? ???? ?? ????? ???????. ????? ??? ???? ??? ?????.

????? ?? ????????? ??? ????????? ?????? ? ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
224453??? ??? ????? ??? 2000 ?? SQL Server 7.0
????????? ??????? ???? ??? ???????? ????? ?????????. ??? ???? ??? ????????? ?? ????? ???? ??? ?????? ?? ?????????. ???? ??? ??? ????????? ??????? ??????.

??? ????? 45 ?????, ??? ????? ????? ???. ??? ???? ??? ??? ????? ???? ??????? ?? ??? ???? ????????. ????? ??????? ??? ?? ??? ????? ?? ????? ????????? ?? SQL Server ? ???????. ????? ??? ????? ?? ????? ??????? ? ??? ????? I/O ???????? ???? ????? ???? ??? ??????.
?????
?? ???? ??????? ??? ??? I/O stuck ?? ?????? ????? ???? ???? ???? (HBA). ???? ????????? ?????? HBA ?????? ?? ??? ????? ?????. ????? ?? ??? HBA ???? ?? ??? ????? ?? ???? ????? ??????? (SAN) ? ?? ????? ???? ???? "????? ?????? ??? ????? ?????" ??? 45 ?????. ????? ?? ????? ?????? ?? ????? ??? ???????/??????? ??? HBA ??????. ?????? ????? HBA ?????? ?? ????? ?????. ???? ??? ?????? ???? ???????? ?????? ?????? ??????? ?????? ????? "????? ?????? ??? ????? ?????" 5 ????.

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

?????? ?? ????? ?????? ????????? ????????? ????? ????????? ?????? ????? ????? ???? ??????? I/O. ????? ????? ????? ??????? ??? I/O ????? ?? ?????? ??? I/O ??? ??????? ?????? ??? ??? IRP. ??? ??????? ????? ??? ?????? Microsoft ???????? ?????? ?? ??????? ????? ?????? ?????? I/O ?? ????? ??? ?????? I/O ?? ????? ?????? ????? ???? ?????.

?? ??? ???? ??? ?????? ????? ???? ????? ?????? ????? ????????? ???? ???? ???? ???????? ?? ??????? ???? ???? ?????? ??? ???? ????? ?????????. ??? ????? ?????? ????? ???? ??? ?????? SQL Server ?? ??????? ????? ????????? ?????. ??? ???? ????? ????????? ???? ????? ????????? ??? ????? ???? ????? ?????? ?? ??? ??? ????? ????? ?????????. ????? ??? ??? ????? ????? I/O. ?? ?????? ????? I/O ?????? ??? ?? ??? ???? ??? ?? ???????? ?? ??? ????????.

??? ??? ????? ????? ????????? ??? ????? ???? ???? SQL ???? ???? ???? ?? ??? ?????? ???????/??????? ?? ???? SQL ?????? ???? ?????. ?????? ???????, ?? ???? "?? ??? ????" ???? ???? ???? ??? ?????? ????? ????? ???????/???????. ????? ??? ??????? SQL Server ? ??????? ??? ???? ?????/????? (I/O) ? ?????? ?? ????? ?? ??????? ?? ??????? ??????? ??? ?????? ??? ???????/???????. ?????? ?????? ??? SQL Server ????? ?????? ?? ??????? ????? ?????? ??????? ?????? ????? ???? ???????. ???????? ??? ???? ??? ??? ??? ?? ?????? ????? ???? ??????? ??????? "?? ??? ????" ?? ???????? ??? ????? ?? ???????? ?? ????? ?????????. ??????? ??????? ???????? ?????? SQL Server ?? ????? ?? ????? ??? ????? ???????? ?? ????? ????? SQL Server ???? ???? ????? ?? ??????? reacquired ??? ???? ?????? ????? ???? ???????.
?????
??? ??? ???????? ??? ????? ????? ???????? SQL Server ?? ????? ????? ????????? ?????. ??????? ??????? ????? ????? ??????? ??? ????? ?? ??? "???? ?????".

???? 3: ??????? ???????

??? ?????? ?? ????? ??????? ???? ?????? I/O ??????? ??????? ?????? ????? ?? ?????? ??????. ??? ??? ?????? Microsoft ????? ??????? ??????? ??? ??? ??? I/O ???? ?? ????? ???????? ??? ????? ???? ????. ???? ?????? ???????? ????????? ?? ??????. ???? ?????? ????? ???????/??????? ????????? SQL Server ?? ???? ?? ??? ??????? ??????. ????? ??? ????? ????? ??? ??????? ??????, ???? ?? ???? ???? ???? ????? ?????? ?? ??? ??? wedges ??????.
?????
??? ??? ???????? ????? ????? SQL Server ?????? ????????. ??? ???? ?? ??? ??????? ??? ????? ????? ???? ??????? ???????? ????????. ??? ???? ?????? ??? ????? ?????? ?? ???? ???????/???????.

???? 4: ??????? ?????? "?" ?????? "?" Raid ??????

?????? ?? ????? ??????? ????? ???????? ?? ??? ??????? ????????? ???? ????? ????????. ????? ???? ?????? ????? ???????? ??? ??????? ???????? ??? ?????? ??????? ??? ???????. ?????? ????? uncovered ?????? "????? ??? ????????" ?????? ??? ??? ??????? ?? ????? ??? ??????.

????? ?? ??? I/O ????? ???? ????? ??? ????? ???????/??????? ?????? ????????? ??? ?????? ?? I/O ?????. ????????? ??????? ?????? ???? ???? ????? ????????? ???? ???????. ??? ???? ??? ?? ???? ??????? ?? ????? ????? ?????? raid ???? ????? ??? ?????? ??? I/O.
?????
??????? ??????? ??????? ?????? ????? ??? ?????? ??? ????? ????????? ?? ??? ?????? ????? ????? raid.

?????? 5: ???

?? ???? Microsoft Microsoft SQL Server 7.0 ?? ????? ?????? Microsoft SQL Server 2000 ?????? ????? ??? ?????? ??????? ????????. ??? NTFS ??? ????? ?? SQL Server ??? ??? NTFS ????? ???????? ????? ?????? ??????? (WAL). ????? ??? NTFS ????? ?????? ????? ??? ????? ???????/???????. ???? ??? "?? ??? ????" ??? ?????? ???? ????? ?? ???? ?????? ????? ?? ??????.
?????
??? ??? ???????? ????? ??? ???????? ?????? ?????.

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

???? ?? ???? ????????? ??? ???????? ???????? ?? ???? ?????? sysprocesses ????? ?? ????? ???????? I/O. ?????? ?????? I/O ????? ???????? ?????? ????? ????? writelog ?????? ??????? ?????? ???? ???? I/O.

?????? ??? ???? ?? ????????? ??? ????? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822101??? waittype ?????? lastwaittype ?? ?????? master.dbo.sysprocesses ?? SQL Server 2000 ? SQL Server 2005

?????

231619????? ??????? ?????? ???????? SQLIOStress stress ?????? ???? ????? ??? SQL Server
826433????? SQL Server ?????? ????? ????? ?? ????? I/O unreported
230785????? SQL Server 2005 ? SQL Server 2000 ?? SQL Server 7.0 ? ????????? ????? ???????? ????? ?????? ????????
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 897284 - ????? ??? ??????: 14/?????/1430 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2000 Service Pack 4
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbinfo kbtshoot kbsqlserv2000sp4fea KB897284 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????897284

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

 

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