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

???? ?????? ???? ??????
???? ID: 316749 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

??? ???? ?? ???? ?? ???????? ?????? ??????? ??? ????? Microsoft SQL Server ????????? ??? ??? ??? ????? ????????? ???? ??? ????? ??? ?? SQL ????? ?? ??????? ??????????? ???:
  • ????? 2 GB ?? ???? ???? RAM ???
  • ??? ???? ?????? ??? (?????? ?? ???, 500 ?? ????) ?????? ?? ??????? ????
  • ??????? ??????? ?? ?????? ??? (?????? ?? ???, ??????? ???? ?? "????? ????" ??????)?
  • ??????? 255 SQL Server ????? ????? ?? ????? ???? ?? ??? ???????? concurrently ?????? ?????????? ??????? ????
SQL ????? ??? ????? ?????? ????? ????? ?? ???? ?? ?? whole 2-GB ??????? ??? ????? ????? ???? ???? ?? (?? whole 3-GB ??????? ??? ????? ?? ?? ????? ?? ??? SQL Server ??????????? ??????? ?? ???/ 3 GB????? Boot. ini ????? ???)?

????? 1

??????: 17802, Severity: 18, ??????: 3
????? ????? ????? ???? ??? ????

????? 2

SQL ????? process_loginread ????? ?? ??????? ???? ?? ????

????? 3

???????: ?????? ?????? ????? ???? ?? ??? ????????? ??? ??? ???? ?? ??? ???

???? ?????: Stolen = 3454 ???? 2540 ???????????? = = 138
Inram = 0 Dirty 1108 ??? = = 35
I / O = 0, Latched = 0, ???? = 214821
???? ????: ???? 222096 ?????? = 222096 Hashed = = 215964
InternalReservation 547 ExternalReservation = 0 ??????? = ???? 512 =
????????? ???: TotalProcs 8 TotalPages = 138 InUsePages = = 138
???????? ?????? ???????: Stolen = 3556
OS 497 ??????? = = 1706
????? ?????? 755 ??????????? = = 0
?????????? 9 ??????? = = 1583
??????? ?????? ????????: ?????? 1119 Locks = 163 XDES = 1 SQLCache = 90 ????????? = 5 LockBytes = 2 ServerGlobal = = 20
?????? ?????? ???????: ???? 0 ????????? = 0 ?????? = = 164370 ?????? = 164370

????

???????? ?????? ??????? ?? ??? ??? ??????? ?? ??????? ???? ?? ???? ?? ????? ??? ????? ?? ??? ?? ?? ?? ?? 64 KB ????? allocates SQL ????? ????? ?? ???? ?? ???? ??? ??????? ?? ????? ??????? ?? ??? ???? ???????? ????, ??????, ?? DELETE ??? ?? ????? ?? ????? ???? ??? Depending on the activity and the size of the generated log records, subsequent modifications might trigger the allocation of additional 64-KB allocations. SQL Server 7.0 will allocate no more than three 54-KB blocks. In SQL Server 2000, the upper number of allocations for each database is a function of the number of processors that SQL Server is configured to use.

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

?????-gstartup parameter to leave additional, unreserved virtual memory available for these database allocations. The-g??? SQL Server 7.0 ?????? ??? ?? Readme.txt ?? ??? SQL Server 2000 ???????? ?????? ???????? ???? ?? ??? "???? ???????" ??? ?? ?? ???? ??? Microsoft ??????? ???? ?? ?? ????? ?? ??? ?? ???? ??? ?? ????????? ???? ?? ??? ?????? ???????? ??? ????? ????

???? ???????

?? ?? ???????? ?? 2 GB ?? ???? ???? RAM, ??? SQL Server reserves ????? 256 MB (SQL Server 7.0) ?? ???? ??? ?? ?????? ????? ?? ??? ????????? ????????? ?? ????? ??????? ??? ????? ?? 384 MB (SQL Server 2000)? ??? ??, ????????? ?? ???? ?? ??? ??? ?? ??????? ?? ??? SQL Server ????? ???? ??? ?????? ??????? ???? ?????? ?????? ??? SQL Server ??????????? ?? ?? 8 KB ?? ????? ??? unreserved ?????? ?? ???? allocations ???? ??? ?? serviced ???? ?? ???? ?? ?? ??? ????? ?? ??? ?????? ??? ?? allocations ????? ??, ????? ?? ????? ???? ???:
  • ????? ?? SQL Server ????? ?? ?? ???? ?? ????? ?? ??? ?????? ????? ??????? ????? ??? SQL ????? ?? ??? 255 ????? ????? ????? ??, ?? ??? ?? ???? 140 MB ?? ???
  • ???? DLL ?????? ??? ?? ??? ?? ?? ??????? ???? ?? allocations ??? ?? ??? ??? SQL ????? ??? ????? (?? ?????? ?????? ?? ?????? ??), ????:
    • OLE DB ??????? ?? ??? ?? ???? ??? ?? ????? ???
    • ?? ????? ???? ??? ??? ?? COM ????????sp_OA?????? ???????????? ?? ???????? ?? ???????? ???????????? ????????? ???
  • ???? ?? ?????? (. exe ??. dll) ?? ??? ????? ??? ??? ??? ?? ??? ?? ????????? ?????: ?? ??? ?? ???? ??? ?? ????? ?? ????? ?? ??? ??? ????? 25 ?? ??? 20 MB, ?? ????? ????sp_OA, ?? ???????? ???????????? ????????? ?????
  • ????????? ??? ?? ???? ?? ???? heaps ?? SQL Server ??? ???? ??? ????????? ????????? ?? ????? ?? 10 MB ?????????? ??, ????? ??? ?? ???? ??? ?? ????? ?? ????? ?? ??? ??? ?? ?? ???? ??sp_OA, ?? ???????? ???????????? ????????? ?????
  • 8 KB, ???? ?? ???? ?????? ???????, ?? ??? ???????? ?? ???? ??? SQL Server ??????????? ?? allocations ????? ?? ??? ?????? ??????? ??????????? ????? ????8 KB ?? ??? ??? ?? ???? ??????????? ?????? ??? ?? ?????? ?? ????? ?? ??? ?????OS ?????????? DBCC MEMORYSTATUS ??? ??????? ?? ?? ?? ?? 8-KB ??????? ?? ?????? ?? ??? ??? ??????? ?? ?? ??? ?? ?? ??? ??????? ??? ??? 5 MB ????
  • ???? ???? ???? ??? ??? ?? ?? ???????? ???? ?? ??? ?????? ?? ??????? ?? ????? ???? ?? ???? ?? ?? ?????????? ???? 20 MB, ?? ?? ?? SQL ????? ?? ??? ?? ??? Windowing ????????? (AWE) ?????, which ?????? ??? ?? ?? ???? ???????????? ???? ???
????????? ?? ??? ?? ???????? ?? ?????? ???? ?????? ??? ???????, 64 KB allocations ??? ??????? ?? ??? ?????? ??? ?? ?? ???? ??? ??? ??? ??????? ??????? ???? ????? ??, ?????? allocations ???? ????, ?? "?????" ??? ???????? ????????? ??? ?? ?? ?? ???? ??? ???????????? ?? ???? ??? ????

?? ????? ??-g????????? ????????, ?? ?? ???? ??? instruct SQL Server ???????? ??????? ?????? ?????? ???? ??? ?? ?? ???-??????? allocations ?? ???? ??????? allocations ?? ?????? ??????? ??? ????? ?? ???? ???? ????? ?? ????

????? ?????? ??????? ?????? ??? ?? ??? ????? ??????? ?? ??? ??-g??????? ?? ????? ??????? ?? ?????? ?? ???? ?? ???:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????SQL Server 7.0SQL Server 2000
250-g134N/A
500-g185N/A
750-g237N/A
1000-g288-g288
1250-g340-g340
1500-g392-g392
?? ?????? ???????? ??????? ????? ?? ????? ???? ??????? ???? ??? ?? ?? ??? assumption ?? ?????? ?? ?? ?? ??? ???? ??? ?? ????? ???????sp_OA?? ??????? ???????? ???????????? ????? ??? ???? ?? ?? ?? ?? ???? AWE ????? ?? ??? ???, ?? ?? SQL Profiler ????? ??? ???? ??, assumption ?? ?????? ??? ?? ????????? ??? ?? ??? ?? ??? ?? ?????? ?? ??? ???? ??? ???? ??-g.

Microsoft ??????? ???? ?? ?? ?? ?? ????? consideration ???? ?? ???? ?? ????? ???? ????? ???? ???? ??????? ?? ??????? overhead ??????? ?? ?? ?????? ?? ?????? ?? ???? ?? ??? ?????? ??, ?? ???? ??????? ?????? ?? ???? ???, ????? ???????????? ?? ??? ??? ??? ????? ?????? ?? ???? ???????? ?? ??? ?? ??? ???

???? ??? ??, ??????? ?? ????? ?? ????? ??? ???? ?????????? ?????? ??????? ?????? ?? ??? -??????? ?????? allocations ???? ??? ???-??-?????? ????????? ?? ???? ?? ???? ?? ?? ?? ???? ?????? ?? ???, ???? ????? ?????? ????? ??????? ?? ???? ??:
??????: 701, Severity: 17, ??????: 123?
?? ?????? ?? ????? ?? ??? ????????? ?????? ?????? ???
?? ?????? ?? ?????? ?? ???-??-?????? SQL Server 2005 ??? ???? ??????? ?? ???? ?? ??????? SQL Server 2005 SQL ????? ?? ????? ????????? ?? ????-??????? ???????? ????? ?????

?? ?? ????? ??????????? ???????? ?? ????? ??sys.dm_db_index_usage_stats???????? ????????? ???????? ???? ?????? ??? ?????? ???????? ?? ???? ??? ???????? ???? ?????? ??? ?????? ?? ???????? ?? ??? ???????? ??????? ?? ??????????? ?? ????? ?????

???

???? ID: 316749 - ????? ???????: 04 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
??????: 
kberrmsg kbtshoot kbnofix kbprb kbmt KB316749 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:316749

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

 

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