INF: SQL ????? ?????? ????? ??????? ???? ?? ??? ????? DBCC MEMORYSTATUS

???? ?????? ???? ??????
???? ID: 271624 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

DBCC MEMORYSTATUS ???? SQL ????? ?? ??????? ?????? ?????? ?? ?? ???????? ?? ?????? ????? ??? ?? ???? ?? ?????? SQL ????? ?? ?????? ?? ????? ???? ?? ??? ?? ??????? ???-??-?????? ????????? (?? ?? ?? ????: ?????? ?????? ??? ??? ?? ??????) relate ???????? ?? ?????? ??? ?????? ??? Microsoft ?????? ?????? ???? ?? ?? ?? ???? ????? ????????? ?? ?? ????? ?????? ?? ???? ?? ????? ?? ?????? ?? ?????? ?? ??????? ?? ???? ?? ?? ???? ?????? ????? ??? ?????? ?? ?? ???? ???

?? ???? ?? ?? Microsoft ?????? ?????? ???? ?? ??? ??????? ????? ???? ?? ??? ?????? ??? ?????? ?? ?????? ?? ??? ?? ??????? ?? ???? ?? ???? ??? ?? ?????? ????????? ?? ??? ???????? ?? ??? ???? ??? ??????????? DBCC MEMORYSTATUS ???? ?????? ?????? ??? ?? ???? ????? ??????? ?????? ??? ?????? ???????, ?? ?? ???? ????? ?? ???? ?????? ???? ?? ?? ???? ?????? ??? ???????? ?????????? ????????? ???? ?? ?? ???? ?? ??????? ?? ???? ???? ??????? ?????, ??????? ?? ???? ????????? ?? ???? ??????? ?? ?????? ??? ?? ???? ???

?????? DBCC MEMORYSTATUS ?? ??? ???????? ??? ??? ?? ???? ??? ?????? ?? ???? ??? ????? ??? ?? gleaned ?? ???? ??? ?? ????? ???? ?? ????? ???? ??? ??? ???????? ?? ????????? ?? ??????????? ????? ????? ?? ?? ?? ?? ???? ??? explained ???? ???? Microsoft ?????? ?????? ???? ????? ???? ??? ?????? ?? ????? ???? ?? ??????? ???????? ?? ???? ?? ???? ??? ???? ??? ?? ?? ???? ?? ???? ?? ???? ??? ???????? ??????? ?????? ??????

???? ???????

???? ???

???? ??? ???? ??? ??? 8 KB ?????? ?? ????? ?? ????? ???? ??? ???? ??? ??? ?? ??????? 8 KB ????? ?? ??? ??? ???? ?????? ??? ????? ????? ????? ????? ??? ??? Windowing ????????? (AWE) ????? ???? ??? ??? ?? ?????? ?? ?????????? ????? ?? ?????? ?? ????? ????? ?? ?????? ??? ??? (??????, ????? ?? ??????? ???? ??? ??, ?? ???? ??? ???? ??? ??, IO, ?? ???? ??)? ?? ??? ?????? ?????? ????? ?????? ????? ?? ?????? ????? ???
Buffer Distribution              Buffers     
------------------------------   ----------- 
Stolen                           241
Free                             95
Procedures                       89
Inram                            0
Dirty                            16
Kept                             0
I/O                              0
Latched                          18
Other                            880

(9 row(s) affected)
				
Stolen.Stolen?????? ????? ???? ?? ??? ???????? (?????? ?????????? ??????) hashing ?? ???, ?? ???????? ???? locks, ????????? ?????? ?? ??????? ??????? ??? ?????? ???? ?????? ???? ?? ??? allocations ?? ??? ?? ??????? ?????? ?????? ?? ??? ??? ????? ???? ?? ??? ?? ?? ?? ?????? ?? ??? ????? ??? ??? ?? ?????? ?? ????? ???? ??? ???? ???? ?? ??? lazywriter ????????? ?? ?????? ???? ??Stolen?????? ???? ??? ?? ???? ???

?????.????????? ?????? ???? ??? ????? ??? ??? ?? ?? ???????? ???? ??? ?? ???? ?? ???? ?? ??? ?????? ???, ?? ?? ???? ??? ?????? ?????? ?? ?? ?? ?? ??? ??? ??????? ???? ?? ???? ??Stolen.

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

Inram.Inram?????? ?? ?????? ???? ?? ???? ?? ??? ??? ?? ???????? ?? ??? ??????? ?? ???????? ???? ?? (DBCC PINTABLE ???? ?? ????? ???? ??? ??? ???? ??? ?? ??sp_tableoption???????? ?????????)?

Dirty.Dirty???? ??? ???? ??? ?? ?? ???? ??? ????? ???????? ??? ???? ??????? ?? ??????? ?? ????? ?? ????

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

I/O.I/O?????? ?? ??? ????? i/O ???????? ?? ????????? ?? ??? ??? ?? ???????? ???? ??? SQL Server 2000, ?? ????? ????? ?????? ?? AWE ?? ?????? ?? ?? ???? unmapping ???

Latched. Latched ?????? ??????? ?????? ???? ??? ??????? ??? ?? ?? ????? ?? ???? ?????? ??????? ???? ?? ?????? ??? ??? latch ?? ???? ?? ?? ???????, ?? ?? ????? ??????? ?? transactional ??????? ????????? ???? ?? ??? ????? ???? ???? ?? ?? ????? ??? ???? ?? ????? ?????? ?? ????????? ???? ?? ??? ????? ???? ???? ???

????. ?? ?? ??? ???? ???? ???? ???????? ?????? ?? ??? ?? ???? ????? ???? ??????????, ?? ?????? ?? ??? ???? ?????? ?? majority hashed ???? ?? ??? ???? ??? ??? ??????????? ??????

????? ???

????? ??? ??? ??? ?? ??? ???? ?? ???? ??? ?? makeup ?????? ???? ?? ???? ???? ???? ???
Buffer Counts                  Buffers     
------------------------------ ----------- 
Committed                      1339
Target                         6318
Hashed                         914
InternalReservation            120
ExternalReservation            0
Min Free                       16

(6 row(s) affected)
				
???? ?????Microsoft ??? ???? ?????? ?? ??? ?????? Windows NT.??????? ?? ??????? ???? ??? ?? "????" ??? ??? AWE ????? ?????? ?? ????? ?????? ?? ?? ??? ??? ????? ???

??????. ?????? ???? ??????, ?? ???? ???? ???? ??? ??????? ???? ?? ???? ??? ?????????count is greater than theCommittedvalue, the buffer pool is growing. ?????????count is less than theCommittedvalue, the buffer pool is shrinking. The lazywriter process uses this value to determine whether to grow or to shrink the buffer pool.

Hashed. The number of data and index pages that are stored in the buffer pool.

InternalReservation. The number of pages that the buffer pool keeps for itself. TheInternalReservationvalue is the minimum number of pages that are required to satisfy the simple data demands for the current number of users.

ExternalReservation. ??? ????? ???? ?? ??? ??? ???????? ???? ????? ?? ????? ?? ??? ???? ??? ?? ?? ???? ??? stolen ?????? ?? ??? ??????? ???? ??? ?? ?? ??????? ?? ??????? ?? ?? ????? lazywriter ???? ?? ??? ?? ????? ?? ??? ??? ?? ???? ???? ??? ?????? ??? ?????? ?? ??? ??? ????? ???????? ???

??????? ?????. ???? ??? ???? ???? ?? ???? ?? ?????? ???? ??????? ?? ??????? ??? ???? ??? ????? ??????????? ??????? ???, ???? ??? ?????? ?? ???? ??? ?????? ????? ?? ????????? ??? ?? ?????? ???????????? discarding ?? ????? ???? ?? ????????? ???? ?? ????

????? ???

????? ??? ?? ????????? ??? makeup ?? ????? ???? ???
Procedure Cache                Value       
------------------------------ ----------- 
TotalProcs                     17
TotalPages                     89
InUsePages                     40

(3 row(s) affected)
				
TotalProcs. ??????? ????????? ??? ??? ??? ?? ?? ?????????? ?? ??? ??????? ?? ??? ??? ???????????? ?? ?????? ?? ??? ???? ?????syscacheobjects??????? ??????? SQL ?????: ??? ??????? ???????? ?? ????? ??????????--??????, triggers, ???????????? ?? ?? ??? ?? ??? ?? ?????? ?? ?? ??????? breakdown ?? ??? ?????? ???? ?? ??? ???? ???????? ?????? ?? ????? ?? ?????

TotalPages. ????? ??????? ?? ?????? ?? ????? ???????? ?????? ???? ?? ??? ???? ??????

InUsePages. ????? ????????? ??? ??? ?? ???????????? ?? ????????? ??? ??? ?? ?? ??????? ?? ??? ???? ???? ?? ?????

???? ???

???? ??? ????? ??? ????? ??? ?????? ?? ??? stolen ?????? ?? ??????? ????? ?? ????? ???? ??? SQL ????? ?? ???? allocations ?? ??? ???? ??? ????? ?? ????? ???? ?? routines ?? ???? 8 KB ?? ??? ???? ??? ?? allocations ?? ??? ???? ???????? ?????? ?? ???? ???????? ?? ????? ?????? ????????? ?? ???? ???? ??? ?? ??? allocations ???? ??? ?? ???? ???, ?? ?? ??? ??????? ??? ?? ???????? ?? allocations ?? ??? ???MemToLeave???????? ?? ??????? ?? ???? ?? ????? ?? ???? ??? ????????? ???? ?? ????-g????-?????? ???????

??????????, majority ?? ?????? allocations ??MemToLeave??? ?? ??? - SQL ????? ?? ??? ???-????????? COM ????????, ???? ?? ?????? consumers ????????? ???????? ???????????? ?? ???? ??? ?? ?????? ???????? ?????? ?? ??????? ????? DBCC MEMORYSTATUS ??? ??????? ?? ???? ??? ?? ???? ???????????MemToLeaveallocations ?? ??? ?????? ??? ?? SQL Server ????? ???? ?? ???? allocations ?? ??? ??MemToLeave?? ?? ???? ????? ???? ????? ??? ??????? SQL ????? ?? ?? ?????? ???????? ?? ??? ????? ???
Dynamic Memory Manager         Buffers     
------------------------------ ----------- 
Stolen                         330
OS Reserved                    152
OS Committed                   138
OS In Use                      129
General                        322
QueryPlan                      87
Optimizer                      0
Utilities                      10
Connection                     40

(9 row(s) affected)
				
Stolen. (???????, ?????? ???????, ???????????, ??????????, ???????) ???? ?????? ????????? ?????? ???? ??? ?? stolen ??? ?????? ?? ??? ??????? ?? ??????? ?? 8 KB ?? ???? ???? ??? ?? ?????? allocations ???? ?? ??? ????? ???? ???? ???

OS ???????. ???????? ?????? ?? ???? 8 KB ?? ??? ???? ??? ?? ????? ?????? ????? ???? ?? ??? ?? ??????? ??????? ?? ???????

OS ????. ?????? ?? ?????? ??????? ????????? ??? ?? ???? ???? ??? ??? TheOS Committedvalue should be less than or equal to theOS Reservedvalue because buffers are first reserved and then committed. Some of the memory may be decommitted when it is no longer used.

???:There is a bug in SQL Server 2000 (that is fixed in SQL Server 2000 Service Pack 3) that causes this value not to be maintained accurately and therefore it may fall outside the valid range.

OS In Use. TheOS Committedbuffers that are currently backing outstanding memory allocations.

???????. ?????? ???? ???????? ?? ??????????? locks, ????????? ??????, ?????? ???? ???????? ???????? ?? ???????????, ?? ???? ????? ?? ??? ??????-??? ???????? ???? ????? ???? ???? ??, ????? ??? ??????? ?????? consumers ?????? ????? ???? ??? ??? ?? ??? ?? 8 KB ?????? ?? ??? ?????? ??? ????? ?? ??? ???? ??? ?? stolen ?????? ?? ???? ??, ?? ???? ????? ?? ?? ???? ??MemToLeave.

QueryPlan. ?????? transiently ?? ??? ??? ?????? ???????, ?? ???????? ???? ?? ??? ????? ???? ???? ??? ?? ??? ?? 8 KB ?????? ?? ??? ?????? ??? ????? ?? ??? ???? ??? ?? stolen ?????? ?? ???? ??, ?? ???? ????? ?? ?? ???? ??MemToLeave.

???????????. ?????? ?????? ??????????? ?????? ????? ??? ??? ?? ??? ?? 8 KB ?????? ?? ??? ?????? ??? ????? ?? ??? ???? ??? ?? stolen ?????? ?? ???? ??, ?? ???? ????? ?? ?? ???? ??MemToLeave.

??????????. ?????? BCP, ??? ???????, ?????? ????????, ???? ??????? ?????????? routines ?????? ????? ??? ??: fn_trace_gettable, ?? ????? ?? ??? ?? 8 KB ?????? ?? ??? ?????? ??? ????? ?? ??? ???? ??? ?? stolen ?????? ?? ???? ??, ?? ???? ????? ?? ?? ???? ??MemToLeave.

???????. ?????? ???? ???????? ???????? ?????????? ??????? ?? ??? ??????? ?????? ???? ?? ?????? ???? ?? ??? ????? ???? ??? ??? ?? ?? ??????? ????? ?? ??? ?????? ??? ????? ??? ?? ???? ??????? ?? ??? ?????? ?????? ??????? ????? ?? ??? ?? 8 KB ?????? ?? ??? ?????? ??? ????? ?? ??? ???? ???, ?? ???? ????? ?? ?? ???? ?? ?? ?? stolen ?????? ?? ???? ??MemToLeave.

??????

?????? SQL Server ????????
Delaney, Kalen. ?????? Microsoft SQL Server 2000, Microsoft ?????, 2000?

???

???? ID: 271624 - ????? ???????: 03 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
??????: 
kbinfo kbmt KB271624 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:271624

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

 

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