????? SQL Server 2005 ? SQL Server 2000 ?? SQL Server 7.0 ? ????????? ????? ???????? ????? ?????? ????????

?????? ????????? ?????? ?????????
???? ???????: 230785 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ????? ????? ?? ????? ????? ????? ?????????? ???????? ?? ??????? Microsoft SQL Server ??????? ?????? ?????? ???????? ??????.

????? ?? ????????? ??? ???????? ???????? ?????? SQL Server 7.0 ? SQL Server 2000 ? ???? "ARIES (???????? ????????? ? ?????? Exploiting ???): ????? ??????? ??????? Supporting ??? - ????? ????? ? Rollbacks ??????? ??????? ????? ????? ???????" ? ?? ????????? ACM ??? "????? ????? ????????". ??? ????? ??? ??????? ??? Chunder Mohan.

????? ??? ??????? ???????? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ?????? ?????? ???????? ?????? ?? ??? ????? ??? ?????.

?? ???????? ????? ???????? ??????? ?? ????? ?????Microsoft ?????? ??? ????? ?????? ??? ??????? ?????? ? ??????? ??? ??? ?????????:
86903??? ??????? ?????? ???????? ?? SQL Server
46091??????? ????? ?????? ??????? ?????? ???? ???? ?? ???? SQL
234656??????? ??????? ?????? ???? ??????? ?? ???? SQL

??????? ????

??? ????? ?? ?????? ??????? ??? ????? ??? ????????? ????????? ?? ???? ??? ??????? ?? ????? ??????.
?? ??? ??????????? ??? ??????
??????????
????? ??? ??????? ???????? ???????? ?????? ? ????? ????? ????????? ???? ???????? ??? ??? ?????? ???? ?????? ???? ??????? ?????? ?????? ???? ????? ????????.
?????? ??? ??? ????? ????? ???? ??? ????? (UPS). ?? ???? ?? ????? ??????? UPS ?? ???? ??? ??????? ?? ???? ??????? ??????.
????? ??????? ?????? ???? ??????? ??????? ????????? ?? ????? ?????? ???????/??????? ?????? ????? ??????.
???? ??? ?????? ???? ????? ??? ??????? ???????? ???? ???? ??? ??? ??? ??????? ??????????. ?????? ??? ???? ?? ????????? ???????? ??????? ??????? ???? ??? ???? ????? "??? SQL Server ???????".
??? ?? ??? ???? ?? ????? ?? ?????? ??? ?????? ?? ????? SQL Server. ????? ???????: ?????? ?????? ? ????? ????? ?????????, ????? ??????? ? ?????? ?????? ??????? ? ??????? ? ?????? ???? ???????, ??? OS ???.
???? ??? ?????? ?????? ????? ??????? ?????? ??????? ??????.
????? ???? ?????? ???????? ?????? ????? ??????? ???????.
????? nonvolatile ?? ????? ???? ??????? ??? ?????? ??????.
???? ??????? ?????? ???? ???? ?? ?????? ????? ??????? ?????? ?? ???? ??? ??? ??????? ?????????? ??? ??? ????? ???? ??????? ????? ??????? ?? ???? ????? ??????????.
????? ?????????? ??? nonvolatile ??????? ".
????? ???????? ?? ????? ??? ?? ???? ???? ????? ??? ?????.
SQL Server 2005 ? SQL Server 2000 SQL Server 7.0 ??????? SQL Server ? ?????? ?? ?????? ??????? ????? ???????? ?? ????? ????? ??????? ?????????? ??????? ????? ????? (WAL).

???????? ??????? ????? ????? (WAL)

???????? ????? ????? ?????? ???? WAL. ??? ???? ??? ????? ?????? ????? ?? ????? ??????? ???????? ????? ???????? ? ??????? ???? ???? ?? ???? ??????? ??? ???? ?????? ?? ???? ???. ??? ???????? ????? ?????? ???????? ?????? ??????? ? ??????? ???? ????? ??? ???? ????? ???? ??? WAL ??? ?????????? ????? ????????.

???? ??????? ARIES WAL ??:
???????? WAL ???? ?? ????? ??????? ???? ????????? ??? ??? ???????? ??? ?? ???? ?????? ?? ??????? ?????????? ??? ?????? ???????? ???? ?? ??????? ??????? ??????? ?????? ?? ???????? ?? ??????? nonvolatile. ??? ??? ????? ?????? ?????? ???? ????? ??? ????? ??????? nonvolatile ?????? ??? ????? ??? ????? ????? ??????? ?? ????? ??????? ???? ??? ????????? ??? ?????? ??? ??????? ??????.
????? ?? ????????? ??? "?????" ????? ????? ???? ????? "??? SQL Server ???????".

SQL Server ? ?? WAL

SQL Server 2005 ? SQL Server 2000 SQL Server 7.0 ? ????????? ??????? ?? SQL Server ??????? ?????????? WAL. ????? committal ???????? ?? ?????? ??? ?? ???? ???? ????? ??????? ???????? ???????? ???? ?? ??????? ??????????.

?????? ??? ???? ???????? ?????? ?????? ????? (??? ???? ??? ?????? ????? ?? ???? ?? ???? ?????? ???????? ?? ?????? 150).
BEGIN TRANSACTION
   INSERT INTO tblTest VALUES (1)
COMMIT TRANSACTION
				
???? ?????? ?????? ??? ????? simplistic ??????? ???????:
?? ??? ??????????? ??? ??????
????????? ???????
????? ???????? ??? ????? ??? ????? ????? ??????? ?????? ????? ???? ???? ???? ???? ????? ?????????? ???? ?? ????? ??? SQL Server ?? ????? ?? ??????? ?????.
tblTest INSERT INTO1. ??? ??????? ???????? ?????? 150 ??? ????? ??????? ?????? ???????? SQL Server ? ??? ??? ??? ????? ??????.

2. ?? ?????? latched?????? ?? ??? ????? ??? ???? ??? ?????? ??? ????? ????????.

3. ??? ????? ??? ??????? ???????? ??? ????? ??????? ?????? ?????.

4. ??? ????? ?? ???? ??? ???? ????????.

5. ????? ?????.

6. ????? ??????? ???????? ???????? ?? ?????? ?? ????? ??? ??? ?? ??? ??????? ??? ??? ???? ????????? ?? ??????? ????????.
???????? ??????????1. ?? ????? ??? ????? ????? ?? ??? ????? ????? ??????? ???????? ???????? ??????? ??????. ?? ????? ???????? ?? ???????? ??? ??? ??? ????? ????? ??????? ???? ???? ??? ??????? ??????????.

2. ?????? ???? 150 ???? ?? ????? ??????? ?????? ???????? SQL Server ? ?? ??? ??? ?????? ??? ??????? ??????????. ????? ???? ????? ??????? ???? ???? ???? ??????? ?????? ????? ??????? ??? ??? ?????.

3. ??? ????? ????? ?????????.
?? ????? ????? ???? ????? ??????. ??? ????? ?? ?? ????? ????? ?????? ???? ???????? ?????? ??? ???? ?????? ?? WAL. ?? ?????? ?????? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ???? ??? ???? ????? ??? ?????? 150 ??? ???????? ?????? ????????? ????? ??????? ??? ??????? ????? ?????? ??? ????????. ??? ????? ??? ????? ???????? ?????? ?? ???? ?????? ?? ?????? ??? ???????. ?????? ??? ??????? ????? "??? SQL Server ??? ??????" ?????? ??? ???? ?? ???????? ??? ????? ???????.

???? ??? ?????? ????? ?? ??????? ?? ???? ?? ???? ??? ????? ???????? LazyWriter ?? ???? ??????. ????? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ????? ??? ???????? ?????? ??????? ?? ??????? ??? ????????? ???????? ?? ?????? ??? ???????. ???? ??? ?????????? WAL ???? ??????? ???? ?????? ????? ??? ?????? ??????? ??? ??? ??????? ???????? ??? ?????????.

????? SQL Server ??????

SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ????? ?????? ???? ??? ????????? ?????? ??? ?? ??? ????? ??? ???? ????? (???? ???? 512 ????).

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

SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ??????? ????? ???????? 8-KB ???? (??? ?? ???) ??? ??????? ??? ??????. (?????? ??????? ???? ?????? 512 ???? ??? ???? ?????????.) ?? ???? ???? ???? ??? SQL Server ???? ????? ?????? ??????? ???? ?? ???? ?????? employing ????? ??? ????????? torn ???????.

?????? ???? torn

???? ????? ?????? ?? SQL Server 7.0 ???????? ??? ?????? ???? torn:
???? ??? ?????? SQL Server ????? ?? ?????? ???????/??????? ??? ????? ???? ??? ?? ?????? ?? ?????? ?????? ??????. ??? ??????? ??? ?????? true? ????? ?? ?????? ?? ?? ???? 512 ???? ?? ???? ????? ?????? 8 ???????? (KB) ??? ????? ?????? ??? ?????. ??? ??? ?? ???? ?? ?????? ??? ????? ????? ???? ?????? ???? ??????? ?????? SQL Server ? ?? ?????? ??? ?????? ???? ??? ????; ?? ????? ?? ???? torn. ????? ??? ????? ???? ????? torn ????? ????????? ?????? ?? ???? ?????? ?? ??? ??????? ?? ???? ??? ?????? ???? ??? ????.

??? ????? ?? ?? ????? ????? ???????? SQL Server 8 ???? ????, ??????? ????? ?????? ???????/??????? ???????? ???? 512 ????. ????? ??? ????? ?????? 16 ??? ???? ????? ????????. ???? ?? ???? ???? torn ??? ?????? ???? (??? ???? ??????? ???? ??? ?? ??????) ??? ??? ???? ???? ??????? ????? ???? 512 ???? ??? ????? "?" ????? ??????? ???????? 8 I/O. ??? ??? ????? ?????? ????? ?? ?????? ????? ???????? ????? ??? ????? ? ??? ???? ???? ????? ???????? ??? ????? ????? ????? ??? ????? ?? ??? ?? ?? ???? ???? ?????.

??????? ????? ???? ????? ???????? ??????? ?????? ?? ???? ?? ??? ????? ???????? ????? ??? ????? ?? ??? ????? ???????. ?? ??? ??????? ?? ?????? ?? ?????? torn ?????? ???? ??? true? ?? ??? ?????? ????.
?????? ?? ??? ????? ?????? ???? torn ???? ??????? ?? SQL Server 7.0. ???? sp_dboption ??? ????? ????? ????? ?? ??? ?????? ????? ??.

????? ???

????? ??????? ????? ?????? ???? ?????? ???? torn. ????? ?? ???? 512 ???? ??? ????? ?? ?????. ???? ????? ??? ????? ??????? ?? ??? ??? ???? ????? ??? ??????? ????? ???. ???? ????? ??? ???? ??? ?? 512 ???? SQL Server 7.0 SQL Server 2000 ? SQL Server 2005 ?? ???? ?? ?????? committal ?????? ???? ???? ??? ?????? ????? ??????.

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

??????? SQL Server ??????? ??????? 7.0

??????? SQL Server ?????? ?? 7.0 ?? ???? ????? ??? ?? ??????? ????? ?? torn. ?? ???????? ??? ????????? ???? ????? ??? ?????? ??? ??? ???? ??? ????? ??????? ???? ???? ??? 2 ????????. ??? ???? ????? ????????? ???? ?? ??????? ?????. ??? ??? ??? ????? ????? ???? ??? ????? ??? ? ?? ?? ?????? ??? ????? ???? ?? ???????? ??????? ???? ????.

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

??? ???? ??????? SQL Server ??? ?????? ???????? ???????? ?????? Win32 CreateFile. ????? ??????? dwFlagsAndAttributes ?????? FILE_FLAG_WRITE_THROUGH ??? ??? ?????? SQL Server.
FILE_FLAG_WRITE_THROUGH
???? ?????? ??????? ??? ????? ??????? ?????? ?? ???????? ????????? ?????? ??? ?????. ?? ??? ?????? ????? ?????? ??????? ?????? ???? ?? lazily ???? ???.

???? ?????? FILE_FLAG_WRITE_THROUGH ??? ??????? ??????? ????? ????? ????? ????? ???????? ???? ???? ?? ?????? ??????????. ?????? ??? ?? ???????? WAL ?????? ?? ????????.
????? ?????? ?? ?????? ??????? (SCSI ? IDE) ??? ?????? ?????? ??????? ?????? ?? 512 ???? ????, 1 ???? ????, ?? ????. ??? ???? ????? ?????? ??????? ?????? ???? ??????? "??? ???? ? ??? ????? ??? ??????? ???????? ??" ?????. ?? ???? ??? ??????? ?????? ????? ???? ?????? ??????? ??? ???? ?? ??? ?????? ???????. ???? ???? ????? ?????? ??????? ???? ???. ??? ??? ????? ?? ??????? ????? torn ?? ????? ????? ??? ?? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005. ????? ?????? ?????? ??????? ?? ????? ?? ??? ? ???? ?????? ??????? ?????? ???? ?? ???? ????? ????? ????? ?? ???????? ????? ???.

???? ?????? ?? ????? ??????? ???? ???? ???? ????? ????? ????????. ????? ??????? ??????? ???? ?????? ??? ???? ???????? ????????? ?? ????? ??????? ?????? ???? ???? ??????? ??? ????? ??????? ?????? ??? ?? ??????? ????. ??? ??????? ?????? ???? ????, ??? ??? ???????? unwritten ???? ???? ??? ?????? ?????? ??? ???????? ????. ?????? ?? ??? ???? ???? ??????? ??????? ????? ??????? ??? ????? ??????? ?????? ????? ?????? ??? ?????? ??????. ????? ??? ????? ??????? ????? ?????. ?? ???????? ????? ???? ???? ?? ????? ? ???? ??? ????? ??????? ????? "????? ????? ????????" ??????? ?????? ????? ???? 6 ???????? ?? ????? ??????? ??????. ??? ???? ????? ???? ????? ???????? ???? ?????.

????? ???????? ??????? ??????? ?????? ??? ???? ??? FILE_FLAG_WRITE_THROUGH ?? ???? ????? ????? ??????? ?????? ???? ???? ??? ????? ???? true ????? ????? ?? ???? ????? ????? ???? ?? ??? ?? ?????? ?? ???? ??? ????.

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

????? ????

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

????? ??????? ?????? ???? ??? ?????? ???????? ????? ???????? ?? ??? ?????. ???????? WAL ???????? SQL Server ???????? WAL ????? ??? ??? ???? ?????? ??????? ??? ????? ??????? ??????. ??? ???? ?? ??????? ????? ??????? ??????? ?????? ?????? ?? ??? ????? ??? ???? ?????? ??? ??????? ??? ???? ??????? ?????? (???? ??? ??????? ??? ??????? ??????). ?? ???? ??? ??? SQL Server ????? ??? ??????? ???? ????????.

?? ???? ????? ??????? ?????? ??????? ???????? ?? ???? ????? ?? ??????? ????????. ??? ???? ?? ??????? Win32 API WriteFile ?????? ????? ????? SQL Server ?? ?????? ??? ????? ????? ?? ??????. SQL Server ?? ?? ????? ???????? ???? ??????? API WriteFile ??? deduce ???????? ??? ??????? ?????????? ???? ????.

?????? ???????? ????? ??? ???? ??????? ???? ???????? ?????? ??? ?????? ????? ??????? ????????. ??? ?????? ???????? WAL ?????. ????? ??????? ?????? ?????? ???? ?????? ??? ????? ???????. ?? ?? ??? ????? ??????? ?????? ????? ?? ???????? ???? ????, ???? ??? ???? ???????.

??? ????? ??????? ?????? ?????? ?????? ????? ??????, ???? ?????? ?? ??????? ???? ??? ????? ?? ????????. ?? ??? ??? ?????????? "?????? ?????? ????? FILE_FLAG_WRITE_THROUGH ???? ?"

?????? ???? ????? ??????? ?????? ???? ??????? ??? ?? ???? ???? ??? ?? ????? ????????. ???? ????? ??????? ?????? ?????? ????? ??? ???????? ?? ????? ????????. ???? SQL Server ?? ??? ?????? ?? WAL ?????? FILE_FLAG_WRITE_THROUGH.

?? ????? ?????? ?? ????? ?????? ?? ??????? ???? ??????? ????? ??????? ?????? ??? ????? ????????? ???????? ????????. ?????? ????? SCSI ? IDE EIDE ????????? ??????? ?? ????? ??????? ?????? ???????.

?? ?????? ?? ??????? ??????? ??????? ?????? ??????? ?????? ??????? ?? ???? ????? IDE ?? EIDE ???? ???? ?? ?????? ?????? ????? ????? ?? ???????? ????? ?????? ??? ???? ??????? ????. ?????? ?? ????? ??????? ??????? ??????? ?? ???? ??????? ????? ???? ??????? ??????? ????? ???????.

?????? ????? SCSI ????? ?????? ??????? ?????? ??????? ???? ???? ????? ?????? ??????? ?????? ??? ???? ???? ?? ??? ???? ???????. ??? ??? ???? ?? ???? ???? ??????? ??????? ????? ??????? ?????? ??? ???????? ????????.

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

????? "????? ??????? ??????" ???? ?? "???? ???". ?? ?????? ??????? ?????? ??????? ?? ????? IDE ???? ????? ?????? ??????? ???? ???:
???? ?? ???? ??? ????? ?????. ????? ??? ????? ??????? ?????? ???? ?????? ????? ?????? ?? ?????? ?????? ??? ?????? ?????? ????? ?? ?? ??? ??????.

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

Reallocation ??????? ???????? (AWR)

????? ??????? ?????? ????????? ?????? ???????? ?? ????? ?? ??????? ??????? ????? ?????? ????????. ???? ??? ??????? ?? ??? ??????? IDE ???? ??????? ?????? ??????? ???? ???:
??? ?????? ?? ??? ?? ??????? ??? ????? ??????? ?????? ?????? ????? ????? ???????? ????? ?????? ??????? ???????. ?? ???? ???? ??? ?? ??? ????? ????? ????? ????? ?? reallocated ???? ????? ??? "?" ????? ?????? ????? ??? ???? ?????? ??????? ???????? ?? ????? ???? ???????. ??? reallocation ? ??????? ???? ??????? ????? ??? ?????.
???? ?? ???? ??? ???? ???? ???? ?? ???? ????? ????? ????????? ???????? ?????? ??????? ??????, ???? ??????? ???????? ??? ????? ???????. ???? ????? ?? ????? ????? ???? ???? ???????? ???????? WAL ??? ???? ????? ??? ??? ?????? ?? ????? ??????? ???? ?? ????? ???????. ??? ?????? WAL ?? ?????? ????? AWR ????? ?????? ??? ???? ????? ??? ???? ??? ???? ???? ?????? ???? ???????. ???? ????? ???? ????? ?????? ?????? ??? ????? ???? ???? ?? ???? ???? ???? ????? ????????, ???? ?? ??? ?????? ??????? ? ???????? ???????? ??? ????? ???????? ?????? ??? ??????? ????????.

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

???? ??? ?????????? ???? ??? ??????? ????? ????? ?????? ????? ???? ????????.
  • ????? ?????? ???? ???? ?????? ?? ????? ????????? ?? ??? ???? ?????????? ????? ?????????. ??????? ??????? ?????? ?????????? ????????.
  • ?????? ????? ??????? ????? ???????? ?? ????? ?? ????? ?????? ???????? ??? ???? ?????.
  • ???? ?? ?? ??? ????? ??????? ?????? ???? ?????? ???? ????? ????? (?????? ?????? ? ??????? ? ?????? ??????? ??? ????, ?????? ??????, lockups ? ????? ?????? ???).
  • ???? ?? ?? ???? ??????? ??????:
    • ?????? ????? ????????? ????????.
    • ???? reissue ???? ??? ????.
    • ???? ???? ???? ????? ??? ??? ??? ???????.
    • ?????? ???? ???? re-mapping ????? ???????.
  • ????? ?????? ???? torn; ???? ?? ????? ??? ?????? ?????.
  • ????? ?????? ??????? RAID ?????? ?? ?????? ??????? ???? ?? ???? ??????? ??? ???? ?? ??? ??? ??? ??????.
  • ??????? ????? ???? ??????? ?????? ???? ?????? ????? ?????? ?? ????? ????? ??? ????? ????? ???? ???????. ???? ?? ???? ??? ?? ?????.

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

?????? ???????? ?????? ?? ???? ????, ??? ?????? ?? ?? ??????? ?????? ???????? ???? ??? ???? ???? ??????. ?? ???? ?? ???????? ???? ???? ??? ????? ??????? ?????? ??????? ???? ???????.

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

????? Microsoft ????? ???????? ??? ?????? ????? SCSI ? IDE ???????? ?????? ???????? SQLIOStress. ????? ??? ?????? ???????? ???? ???? ??? ?????? ???????/??????? ??? ???? ???????? ???????? ????? ???. ????? ???????? ?????? ?????? ?????? ??????? ????? ?? ????? ??? 50 ? 70 ????? ????? ?? ????? ????? ??????? ?????? ??? ???? RPM ??? 5,200 7,200.

?????? ??? ???? ?? ????????? ??????? ??? ?????? ???????? SQLIOStress ? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
231619????? ??????? ?????? ???????? SQLIOStress stress ?????? ???? ????? ??? SQL Server
????? ?????? ?? ??????? ??????? ????????? (??? ???? ??????? Compaq Dell ? ?????? ? HP ? ???) ?????? ??????? ?? ????? ????? ??????? ?????? ???????. ??? ????? ?? ???? ???? ???????? ?? ??? ?? ?? ?????? ???? ?????? ??? ?????? ?????? ???? ????.

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

?? ??????? ???? ???? ??? - ????? ?????? SQL Server ????? ??????? ??? ?? ??? ???. ??? ????? ?????? ??? ????? ? ??? ?? ??? ??? ????? ???????? ????? ??? ??????? ??????????; ?? ???? ?? ????? ????? ??????? ??? ????? ????? ????????? ?? ???? ???.

???? ?? ???? ????? ???????? ?? ????? ??????? ?????? ??? ????? LazyWriter ?? ???? ?????? ???? ??? ??? ??????? ??????????. ????? ??????? ???????? WAL ?????? ?? ??? ??? ????? ????? ??????? ???? ???? ??????? ??????? ???? ?????? ??? ???? ??????.

??? ?? ???? ???? ???? ????? ???????? ??? ???? ????? ??????? ??????. ????? ???? SQL Server ???? (?????) ???????? ??????? ??????, ???? ?? ??? ???????? ????? ??????? ?? ??? ?????????. ??? ?? ????? ????? ???????? ??? ????? ??????? ?????? ????????, ?? ?????? ?????? ????? ??????? ???? ????????? ???????? ???? ?? ???? ???. ???? ?? ??????? ?? ???????? ?????? ?? ??? ???????? ????? ?????????? ???? ????.

????? ??????

?????? ?????? ???? ??????: "??? ??? ???? ????? IDE ?? ??????? ?????? ???? ??? ??????? ?????? ?? ?????? ???? ??? ???? ????? ?? ???????--?????" ?

?????? ?? ?????? ????? IDE ???????? ?? ??? Microsoft ?????? ????? RPM ?? 5,200 ?? ?????? ????? SCSI ?? RPM 7,200. ??? ????? ????? ??????? ????? ??????? ?????? ?? ???? ????? IDE ?? ???? ????????? ???? ?? ???? ????.

????? ??? ???? ??????? ????? ??????: "????? ???? ????????."

???? ?????? ?? ????????? ??? ?????? ?????? ????? (OLTP) ???? ????? ???? ?????? ?????. ?????? ??? ??? ??????? ?? ?? ??????? ??????? ???? ???? ??????? ?????? ???? ???? ???? ??? ??????? ????? ??????? ?? ????? ????? ?????? ????? ?????? ?? ????? ????????.

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

????? ?????? ?? ???? ??????? ????? ?? ??????? ??????? ???? ?? 512 ???? ???? ?? ???? 2 ???????? ?? ???? ??? ??? ??????.
?? ???? ???????? ?????? ??????:
CREATE TABLE tblTest ( iID int IDENTITY(1,1), strData char(10))
GO

SET NOCOUNT ON
GO

INSERT INTO tblTest VALUES ('Test')
WHILE @@IDENTITY < 10000
   INSERT INTO tblTest VALUES ('Test')
				
?????? ??? ????? ?????? ????? ?? SQL Server:
????? 84 SCSI(7200 RPM)
SCSI(7200 RPM) 15 ????? (???? ?????? ????? ????)

14 IDE(5200 RPM) ????? (????? ?????? ????)
160 IDE(5200 RPM) ?????
????? ?????? ??????? ?? ???????? INSERT ?? ???? ??????? ?? ????? 4 ????? ?? ???? ???????.

????? ?? ??? ??? ????? ????????. ???? ????????, ?? INSERT ?????? ?? ?? ?? ???? ???? ?? ??? ???? ????? ??? ???????? ??? ?? ??? ???. ????? ?? ???? 512 ???? ?? ??? ????? ???? ???? ??????? ????????? ??????.

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

????? ?? ???? ????? ?????? ????????. ????????? ??????? ????? ????? ?? ???? ??? ??? ?????? ? ??? ??????? ???? ????? ????? ?????. ??????? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ?????? ???? ???? SQL: ????? ?????? ???? ???????? ??? ??? ????????. ????? ???? ???? ?? ???? ??? Flushed "????? ????? ??????" ?? ??????? ?????? ?? ????????? ????? ??? ??? ???? ????? ????????? ?????.

???? ??? ?????? ???????? ??? ???? ???? ?? ??? ??? ???? ????? ??? ??? ?????. ?? ?????? ?????? ?? ????? ?????? ?????. ??? ???? ?? ?????? ?? ????? ????????? ???? ?? ???? ??? ??? ???? ??? ????? ???????. ???? ??????? ????????. ???? ??? ??? ???? ???? ??????? ?????? ????? ?????? ?????? ???? ????:
BEGIN TRAN
GO

INSERT INTO tblTest VALUES ('Test')
WHILE @@IDENTITY < 50
BEGIN
   INSERT INTO tblTest VALUES ('Test')

   if(0 = cast(@@IDENTITY as int) % 10)
   BEGIN
      PRINT 'Commit tran batch'
      COMMIT TRAN
      BEGIN TRAN
   END
END
GO

COMMIT TRAN
GO
				
SQL Server 6. x ?? ?? ????? ?? ???? ??? ????? ?????? ?? ?????? ?????? ??? ????????? ????. SQL Server 6. ???? x ????? ??? ?????? ??? 2 ???????? ??? ??? ????? ?????????. ??? ???? ????? ??? ????? ???? ???? ?????? ??? ???? ???? 512 ???? ?? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005. ????? ??? ????? ?????? ????? ????? ???? ???? ??????? ???????????. ??? ???? ??? explained ????? 6 ???? SQL. ?? ????? ???????? x ????????? ???????? ???.
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 230785 - ????? ??? ??????: 10/????/1427 - ??????: 5.3
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbhowto kbinfo KB230785 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????230785

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

 

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