Select the product you need help with
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. ????????????.???????????????????? ????????? ??? ?? ?? ?????? ?? ??? ??? ?? ?????? ?? ???????? ???? ??? ?? ?????? ??? ?????? ?? ???????? ????? ??????? ???????????? ?? ??? ?? ?? ??? ??? ?? ?? ??????? ?? ??? ??? 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) ??????. ?????? ???? ??????, ?? ???? ???? ???? ??? ??????? ???? ?? ???? ??? ?????????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) 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) 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 ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??. ?????????? ?? ??????? ????????? ??????? ??:271624
(http://support.microsoft.com/kb/271624/en-us/
)
| ???? ??????
 |
????? ?? ???? ????
