???? ID: 321363 - ????? ???????: 04 ?????? 2010 - ??????: 2.0

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

?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

SQL ????? ??????? ???? ?? SQL Server ?????? ????? steadily ???? ?? ?? ???? ?????, ?? ?? ?? ????? ?? ??????? ?? ?? ???? ?? ??? ???? ?? ???? ???? ??? ??, ????? ??????? ?? ???????? ?????? ?? ???? ?? ?????? ????? ?? ???????? ?? ?????? ????? ?????? ?? steadily ?? ?? ?????? ?????? MB ?? 4 ?? 10 ?? ??? ???

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

???????? ??? ??, SQL Server ?????? ??? ?? grows ?? ???? ???? ??? (???) ????? ?????? ??? ???????? ?????? ?????? ??????? ?? ???? ?? ?? ???? shrinks. ?? ?? ???????? ?????? (4-10 MB) ??? ?????? ?? ????? ?? ??? ?????? ??, SQL Server ???? ??? ????? ???? ???? ?????? ?? ?? ???????? ?? ???? ??????????? ?? ??? ??? SQL Server ?????? ??????, ?? ??? ??? SQL Server ???? ??????? ????? ?????? ?????? ???? ???????? ??? SQL ????? ????? ?? ?????? ?????? ????? ???????? ???? ?? ??? ???????? ???? ?? ??? ??? ?? ??? ??, ???????? ????? ?????? ?? ?? ?????????? ??????? ?? ???? ????

???? ???????

???? ?? ????? ?????? (???? ???) ?????? ?? ?????? ?? ?? ??? SQL Server ??????? ????? ?????? ????? ?? ??????? ?? ???? ?????????? ????? ??????, ???????? ????? ????????????????? ??????? ???? ???? ?? ?? ?????????? ????? ??????, ???????? ????? ???????????? ?? ???, ????? Microsoft ???????? ???? ??? "??????" ?????? ??? ??? ?????? ?? ?????????? ????:
319942  (http://support.microsoft.com/kb/319942/EN-US/ ) TO HOW: ???????? ???? SQL ????? ??????????? ????????
?? ????????? ????? ??????option only limits the size of the SQL Server buffer pool. The?????? ????? ??????option does not limit a remaining unreserved memory area that SQL Server leaves for allocations of other components such as extended stored procedures, COM objects, non-shared DLLs, EXEs, and MAPI components. Because of the preceding allocations, it is normal for the SQL Server private bytes to exceed the?????? ????? ??????configuration.?? unreserved ?????? ??????? ?? allocations ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
316749  (http://support.microsoft.com/kb/316749/EN-US/ ) PRB: ????? ??????? ?? ??? ?????? ?? ??? ??????? ?????? ????????? ?? ???? ???? ?? ????

??????

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

?? ???? ??? ???? ??????? ?? ?????????? ????? ????????????????? ?????? ???????? ????? ??????SQL ????? 2005 ??? ??????????? ?????? ?? SQL Server 2005 ???????? ?????? ??? "??????? ?? max ????? ?????? ?? ??????" ???? ?? ??????

???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
??????: 
kbinfo kbmt KB321363 KbMthi
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:321363  (http://support.microsoft.com/kb/321363/en-us/ )