???????? ???????? "autogrow" ? "autoshrink" ?? SQL Server

?????? ????????? ?????? ?????????
???? ???????: 315512 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

????? autogrow ?????????? ???????? autoshrink ?? ?? ?? ??? ?????? ?? SQL Server ???????. ??? ???? ???? ????? ??? ?? ???? ????? ????????? ?? ??? ?? ????? ??? ??? autogrow ??????? autoshrink. ???? ?? ??? ??????? ??? ??????? ??????? ??????? ??? ????? ????????? ?????? ?????? ??.

??????? ????

???? ??? ??? ??????? ?????? ???????? ??? ???? ????? autogrow ??????? autoshrink.

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

  1. ????? ????? ??????? autogrow ? autoshrink ???????? ??? ????????? ???????:
    • ????? ALTER ????? ?????? (??? ????? ?? SQL Server 7.0)
    • Studio ????? ???? SQL ?? ????? ??????? SQL
    • ????? sp_dboption ??????? (????? ?? SQL Server 2005)
    ?????? ??? ??? ?????? SQL Server 2005 ??????? SQL Server ????? Studio ????? ??????? ????? ?? SQL. ????? ?? ????????? ??? ????? ????? ??? ????????? ?? SQL Server 2005 ?????? ????? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
    ?????: ????? ?????? ?? ????? ????? ??? ????? ?????? (SQL Server ????? Studio)
    http://msdn2.microsoft.com/en-us/library/ms189253.aspx
    ????? ????? ???????? (????? ????)
    http://msdn2.microsoft.com/en-us/library/ms180254.aspx
    ????? ????? ????? ?????? autogrow ??? ????? ????? ??????.

    ????? ??? ????????? ??????? ?? ???? ????? ????? ???????? ?? SQL Enterprise Manager (SEM). ?? ????? ????? ????? SQL ???????? ??????:
    sp_helpdb [ [ @dbname= ] 'name' ]
  2. ?? ?? ???????? ????????? autogrow ??? ???. ?????? ??? ??????? ?? ?????? ??? ????? ?????? ?????? ?? (???? ???? ?????? ?????) ????? ???? ????? ???????. ??? ??? ???? ??? ????? ???????? ?/?? ????? ??? ???? ????? ???????? ?? ?? ???. ???????? ??? ?????? ?????? ?? ?? ????? ???????? ??????? ?????? ??? ??? ????? ????????.

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

  • ?? ???? ????? ?????? ???? ????? ????? ????? ???? ?? ???????? ????? ???? autogrow ??? ???????? ?? ????? ???????? ?? ????? ???????? ?? ????? ???????? ?????? ????? ???????? ?? ??? ????????? ????? ??? ?????? ???????. ?? ??? ???? ???? ?????? ????? ?????? ????? ?????? ?? ????? ????? ???? ?? ???? ????????? ??? ???????? ????? ????? ??? ?? ????. ???? ????? ??? ??????? ?? autogrow ??? ?????? ????? ????????. ?????? ????? autogrow ???? ??????? "ALTER ????? ??????" ?? ??? SQL Server ??? ??????.
  • ??? ??? ?????? ?????? ????? ???? ????? ????? ????? ????? ????????? ?????? ???? ????? ????? ??? ??? ???????? ????? ??? ???????? ??? ?????? ??????? ?????.
  • ??? ??? ??? autogrow ??????? autoshrink ?? ???? ?????? ??? ???????? ?????. ???? ?? ?? ??????? ???? ????? ?? ????? ????? ?????? ?????? ?? ?????? ?????? ??????? ??? ?????????. ??? ???? ??????? ?? ???? ?????? ?????? ???? ????? ??? ??? ????????? ??? 100 ???? ???? ??? ??? ????? ???. ??? ????? ??? ????? autoshrink ?? ????? ??? ???????? ?????? 100 ???? ????. ?? ?? ?????? ??? ?????? ????? ??? ??? ????????? ????? ??? ?????? 100 ???? ???? ??? ????. ?? ??? ??????? ??? ????? ????? ??? ??????? ?? ???? ????? ????? ??? ????? ??? ???? ????? ?? ???? ????? ??? ???? ??? ????????.
  • ???? ?? ???? ????? ??????? ?? ????? ??? ????? ???????? ?? ??? ????? ??? ??? ?????? ????? ??. ???? ??? ????? ??????? ????????? ????????? ?? ????? ?????? ????? ??? ????? ??????? ???? ?????.
  • ?? ???? ????? ????? ???????? ?????? ?? ??????? ????? ?? ?? ???? ????? ???? ?? ????? ????? ????? ?? ????? ?????. ????? ????? ????? ?????? ?? ?????? ?? ??? ???????. ???? ????? ????? ??????? ?????? ????? ??? ?????? ??? ?????? ????? ??.
  • ???? ????? ????? ??? ??????? ?? SQL Server 2005 ?? ?????????? ???????. ????? ??? ??????? ????? ??????? ????? ??? ?????? ????????. ?? ??? ????? ??? ??????? ??????? ??? ????? ?????.
  • ??? ??? ???? ?????? ?? growths ????? ?? ????? ????? ?? ???? ???? ??? ???? excessively ????? ????? ??????? (VLF). ??? ???? ?? ???? ??? ????? ????? ????? ????? ??????/??? ??????? ??? ?????? ????? ???????? ????????? ?????? ?????? ???????? (CDC). ???????? ??? ???? ???? ??????? ????? ??? ????? ????? ????? ??????? ????????.

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

  • ??????? ????? ???? ??? ??????? ??? ?????? autogrow ?? ???? contingency ?? ??? ??? ?????. ?? ?????? ??? ???????? ???? ??? ???? ??????? ?? autogrow.
  • ????? ??????? ????????? ?? ?????? ??????? ????? ??????? ??????? ????? ??? ??????? ??????????. ?????? ??? ???? ????? ? ???? ?? ??? ??????? ??????? ??? ????? ?????? ??? ?????.
  • AutoShrink ? autogrow ??? ?? ??? ????? ?????? ??? "????? ????? ????????" ????????? (DBA) ???? ??? ???? ??? ????????.
  • ??? ?? ???? ??????? autogrow ???? ??? ??? ??????? ????? ????? ?????? ???????? ?? ?????? ??????. ?????? ??????? ?????????? ?? ????? ????? ?????? ??? ???? ??? ??? ??? ???? ???? ????? ????? ??? ?????? ?? ??????? ?? ?????? ?????? ??. ???? ??????? ???? ??????? ???????? ?? ?????? ??? ????? ??????? autogrow ????? ????? ???? ??? ?????.
  • ?? ?????? ??????? <maxsize>??? ??? ???? ?? ??? ???? ?? ??????? ??? ???? ??? ?????? ???? ????? ????? ????????.
  • ???????? ???? ????? ?? ????????? ????? ???? ??????? ???? ??? ????? ??? ?????? ???.

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

  • ?? ???? ????? autogrow ????? ??? ????? ???????? ???? ???? ????? ????? ???????? ??? ?????? ????? ?? ??????? ???????. ????? ??? ??? ????? ??? ????? autogrow ?????? ??? ????? ???????? ??? ???? ????? ?? ???? ?????? ??????? ???????? ??? ????? ??????. ????? autogrow ????? ???? ?????? ????? MAXSIZE ??? ??? ???. ?????? ?????? ???? ????? ????? ?????? ?????? "?????? ??????" SQL Server: "????? ?????? ??????": ??? ??? (?????) ???????? (KB) ?????? ????? ??? ???? ????? ???????? ??? ??? ????.
  • ?? ?????? ??? ??? ?????? ??? ????? ???????? ?? ??? ??????? ??????? ?? ????? ????????? ?????? ?? ?? ????? ??? ????????? ?????? ????? ??????.
  • ??? ?? ???? ????? ????? ??? ????????? ???? ??? ??? ???????? ??????? ????????. ??? ?? autogrow ??? ???????, ????? ???? ????? ??? ??????? ??? ??? ??? ?? ????? ????? ????? ?????? ???????? ????????? ????? ??.
  • ?? ?????? SQL Server ???????? ?????? ???????? ???? ?? ???? ?????? ???????? ?? autoshrink. ????? ?? ???? ???? ???? ?? ????? ???????? ???????? ?????? ?? ?????? ????? ???? ?? ?????? autoshrink. ?????? ?? ????? ???????? ?? ????? ????? ???????? ??? ??? ?????. ?? ????? ??? ????? ??? ?????? ?? ????? ???????? ?????? ???? ?? ?????? autoshrink. ????? ???? SQL Server ?? ???? ???? ????? ???????? ?? ??? ????? ?? ????? ???? ?????. ??? ???? ???? ????? ???????? ?????? round robin ????? ??????? ???? ???? ?????. ????? ???????? ??? ??? ????? ???????? ??? ???? SQL Server ????? ??? ???????? ??? autoshrink, ?? ?????? ??? ????? ?? ????? ???? ????? ???????? ?????? ??? ????? ??????.

?????

????? ?? ????????? ??? ????? ????? ??? ????? ???????? ?????? ??????? ????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
256650????? ????? ??? ????????? SQL Server 7.0
272318????? ??? ???????? ?? SQL Server 2000 ?? SHRINKFILE DBCC
317375??? ??????? ????? ???? ??? ????? ?? ???? ????? ??? ???? ??????? ???? ????? ??????? SQL Server
247751BUG: ??? ????? ????? ???????? ?? ????? ????? ????????
305635?????? ???? ???? ????? ??? ????? ????? ?????? ???? ??????
949523?????? ????? ???????? ????????? ??? ?? SQL Server 2005 ????? ???? ???? ??????? "??? ????" ? "???? ??????? Autogrowth ?????
????? ?? ????????? ??? ????? ??? ????? ???????? "? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
Database file initialization
????? ?? ????????? ??? ????? ????? ??? ??????? ?? ?????? ???? Microsoft ?????? ??? ?????:
How and why to enable instant file initialization
????? ?? ????????? ??? ????? ??????? ??? ???????? ?? ?????? ???? MSDN ??????:
Transaction log physical architecture

??? SQL Server ??? ??????; ??????: "????? ??? ?????? ??? ????????"; "????? ??? ?????????"

???????

???? ???????: 315512 - ????? ??? ??????: 29/???/1429 - ??????: 7.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbinfo KB315512 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????315512

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

 

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