????? ??????? ????? MEMORYSTATUS DBCC ?????? ??????? ??????? ??? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 907877 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ????? MEMORYSTATUS DBCC ?????? ??? ???????. ?????? ??? ????? ???? ????? ?? ??????? ?????? ??????? ??????? Microsoft SQL Server.

???? ??? ??????? ??????? ??????? ?????? ??????? ?????? ??? ???? ??????? ??????? ? ?????? ??? ??????? ??????? ????????? ? ?????? ??? ??????? ??????? ?????? ?????? ? ?????? ??? ??????? ???? ?????? ?????? ? ?????? ??? ??????? ????? ??????? ?????? ???????. ??? ???? ??????? ??? ???????? ??????? ???????? ??? ???????? ??????? ????????? ? ?????? ?????? ?????? ? ??? ??????? brokers.

????? ???

???? ????? MEMORYSTATUS DBCC ???? ?? ???? ??????? ?????? ?? Microsoft SQL Server. ????? ??????? ????? ??? ????? ???????? ?????? ??????? ??????? ?? SQL Server ?? ???????? ????? ???? ????? ?????. (????? ??? ?? ????? ?????? ??????? ???????? ??? ??????? ?? ??? ?????). ?? ???? ????? ??? ??????? ?? Microsoft ????? ????? ??? ????? ????? ???? ??? ????? ??? ??? ????? ??? ???? ?? ???? ?????? ??? ?????? ???????.

?????? ?????? ?????? (PerfMon) "?" ???? ?????? ?? ??????? ??????? ???? ???? ??? ?? ????? ?????? ?????? ??? ?????? ???????? (AWE).

???? ??? ??????? ??? ???????? ???? ????? ?????? ??? ?? ????? ????? MEMORYSTATUS DBCC. ????? ????? ?????? ?? ??? ??????? ?????? ??????? ??????? ???? ???? ????? ???. ?? ???? ????? ??? ??????? ?? Microsoft ??? ????? ??? ????? ?? ?????? ?????? ?? ????????? ??? ?????? ???????? ??????? ?????? ????????? ???? ?? ??????? ?? ??? ???????.

??????? ????

??? ????? ?? ????? MEMORYSTATUS DBCC ?? ?? ???? ????? ?? ????? ??? ??????? ?? Microsoft. ????? ??????? ????? ???????? ???? ??? ??????? ???? ??????? ??? ????????? ?????? ???? ??????. ???? ??????? ??????? ???? ????? MEMORYSTATUS DBCC ?????? ???? ?????? ?? ????????? ?????? ?? ??????. ?????? ?? ???? ??????? ?????? ??? ????? ?? ?? ???? ??? ????. ?? ??? ????? ?? ??????? ?????? ??? ????? ??? ????? ?? ???????. ????? ?? ??? ????????? ???? ?????? ??? ????? ???? ?????.

??? ?? ????? ????? ????? MEMORYSTATUS DBCC ?? ????????? ??????? ?? SQL Server. ????? ??????? ???? ??? ????? ?????? ???? ???? ??? ?????? ?? ??????? ??????.

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

?????? ????? ??????? ?? ???? ???????. ???? ??? ????? ????? ??????? ??????? ?????? SQL Server.
   Memory Manager                 KB 
   ------------------------------ --------------------
   VM Reserved                    1761400
   VM Committed                   1663556
   AWE Allocated                  0
   Reserved Memory                1024
   Reserved Memory In Use         0

   (5 row(s) affected)
??????? ?? ??? ?????? ?? ???????:
  • ????? VM: ??? ?????? ???? ?????? ????? ????? ??????? ???????? (VAS) ???? ?? ??? SQL Server.
  • ??????? VM: ??? ?????? ???? ?????? ????? VAS ?? ???????? ??? SQL Server. ?? VAS ????? ??????? ?? ??????? ???????.
  • ????? AWE: ??? ?????? ???? ?????? ????? ??????? ??????? ?? ???? ???? AWE ??? ????? 32-?? ?? SQL Server. ??? ??? ?????? ?????? ?????? ?????? ????? ??????? ????? ??????? ??? ????? 64-?? ?? ??????.
  • ??????? ????????: ???? ??? ?????? ??????? ???? ??? ????? ????? ????? ???? (DAC).
  • ??????? ????????? ?????: ???? ??? ?????? ??????? ???????? ?????????.

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

?????? "???? ???????" ??????? ???? ??????? ??????? ??? ???? ???????. ?? ???? ????? ???? (NUMA) "????? ???? uniform" ? ???? ????? ???? ????? ??????? ??? ???? NUMA ???????. ?? ???? SMP ???? ????? ???? ????? ????.

?????? ???? ??????? ?? ?? ?????? ?? ????? ???? ?????? ?????.
   Memory node Id = 0             KB 
   ------------------------------ --------------------
   VM Reserved                    1757304
   VM Committed                   1659612
   AWE Allocated                  0
   MultiPage Allocator            10760
   SinglePage Allocator           73832

   (5 row(s) affected)
?????? ????? ??? ????? ??? ??????? ??????? ?????? ?????? ??????? ??? ??????? ??? ??? ?????? NUMA. ??? ????? ??? ??????? ??????? ??? ???? NUMA.

??????? ?? ??? ?????? ?? ???????:
  • ????? VM: ????? ??? ?????? VAS ????? ?????? ?????? ??????? ??? ??????? ??? ??? ??????.
  • ??????? VM: ????? ??? ?????? VAS ????? ?????? ?????? ??????? ??? ??????? ??? ??? ??????.
  • ????? AWE: ???? ??? ?????? ??????? ??????? ?? ???? ???? AWE ??? ????? 32-?? ?? ??????. ??? ??? ?????? ???? ?????? ????? ??????? ????????? ??????? ??????? ??? ????? 64-?? ?? ??????.

    ?? ???? ????? NUMA ????? ?? ???? ??? ?????? ??? ????? ?? ?????. ??? ???? ?????? ????? AWE ????? ?? ?????? "???? ???????" ???? ?????. ????? ??????? ??????? ?? ??? ????? NUMA ??????? ??????? SQL Server: "???? ?????? ??????" ?????? ??????. (????? ?? ?????????? ???? ??? SQL Server ???????.)
  • ???? multiPage: ???? ??? ?????? ??????? ??????? ???? ???? multipage ?????? ?????? ??????? ??? ??????? ??? ??? ??????. ??? ??????? ???? ?? ???? ???? ?????? ??????.
  • ???? SinglePage: ???? ??? ?????? ??????? ??????? ???? ???? ???? ????? ?????? ?????? ??????? ??? ??????? ??? ??? ??????. ??? ???? ??? ??????? ?? ????? ?????? ??????.
?????? ????? ??? VM ???????? ? ??? ???????? VM ??? ???? ????? ??????? ????? ??? ?????? ?? ????? ???????? ??? ??????? ???? ?? ?????? ????? ???????.

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

?????? ?????? ??? ??????? ????? ??????? ??? ??? ???? ??? ???? NUMA. ??????? ????? NUMA ?? ???? ????? ????? ??? ???.

?????? ????? ?????? ?????? ??? ??? ?? ???????.
   MEMORYCLERK_SQLGENERAL (node 0)                                  KB 
   ---------------------------------------------------------------- --------------------
   VM Reserved                                                      0
   VM Committed                                                     0
   AWE Allocated                                                    0
   SM Reserved                                                      0
   SM Commited                                                      0
   SinglePage Allocator                                             592
   MultiPage Allocator                                              2160

   (7 row(s) affected)

   MEMORYCLERK_SQLGENERAL (node 1)                                  KB 
   ---------------------------------------------------------------- --------------------
   VM Reserved                                                      0
   VM Committed                                                     0
   AWE Allocated                                                    0
   SM Reserved                                                      0
   SM Commited                                                      0
   SinglePage Allocator                                             136
   MultiPage Allocator                                              0

   (7 row(s) affected)

   MEMORYCLERK_SQLGENERAL (Total)                                   KB 
   ---------------------------------------------------------------- --------------------
   VM Reserved                                                      0
   VM Committed                                                     0
   AWE Allocated                                                    0
   SM Reserved                                                      0
   SM Commited                                                      0
   SinglePage Allocator                                             728
   MultiPage Allocator                                              2160

   (7 row(s) affected)
?????? ?????? ?? ?????? ??? ???? ????? ???? NUMA ???? ????????? ???? ???? ?????? SQL Server. ?????? ????? ?????? ??????? ???????? NUMA ????? ???? ?? ????? NUMA ??????? ?? ???? ??? ???? SMP. ????? ?? ????? ??? ???? ?????? ????? ???????? ???????? (CPU) ??? ???? ??? ??????? ??? ????? ????? 17152. ??? ????? ??? ????? ?? ??? ??????? ?? "???? ???????" ??? ??? ????? ???? SQL.

?????? ???? SMP ?????? ???? ???? ??? ??? ??? ??????. ???? ??? ?????? ??????.
   MEMORYCLERK_SQLGENERAL (Total)                                   KB 
   ---------------------------------------------------------------- --------------------
   VM Reserved                                                      0
   VM Committed                                                     0
   AWE Allocated                                                    0
   SM Reserved                                                      0
   SM Commited                                                      0
   SinglePage Allocator                                             768
   MultiPage Allocator                                              2160

   (7 row(s) affected)
????????? ?????? ?? ??? ??????? ??? ??????? ????????:
  • SM ????????: ????? ??? ?????? VAS ????? ?? ??? ???? clerks ??? ????? ???? ?????? ????? ??????? ???????? API. ????? ??? API ????? ??????? ????????.
  • SM ???????: ????? ??? ?????? VAS ????? ???? clerks ??? ????? ???? ?????? ????? ??????? ???????? API.
????? ?????? ??? ??????? ??????? ??? ??? ???? ???? ????? ??????? ???????? ????? ????? ??????? ????? sys.dm_os_memory_clerks (DMV). ?????? ????? ?? ?????? ????????? ??????:
select 
	type,
	sum(virtual_memory_reserved_kb) as [VM Reserved],
	sum(virtual_memory_committed_kb) as [VM Committed],
	sum(awe_allocated_kb) as [AWE Allocated],
	sum(shared_memory_reserved_kb) as [SM Reserved], 
	sum(shared_memory_committed_kb) as [SM Committed],
	sum(multi_pages_kb) as [MultiPage Allocator],
	sum(single_pages_kb) as [SinlgePage Allocator]
from 
	sys.dm_os_memory_clerks 
group by type

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

???? ?????? ?????? ????? ??????? ??????? (KB) 8 ???????? ?? ???? ?????? ??????.
   Buffer Distribution            Buffers
   ------------------------------ -----------
   Stolen                         553
   Free                           103
   Cached                         161
   Database (clean)               1353
   Database (dirty)               38
   I/O                            0
   Latched                        0

   (7 row(s) affected)
??????? ?? ??? ?????? ?? ???????:
  • Stolen: ??? ??????? Stolen ??????? ??????? 8-KB ???? ???????? ?????? ?????? ??????. ??? ??????? ??????? ???? ?????? ????? ???? ??????? ???. ?????? ?????? ?????? ?? ?????? ??? ??????? ??????? ?????? ????? ???????? ????????. ??? ????? ????? lazywriter ???? ??????? ??????? Stolen ?? ???? ?????? ??????.
  • ?????: ???? ??? ?????? ??????? ??????? ??????? ???? ?? ??? ????????? ??????. ????? ??? ??????? ??????? ???????? ????????. ?? ?????? ???? ?? ???? ??? ??????? ??????? ?? ??? ????? ??? ??? ??????? ??????? Stolen.
  • Cached: ????? ??? ?????? ??????? ??????? ????????? ?? ????? ??????? ??????? ????????.
  • ????? ???????? (????): ????? ??? ?????? ??????? ??????? ???? ????? ??? ????? ????? ???????? ?? ??? ???????.
  • ????? ???????? (????): ????? ??? ?????? ??????? ??????? ???? ????? ??? ????? ????? ???????? ???? ?? ???????. ????????? ???? ??? ?? ??? ??? ????? ??? ??? ??????? ??????? ??? ?????.
  • ???????/???????: ???? ??? ?????? ??????? ??????? ???? ????? ????? ???????/????? ?????.
  • Latched: ????? ??? ?????? ??????? ??????? latched. ??? latched ?????? ???? ??? ????? ???? ????? ?? ????? ??????? ??????. ??? ????? latched ?????? ???? ??? ????? ?????? ?? ????? ?? ??? ??????? ??? ?????. ??? ??????? ????? ?????? ??? ??????? ??????? ?? ???????? ?? ?????? ????? ??? ???? ????? ?? ???????. ??? ??????? ????? ?????? ??? ??????? ???????? ? ?????????.

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

????? ?????? ??? ??????? ????? ??? ??????? ??????? ???? ?????? ?????? ????? ????? ???????? ???????? sys.dm_os_buffer_descriptors DMV. ?? ????? ?????? ??? ??????? ??????? ??? ??????? ???? ?????? ?????? ???? ??? ????????? ?????? ?????? ?????? ???????? sys.dm_os_memory_clerks DMV.

???? ?????? ?????? ?????? ??? ???? ?????? ?????? ???????? ??? ??????? ??????.
   Buffer Counts                  Buffers
   ------------------------------ --------------------
   Committed                      1064
   Target                         17551
   Hashed                         345
   Stolen Potential               121857
   External Reservation           645
   Min Free                       64
   Visible                        17551
   Available Paging File          451997

   (8 row(s) affected)
??????? ?? ??? ?????? ?? ???????:
  • ????: ????? ??? ?????? ??????? ??????? ????????? ???? ??? ?????. ??????? ??????? ???? ??? ????? ?? ???? ???? ????? ????? ?????? ???. ?????? ???? ?? ????? ?????? ???? ?????? ??????. ????? ??? ?????? ??????? ??????? ???? ??? ??????? ?? ???? ????? ?????? AWE.
  • ?????: ???? ??? ?????? ????? ????? ???? ?????? ??????. ??? ???? ?????? ????? ???? ?? ?????? ????, ????? ??? ???? ?????? ??????. ??? ???? ???? ????? ??? ?? ???? ???? ??? ????? ???? ?????? ??????.
  • Hashed: ????? ??? ?????? ????? ???????? ?????? ?????? ??????? ?? ????? ?????? ??????.
  • ???? ????????: ????? ??? ?????? ??????? ?????? ???? ???? ?? ???? ???? ?? ????? ?????? ??????.
  • ExternalReservation: ????? ??? ?????? ??????? ???? ?? ?? ????? ?? ??? ??????????? ???? ???? ????? ????? ??? ?? ????? ?????. ??? ??????? ?? ?? ??? ??? ????.
  • ???? ?????? ???: ????? ??? ?????? ??????? ???? ????? ???? ?????? ?????? ??? ??????? ?????.
  • ????: ????? ??? ?????? ??????? ??????? ???? ???? ???? ??????. ???? ?????? ??? ??? ??????? ??????? ?????? ?? ??? ?????. ??? ?????? ?????? ????? ?? ??????? ??????? ?????????. ??? ???? ??? ????? ??? AWE ?? ???? ??? ?????? ??? ?? ??????? ??????? ?????????.
  • ??? ????? ??????? ????????: ???? ??? ?????? ??????? ???????? ?????. ??? ??????? ?? ??? ?????? ?????? ??? ??????? ??????? 8-KB. ????? ?? ?????????? ???? ??????? "GlobalMemoryStatusEx ??????" ?? ????? Windows API.

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

??? ????? ?????? makeup ?? ????? ??????? ?????? ???????.
   Procedure Cache                Value
   ------------------------------ -----------
   TotalProcs                     4
   TotalPages                     25
   InUsePages                     0

   (3 row(s) affected)
??????? ?? ??? ?????? ?? ???????:
  • TotalProcs: ??? ?????? ???? ?????? ???????? ??????? ?????? ?????? ?? ????? ??????? ?????? ???????. ?????? ?? ???? ??? ????????? ?? sys.dm_exec_cached_plans DMV.

    ?????? ????? ????? ??????? ??? ?????????, ?? ?? ?????? ????????. ????? ??????? PerfMon ??????? SQL Server: "???? ??????? ??????" ?????? ? ?? sys.dm_exec_cached_plans DMV ?????? ??? ??????? ????? ??? ??? ???????? ??????? ?????? ??? ?????? ????????? ??????? ???????.
  • TotalPages: ????? ??? ?????? ??????? ???????? ??? ????? ???? ???????? ??????? ?? ????? ??????? ?????? ???????.
  • InUsePages: ????? ??? ?????? ??????? ???????? ?? ????? ??????? ?????? ??????? ???? ????? ??? ????????? ???? ??? ??????? ??????. ?? ???? ????? ??? ???????.

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

????? ?????? ?????? ??? ??????? ??? ?????? ??????? ???????? ??????. ????? ??? ????? ??? ??????? ??? ????? ??????? ??????? ???????? ?????? ?????????.
   Global Memory Objects          Buffers
   ------------------------------ --------------------
   Resource                       126
   Locks                          85
   XDES                           10
   SETLS                          2
   SE Dataset Allocators          4
   SubpDesc Allocators            2
   SE SchemaManager               44
   SQLCache                       41
   Replication                    2
   ServerGlobal                   25
   XP Global                      2
   SortTables                     2

   (12 row(s) affected)
??????? ?? ??? ?????? ?? ???????:
  • ??????: ???? ??? ?????? ??????? ???? ?????? ???? ????. ??? ??????? ???? ??????? ?????? ???? ??????? ??? ??? ????? ??????? ?????? ????????.
  • ?????: ??? ?????? ???? ??????? ???? ?????? ????? ?????.
  • XDES: ??? ?????? ???? ??????? ???? ?????? ????? ??????.
  • SETLS: ???? ??? ?????? ??????? ????????? ?? ????? ?????? ??? ???? ????? ?????? ???? ??????? ???? ???????? ??????? ?????? ????? ???????.
  • SE Dataset Allocators: ???? ??? ?????? ??????? ????????? ?? ????? ???? ?????? ?????? ?? ???? ????? ?????? ??????.
  • Allocators SubpDesc: ???? ??? ?????? ??????? ????????? ?????? subprocesses ????????? ?????? ? ?????? ????? ????????? ? ?????? ?????????, ?????? ????? ???????? ? ?????? ?????, ????? ???????? ? ???? ???????? ??? ??????. ????? ??? subprocesses ????? ???????? ?????????.
  • ???? SchemaManager: ???? ??? ?????? ??????? ???? ?????? ????? ???? ?????? ?????? ??????? ?????? ???? ???????.
  • SQLCache: ???? ??? ?????? ??????? ????????? ?????? ?? ?????? ad hoc ?????? ??????.
  • ????? ????????: ???? ??? ?????? ??????? ???? ???????? ?????? ?? ??????? ??????? ????? ???????? ?????.
  • ServerGlobal: ????? ??? ?????? ???? ?????? ??????? ??????? ????????? ??? ?? ??? ????? ????? ??????.
  • XP ??????: ???? ??? ?????? ??????? ???????? ??????? ????????? ???????.
  • ????? ?????: ???? ??? ?????? ??????? ???? ??? ??????? ???????.

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

??? ????? ?????? ??????? ??? "??????? ?????????". ????? ??? ?????? ???? ?? ??????? ??????? ?????????. Query memory is also known as workspace memory.
   Query Memory Objects           Value
   ------------------------------ -----------
   Grants                         0
   Waiting                        0
   Available (Buffers)            14820
   Maximum (Buffers)              14820
   Limit                          10880
   Next Request                   0
   Waiting For                    0
   Cost                           0
   Timeout                        0
   Wait Time                      0
   Last Target                    11520

   (11 row(s) affected)

   Small Query Memory Objects     Value       
   ------------------------------ ----------- 
   Grants                         0
   Waiting                        0
   Available (Buffers)            640
   Maximum (Buffers)              640
   Limit                          640

   (5 row(s) affected)
If the size and the cost of a query satisfy ?small? query memory thresholds, the query is put in a small query queue. ???? ??? ?????? ????????? ???? ?? ??? ????? ??? ???? ??????????? ???????? ?????? ?? ????? ????????.

??????? ?? ??? ?????? ?? ???????:
  • ????: ????? ??? ?????? ????????? ??? ??????? ???? ????? ??? ???? ???????.
  • ??????: ????? ??? ?????? ??????????? ???? ????? ?????? ??? ???? ???????.
  • ?????: ???? ??? ?????? ??????? ??????? ???????? ??? ??????????? ????????? ??? ????? ????? ????? ??? ??? ????? ?????. ??? ????? ?????? ???????? ???? ????.
  • ???? ??????: ????? ??? ?????? ??????? ??????? ????????? ???? ???? ????? ??? ???? ??????????? ??????? ????? ?????.
  • ??: ????? ??? ?????? ????? ????? ????????? ?????? ?????? ???? ?????????. ??? ?????? ????? ?? ?????? ?????? (??????? ???????) ???? ?? ??? ????? ?????? ?????? (??????? ???????) ??? ??? ????? ?? ????? ????????.
  • ??? ??????: ????? ??? ?????? ??? ????? ??????? ?? ??????? ??????? ???????? ?????? ??????.
  • ?????? ??: ??? ?????? ????? ????? ??????? ???? ??? ?? ????? ?????? ????????? ???? ???? ?????? ??? ??????. ???? ?????? ?? ?????? ??? ?????? ??? ???? headroom. ???? ??? ?????? ???? ???? ???? ????? ??????? ????? ??????? ????? ??? ????? ????????? ?????? ??????.
  • ???????: ??? ?????? ??? ????? ????? ????????? ?????? ??????.
  • ????: ????? ??? ?????? ?? ?????? ???????? ????????? ?????? ??????.
  • ??? ????????: ??? ?????? ???? ????? ??????? ??????? ????? ??? ?? ?? ??? ????????? ?????? ?????? ?? ????? ????????.
  • ????? ??????: ????? ??? ?????? ?? ??????? ?????? ????? ?????????. ??? ?????? ?? ???? ??????? ??? ?? "????? ?????? ????????? ????" ? "????? ?????? ????????? ????.

????? ??????

The next section is a summary of the users who are trying to optimize queries at the same time.
   Optimization Queue             Value
   ------------------------------ --------------------
   Overall Memory                 156672000
   Last Notification              1
   Timeout                        6
   Early Termination Factor       5

   (4 row(s) affected)

   Small Gateway                  Value
   ------------------------------ --------------------
   Configured Units               8
   Available Units                8
   Acquires                       0
   Waiters                        0
   Threshold Factor               250000
   Threshold                      250000

   (6 row(s) affected)

   Medium Gateway                 Value
   ------------------------------ --------------------
   Configured Units               2
   Available Units                2
   Acquires                       0
   Waiters                        0
   Threshold Factor               12

   (5 row(s) affected)

   Big Gateway                    Value
   ------------------------------ --------------------
   Configured Units               1
   Available Units                1
   Acquires                       0
   Waiters                        0
   Threshold Factor               8

   (5 row(s) affected)
Queries are submitted to the server for compilation. ????? ????? ??????? ??????? ????? algebraization ? ????? ??????. ??? ????? ??????????? ???????? ??? ????? ??????? ???? ??? ?????? ?? ??????? ????? ????? ??????? ???????.

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

??? ??? ????? ??????? ?? ???? ?? ?? ??? ????? ??? ???????????. ??? ??????? ??????? ????? ??? ??? ???? ??? ?? ??? ????????? ?????? ????????. ???? ??? ??????????? ?? ??? ????? ???????? ??? ?????? progressively ??? ??? ??????. ????? ????? ??? ?????? ??? ?????? ??????? ? ???????. ??? ?????? ????? ???????? ????? ?????? ??????? ????????.

?? ???? ????? ????????? ?????? ? ??? ???????? ????????? ??? ???? ??????? ????????. ?? ????? ????????? ?????? ??? ???? (??? 8628). ???????? ??? ???? ????????? ?? ?? ???? ?????? ??? ???? ???????? ????????? ?? ??? ?? ????? ?? ???? ???? ???. ??? ??? ??????? ????????? ??? ? ????????? ?? ??? ????????? ???? ??? ?????? ????? ??????? ???????.

???? ??? ?????? ??? ??? ?????? ????? compilations ???? ?? ??? ?????. ???????? ??? ???? ??? ?????? ????? ???? ??? ????????? ????.

brokers ???????

??? ????? ????? ???? ??????? ??? brokers ????? ????? ???? ?????? ?????? ??????? ?????? ??????? ???????? ?????. ???? ??????? ????????? ???? ???? ??? ??????? ??????? ??????? ???. ????? ?? ??? ?????? ??? ????????? ???.
   MEMORYBROKER_FOR_CACHE           Value
   -------------------------------- --------------------
   Allocations                      1843
   Rate                             0
   Target Allocations               1843
   Future Allocations               0
   Last Notification                1

   (4 row(s) affected)

   MEMORYBROKER_FOR_STEAL           Value
   -------------------------------- --------------------
   Allocations                      380
   Rate                             0
   Target Allocations               1195
   Future Allocations               0
   Last Notification                1

   (4 row(s) affected)

   MEMORYBROKER_FOR_RESERVE         Value
   -------------------------------- --------------------
   Allocations                      0
   Rate                             0
   Target Allocations               1195
   Future Allocations               0
   Last Notification                1

   (4 row(s) affected)

???????

???? ???????: 907877 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.3
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
????? ??????: 
kbmt kbsql2005engine kbtshoot kbinfo KB907877 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????907877

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

 

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