INF: ???? Writelog ??????? ? Bufwait ???

?????? ????????? ?????? ?????????
???? ???????: 167711 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

??? ?????? errorlog SQL Server ? ?? ???? ???? ???? ????? ??????? ???????:
bufwait: bp ???? BUF_IO ? 0xd37ab0 ? pg 0x5e74e ? 0x1008 stat/0x400003 ? ???????? 0x6d4f8c1b ? bpss 0x2069e1f0
- ?? -
writelog: ???? dbid 2 dbstat2 0x22(0x22) ???? 0/1/q2 ?? = 3 waittype = 0x81
???? ??? ?????? ???? bufwait ?????? ???? writelog.

??????? ????

SQL Server ?????? ?? I/O ??????????? ??? ????????? ??? & ReadFile() & ?? ? ReadFileEx() ? WriteFile() WriteFileEx() ??? ????? ?????? ??????? ??????. ??? ??????????? Win32 API ????? ??? I/O ??? Windows NT Server ??????? ?? ??????? ???????? ?? ?????? ???? ????? ?????? ?????? ???????. ??? ???????? "? ???? ???????? ??????? ?????? ????? ??????? ?? ????? ?????? ????? ?? ???????.

????? bufwait ? logwrite ???? ??????? ?????? ?? ?? ???? ???????? ????? ?? ????? ?? ????????? ?? SQL Server. ??? SQL Server ??? ?????? ???? ?? ??? ??????? ???? ?? ??????? ?? '???? ??????' ????? (???? ???? ??????? 10 ?????) ? ???? ???? ????? ??? ???? ??? ??????. ??? ???? ???? ??? ?????? ?????? ??? ???????/??????? ?????? ??? ?? ????? ????????. ????? bufwait ?????? ?? ????? ?? ????? ???? ?? ????? ??? ?? ????? ??????? ?????? ?? ??? ???? ?? ????? ??????? ?????? ?????? ??? ?????. ????? logwrite ????? ??? ????? ?? ????? ?????.

?????? SQL Server ?????? ????? ???? ??????? ?????? ????? ??????? ?????? ??? ??? ?????????. ?? ????? ???? writelog ??? ????? ???? ????? ???????? ?? ??? dbid ???????? ??? ????? ??????? (??????) ???? ??? ??? ?????? ??????? ??????. ?? ????? ??????? ?????, ?? ??????? ????? ?????? ?????? tempdb (dbid 2) ? ?????? ??? ????? ?????? (???? = 3). ??? ????? ????? ??????? writelog ? ?? ???? ?????? ???? ???? ????????? sysprocesses ???? ??????? ??? ?? ?? ????? ?????? ??? ??????? ?????? spid "??????" ???????? ?? ????? writelog.

????? ???? ????????? ???? ??? ?????? ?????? ????? I/O ?? ?? ?? ???????? ??? ???? ?? ????? writelog ???????. ?????? ??? ???? ????? ?????? ????? ??? ????????? ???? ??? ?? ??? ???????; ??? ?? ?????? ??? ????? "??????" ???????? ???? ??????? ????? ???? ?????? exacerbate ??????? ?? ???? rollbacks ??? ????????. ??? ????? ?? SQL Server 6.5 Service Pack 2? ???? ????? ???? ? LogLRU ??????? ???????, ???? ?? ???? ??? ????? ?????? ?? ??????? ???? ????? ??????? ??? ???? ??? ?? ????? ?? ?????? ????????? ?? ??????. ???? ?? ??????? ??? ?????? ???? ????? ???????? ????? ????? ?? ????? ??????? ??????, ??? ???? ??? ????? ????? ????? ??????? ?????? ???????? ????????. ???? ????? Readme.txt ???????? ?? ???? ?????? ?????? ??? ???? ?? ????????? ??? ????? ???? ?????? ???? ???????.

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

???? ??????? ?????? ?? ????? ?????? ?????? ?????, ???? ??????? "?????? ??????" ?????? ?????? ????? ??????? ??? ??????. ?????? ?????? % Disk Time LogicalDisk ?/?? PhysicalDisk ???? ?????? ?? ??????? ??? ?????????; ??? ???? ?????? ???? ?????? ??????? ???? ???????? ??? ????? ??????? I/O ?????? ?? indications ?????? ????? ?? ?????? ??? ?????? ?????? ??. ????? ????? ?????? ??? ????? ???????? % "??? ????? ?????" ??????? ?????? "??? ??????? ??? ?????" % ? ????? ???? ???? ?? ???????? ??????? I/O ??? ??????? ?????? ??????. ???? ???? Disk Queue Length ???? ??? backlog ????? ?? ????? I/O ??? ???? ?? ????????? ?? ????? ?????? ?? ??????? ?? ????? ????? ???? ?????? ??????? ??? I/O. ???? ?????? ??? ??????? ?????? ??? ?????? ????? ?? ????? Windows NT Server ? Windows NT Server Resource Kit ??????? ??????? ?? "????? ??????? ?? Microsoft":
102020: ????? ?????? ???? ????? ?? ?????? ??????

????? ???? ??? ??????? ?? ??????? ?? ????? I/O, ??? ??? ????? SQL Server ???? ????? ????? ??? ???? ????? I/O ????? ??????: ???? ?????? ???????? I/O; lazywrite ???? ?????? I/O; ?????? logwrite; ? ???? ??????.

???? ?????? ??????? '???? ?????? ???????? I/O' ???? ?????? ???? I/O ??? ????????? ????? ????? ?? SQL Server ????? ? ?????? ??? ??????? ???????. ????? ??? ????? ??? ?????/????? ??? ?????? Windows NT Server ??? ?? ????? ???????? ????? ???? ????? ??? ???????? ????? ???. ????? ???? ????? ????? ?????/????? ??? ?????? ?????? ??? ??????? ???? ????? ? ???? ?????? ?? ?????? ?? ????????? ?????? ???? ??? ?????? ???? ?????? ???? ??? ?? ????. ????? ??? ???? ???? ??? ???? ???? ??????? ?????? ?????? ????? ????????. ??? ??? ???????? ???? ?? ????? ????? ?? ????? ??? ??????? ?? ????? ?????????? ? ?? ???? ???????? ????? ??? ??????? ??? ????? ??????????.



??????? '???? ?????? lazywrite I/O' ???? ???? ????? ??????? '???? ?????? ???????? I/O' ???? throttles ??? ??????? ??????? ???? ?? ??????? ?????? ????? Lazywriter ???? ???. ????? ????? Lazywriter ???? ??????? ???? ?? ??????? ?? ????? ??????? ?????? ??? ????? ???? ?????? ???? ??? ??????? ????? ?? ????? ??????? ?????? ????????. ??? ?????? ?? ????? ??????? ???? ????? ??????? ???????? ??? ?? ???? ???? ??????? '??????? ??????? ?????'.

????? ??????? 'logwrite ??????' ?? ???? ????? ????? ???? ????? ???????? ??? ????? ??? ??????? ??? ?????. ???? ??? ???????? ?????? ??? ????? ??? ????? ??????? ???????? ????? ??? ? ????? ???? ??? ??? ??? ?????? ??????? ??? ????? ?? ????? ??? ???????. ?? ??? ???????? ????? ????? ?????? ?? ???? ??? ???? ?? ??? ???? ???? ??? ?????? "????" ????? ??????? ??? ???? ????? ??? ???????? ????? ??? ?????? ???????. ??? ???? ????? ????? ???????? ?? ??? ??????? ???????? ???? ?? ???? ?????? ?????? ????? ??????? ??? ?? ???? ???? writelog induced ?? ???? ????? ????? ??????? 'logwrite ??????' artificially. ??? ??? ?????? ?????? ??? ????? ??????? ??? ?????? ??????? ????? hindered ?????? ?? ??.



????? ????? ??????? '???? ??????' ???? ????? ??? ?????? ???????/??????? ??? ????????. ?????????? ??? ????? ??????? ??? 10 (?????) ??? ?? ????? ???? ???? ???? ?? 10 ???? ?????? ??????? ?? ????? ????. ?? ???? ????? ??? ?????? ????? ???? ????? ?? ??? ???? unrealistically. ??? ??? ????? ??????? bufwait ?? writelog ???? ?????, ????? ????? ??? ??????? ??? ????? ?????? ???? ??? ????? ??? ???????.

??? SQL Server stresses ?????? ?????? I/O ???? ???? ???? ? ????? ????? ?????? ?? ????? ?? ????????? ?????? ?? ???? ??????? ? ??????? ??????? ???? ????? ???? ?????? ?????. ????? ???? ?????? ??????? ?????? ?????? ??? ?? ??????? ?? ???? ???? ?????? ??? stressing ?????? ?????.

??? ?? ????? ????????? ????? ?? ?? ??? ???????, ?? ????? ??? stressing ?????? ?????? ?????? ???? ?????? SQL Server. ??? ????? ???? ?????? ???? SQLHDTST ???????? ??? ?????? ????. ????? ?? ????????? ??? ?????? ???????? ?????? ???? ???? ????? ??? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
178444????? SQL Server ??????? ????????
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 167711 - ????? ??? ??????: 27/?????/1424 - ??????: 3.1
????? ???
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbenv kbhardware kbinfo KB167711 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????167711
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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