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

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

?? ????? ??

??????

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

?? ???? ????? ?????? ??????? ?? ???, ?????? ????? ?? ?????? ?? ???, aggregate ?????? ?? ??????? ?? ???, ???? ????? ??????? ?? ???, ???? ??? ??????? ?? ???, ?? ????????? ??? ??????? ?? ??? ?????? ?? ???? ??? ????? ???? ?? ?? ?? ?? ?????? ??????? ?????? ???????? ?? ???? ???, ?????? ???????? ?? ?????? ???? ?? ???? ???, ?? ???? ??? ???????????? ?? ?????? brokers ?? ???? ????

?????

DBCC MEMORYSTATUS ???? Microsoft SQL Server ?? ??????? ?????? ?????? ?? ?? ???????? ?? ?????? ????? ??? SQL ????? ??? ?????? ????? ???????? ?? ?????? ???? ?? ??? ?? ??????? ???-??-?????? ????????? ?? ?????? ???? ?? ??? ?? ???? ?? ?????? ????? ?? ???? ??? (?? ???-??-?????? ????????? ????: ?????? ?????? ??? ??? ?? ??????.) Microsoft ?????? ?????? ???? ?? ?? ?? ???? ????? ?? ????? ?????? ?? ???? ?? ????? ??? ?? ???? ?? ?????? ?? ???? ?? ??????? ?? ???? ?? ?? ???? ?????? ?? ????? ?? ??? ???, ?? ?????? ?? ?? ???? ???

???:???????? ?????? (?????????? ?????? ??) ?? ????? ??????? ???? ???? ?????? ?? ??? ??? ??? ?? ??? ??? Windowing Extentions (AWE) ?????? ????? ???? ??? ???

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

???? ???????

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

DBCC MEMORYSTATUS ??????? ?? ?????? SQL ????? ?? ????? ????????? ?? ????????? ?? ??? ??? ?????? ??? ???????? ?????? ?? ????? ????????? ??? ??? ?? ??? ???????? ??? ????

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

?????? ?? ???? ???, ?????? ??????? ??? ?? ??? ?? SQL ????? ?????? ??? ?????? ????? ?????? ???
   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: ??? ?? SQL ????? ?? ???? VAS ?? ??? ?????? ?? ?????? ??? ??????? VAS ????? ?????? ?? ?????? ?? ??? ???
  • ?????? AWE: ??? ?? SQL ????? ?? 32-??? ??????? ?? AWE ??????? ?? ?????? ?? ?????? ?????? ?? ??? ?????? ?? ?????? ??? ??, ?? ?????? ?? ?????? ?? 64-??? ??????? ?? ????? ??????? ???? ??? ?????? ?? ??? ?????? ??? ?? ???? ????
  • ?????? ?? ???????: ?? ??? ?? ??????? ?????????? ??????? (DAC) ?? ??? ??????? ?? ?????? ?????? ???
  • ????? ??? ??????? ??????: ?? ??? ?? ??????? ?????? ????? ???? ?? ??? ?? ?? ?????? ???

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

???????? ?????? ??? ?? ??? ?????? ????? ?? ??? ?????? ?????? ??????? ??? ??? ??? ?? ???-uniform ?????? ????? (NUMA) ????? ?????? ???, ??? ???? ???????? ????????? NUMA ??? ?? ??? ??? ???? ?????? ??? ?????????? ??? SMP ?????? ??? ??? ???? ?? ?????? ??? ??????????

???:?????? ??? ID ????????? ??? ID. ???? ?? ??? ???? ???? ?? ???? ??
   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: ??? ?? ?????? ?? 32-??? ??????? ?? AWE ??????? ?? ?????? ?? ?????? ?????? ?? ?????? ??? ??, ??? ?? ?????? ?? 64-??? ??????? ?? ????? ?? ??????? ?? consumed ?????? ?? ??? ?????? ?? ?????? ???

    ??? NUMA-????? ?????? ???, ?? ??? ?? ???? ??????? ?? ???? ??? ???????, ????????? AWE?????? ??????? ??? ??? ??? ?? ??? ?? ??? ??? ??? ????? ?? ???-??? NUMA ????? ?????? ?????? ??, ?? ??? ?????SQL ?????: ???? ??????????? ?? ??????????? ??? (???? ??????? ?? ???, ??????????? SQL Server ????????.)
  • MultiPage Allocator: ?? ??? ?? ?? ??? ?? ?? ??? ????? ?????? multipage allocator ?? ?????? ?? ?????? ?????? ?????? ??? ?? ?????? ??? ?? ???? ??? ?? ???? ???
  • SinglePage Allocator: ?? ??? ?? ?? ??? ?? ?? ??? ????? ?????? ?? ???-????? allocator ?????? ?????? ?????? ??? ?? ?????? ???? ??? ?? stolen ?? ???
???:Sums ????????? VM??? ?????? VM?????? ?? ??? ????? ?? ??? ???? ???? ?? ?? ?????? ??????? ?????? ??? ??????? ?? ???? ??? ?? ???? ????

Aggregate ??????

???? ?????? ??? ???????? clerk ?????? ?? ??? ?? ???????? NUMA ??? ?? ??? ??????? aggregate ?????? ??? ?? 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)
???:?? ??? IDs SQL Server ??? ??? ???????? ?? ??????????? NUMA ??? ?? ??? ???? ??? ??? IDs ????? ???? ?????????? NUMA ????? ?? ????????? NUMA ????? ?? ????? ?? ?? ???? SMP ?????? ?? ????? ?? ????????? ???? ????? ?? ??? ??? IDs ?? CPU ?? ??? ?? ?????? ???????? ??? ?? ???, ????? ID ?????? 17152 ??????? ?????? ?? ????? ??? ???? ?? ????????? ??? ??? ????? ?????? ??? SQL ????? ?? ??????? ???? ???

??? SMP ?????? ?? ??? ???????? clerk ?????? ?? ??? ???? ?? ??? ????? ????? ?? ?????? ??? ????? ?? ???? ???? ???
   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: ?? ??? ?? ??? clerks ?? ?????? ?? ?????? ??? ??????? API ?? ????? ?? ??? ??? ?? ?????? ??????? ?? ?? VAS ?????? ??? API ?? ?? ?? ???? ?????? ??????.
  • ???? SM: ?? ??? ?? ?? ??? clerks ?? ?????? ?? ?????? ??? ??????? API ?? ????? ?? ??? ??? ?? ?????? ???? VAS ?????? ???
?? ????? ?? ?? ?????? ?? ??? ????? ?? ??? ???????? clerk ?????? ?? ??? ?????? ??????? ??????? ?? ???? ???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

???? ?????

???? ??? ???? ??? ??? 8-???????? (KB) ?????? ?? ????? ?????? ???
   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 ?????? ????? ?????????? ?? ??? ????? ?? ????? ???? ???? ?? ?? ????? ???? ??? ?? ?????? serve ??????? ?????? ?????? allocations ?? ??? ??? ??? ????? ?? ??????? ????? ?? ?????? ???? ???????? ?? ???????? ???? ?? ??? ?? ?????? ????? ????? ???? ??? ?? ???? Stolen ?????? ???? ???? ?? ??? lazywriter ????????? ?? ?????? ???? ???
  • ?????: ??? ?? ??? ???? ??????? ??? ????? ?? ?? ??? ???? ?????? ?????? ??? ?? ?????? ???? ?? ???? ?? ??? ?????? ???? ??, ???? ????? ?? ???? ?? ?? ?????? ?? ??? ?????? ???? ?? ???? ??? ?? ?????? ?? ??? ??? ??????? ????Stolen.
  • ???: ?? ??? ?? ??????? caches ?? ??? ????? ??? ???? ??? ?? ?????? ?????? ???
  • ??????? (?????): ?? ??? ?? ??????? ?? ??????? ?? ?? ?? ?? ??????? ???? ???? ??? ??, ?????? ?????? ???
  • ??????? (????): ?? ??? ?? ??????? ?? ??????? ?? ?? ?? ?? ??????? ???? ??? ??, ?????? ?????? ??? ?? ?????? ?????? ?? ?????? ???????? ????? ?? ?? ??????
  • I/O: ?? ??? ?? ?? ????? i/O ???????? ?? ??? ????????? ?? ?? ??? ??? ?? ?????? ?????? ???
  • Latched: ??? ?? ?????? ??latched??????? ???? ???? ?? ????? ???? ?? ?? ?? ????? ?? ??????? ?? ??????? ???? ?? ??? latched ??? ???? ??? latched ?? ?? ?? ????? ????? ?? ???? ?? ??? ?? ?? ????? ?? ?????? ??? latch ??? ?? ?? ????? ??? ???? ?? ????? ?????? ???? ???? ?? ??? ????? ???? ???? ?? ????? ?? ??????? ????? ??? ????? ??????? ?? transactional ?????? ???? ???? ?? ??? ????? ???? ???? ???

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

?? ??????? ?? ???? ???? ?? ???? ??? ??????? ??????? ??????? ??????? ?? ??? ??? ?????? ?? ????? ??sys.dm_os_buffer_descriptorsDMV. ?? ???? ??????? ?? ???? ???? ?? ???? ??? ??????? ??????? ?? ????? ?? ????? ????? ?? ?????????? ?? ??? ????? ???? ?? ??? ?? ?? ??? ?????sys.dm_os_memory_clerksDMV.

???? ??? ???? ??? ?? ???????? ??????? ?? ???? ??? ????? ?? ???? ???? ???? ???
   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)
?? ?????? ??? ???? ????? ???:
  • ????: This value shows the total buffers that arecommitted. Buffers that are committed have physical memory associated with them. The????value is the current size of the buffer pool. This value includes the physical memory that is allocated if AWE support is enabled.
  • ??????: This value shows the target size of the buffer pool. ?????????value is larger than the????value, the buffer pool is growing. ?????????value is less than the????value, the buffer pool is shrinking.
  • Hashed: This value shows the data pages and index pages that are stored in the buffer pool.
  • Stolen Potential: ??? ?? ???? ??? ?? stolen ?? ???? ??? ?? ?????? ??????? ?? ?????? ???
  • ExternalReservation: ??? ?? ?????? ???? ????? ???????? ?? ??? ??? ???????? ?? ???? ?? ??? ??????? ?? ?? ?? ?? ?? ??????? ?? ?????? ??? ?? ??????? ?? ??? ???? ??? ?? ?? ???? ??? stolen.
  • ??????? ?????: ??? ?? ?????? ?? ??????? ???? ??? ???? ???? ?? ???? ?? ?????? ???? ???
  • ?????: ?? ??? ?? ?????? concurrently ??? ??? ??? ?? ?????? ??? ?? ?????? ???? ?? ?? ??? ??? ?????? ???? ?? ???? ???? ?? ??? ????? ?? ??? ?????? ?? ???? ??? ???????, ?? AWE ?????? ????? ???? ??, ?? ?? ??? ?? ???? ?? ??? ?????? ?? ???
  • ?????? ?????? ?????: ?? ??? ?? ???? ?????? ?????? ?? ?????? ??? ?? ??? ?? 8-KB ?????? ?? ?????? ?? ??? ??? expressed ??? ???? ??????? ?? ???, Windows API ?????????? ??? "GlobalMemoryStatusEx ??????" ???? ?? ??????

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

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

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

    ???:?? ??????? ?? ???????? ???????, ?? ???? ??? ???? ?? ???? ?? ????? ?? ??????? ???? ?? ??? ?????????? ?????? ?? ?? ????? ?? ???? ???SQL ?????: ????? ??????????? ??sys.dm_exec_cached_plansDMV ?? ????? ????????, ???? triggers, ???????????? ?? ?? ??? ???????? ?????? ?? ???? ??? ??????? ??????? ?? ??? ???
  • TotalPages: ??? ?? ????????? ??? ??? ??? ?? ?? ???????? ?????? ???? ?? ??? ???? ??? ?????? ????? ??????? ?? ?????? ???
  • InUsePages: ??? ?? ????? ?? ???????????? ?? ??????? ??? ?? ??? ??? ?? ????????? ??? ??? ?????? ??? ?? ??????? ?? ??? ???? ???? ?? ?????

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

???? ?????? ??? ??????? ??????? ?????? ???????? ?? ???? ??? ??????? ??? This section also contains information about how much memory the global memory objects use.
   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)
The elements in this section are the following:
  • ??????: This value shows the memory that the??????object uses. The??????object is used by the storage engine and for various server-wide structures.
  • Locks: This value shows the memory that Lock Manager uses.
  • XDES: This value shows the memory that Transaction Manager uses.
  • SETLS: This value shows the memory that is used to allocate the Storage Engine-specific per-thread structure that uses thread local storage.
  • SE Dataset Allocators: ??? ?? ?????? ?? ?????? ?? ?? ????? ?? ??? ???????? ?? ?????? ???? ?? ??? ????? ???? ???? ?? ?? ?????? ?? ?????? ???????-??????????????
  • SubpDesc Allocators: ??? ?? ???????? ????????, ????? ????????, ???????????? ????????, ??????? ????????, ????? ????????, mirroring ?? ?? ??? ?????????? ????? subprocesses ???????? ???? ?? ??? ????? ???? ???? ?? ?? ?????? ?? ?????? ??? ?? subprocesses ?? ???? ??????????? ?????????.
  • SE SchemaManager: ?? ??? ?? ?????? ??????? ?????-??????? ???? ???? ?????? ???? ?? ??? ?????? ??????? ?? ????? ???? ???? ?????? ???
  • SQLCache: ?? ??? ?? ??? ?? prepared ????? ?? ?? ??? ????? ?? ?????? ???? ?? ??? ????? ???? ???? ?? ?? ?????? ?????? ???
  • ???????????: ??? ?? ?????? ????????? subsystems ?? ??? ????? ?? ????? ???? ???? ?????? ?? ?????? ???
  • ServerGlobal: ?? ??? ????? ????? generically ?? subsystems ??????? ????? ?????? ???????? ?? ?????? ???
  • XP ???????: ?? ??? ?? ???????? ???????????? ????? ????????? ?????? ?????? ???
  • ????? ????????: ?? ??? ?? ?????? ?????? ?? ?? ???????? ?? ????? ????? ?????

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

???? ?????? ?????? ?????? grant ??????? ?? ????? ???? ??? ?? ?????? ??? ?????? ?????? ????? ?? ??? ???????? ????? ??? ?????? ?????? ?? ???? ???????????? ??????.
   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. This behavior prevents smaller queries from being delayed behind larger queries that are already in the queue.

The elements in this section are the following:
  • Grants: This value shows the running queries that have memory grants.
  • ????????? ?? ??? ??: This value shows the queries that are waiting to obtain memory grants.
  • ??????: This value shows the buffers that are available to queries for use as hash workspace and as sort workspace. The??????value is updated periodically.
  • ??????: This value shows the total buffers that can be given to all queries for use as workspace.
  • ????: This value shows the query execution target for the big query queue. This value differs from theMaximum (Buffers)value because theMaximum (Buffers)value is not updated until there is change in the queue.
  • Next Request: This value shows the memory request size, in buffers, for the next waiting query.
  • Waiting For: This value shows the amount of memory that must be available to run the query to which theNext Requestvalue refers. TheWaiting For??? ?????? ????????? ???? headroom ??????? ?????? multiplied ??? ?? ??? ??????? guarantees ?? ?? ???? ??????? ?????? ?? ?????? ?????? ???? ?? ???? ????????? ?????? ??????
  • ????: ?? ??? ?? ???? ????????? ?????? ?? ???? ?????? ???
  • ????????: ??? ?? ????-???, ???? ????????? ?????? ?? ???, ??????? ??? ?????? ???
  • ??? ????????? ????: ??? ?? ???? ??? ??? ?????? ??, ????????? ??? ???? ????????? ?????? ???? ??? ??? ??? ???
  • ????? ??????: ?? ??? ?? ?????? ???????? ?? ??? ????? ?????? ???? ?????? ??? This value is the combined limit for both the big query queue and the small query queue.

Optimization

???? ?????? ??? ??????? ?? ?? ?? ??? ??? ????????? ???? ?? ?????? ?? ??? ??? ?? ?????????? ?? ??? ?????? ???
   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)
???????? compilation ?? ??? ????? ?? ????? ???? ??? ???? ????????, algebraization ?? ???????????? compilation ????????? ????? ???? ???????? compilation ????????? ?? ????? ???????? ?????? ?? ??? ?? ???? ???? ?? ?????? ?? ?????? ?? ?????? ???????? ????

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

??? ?????? ??????? ???? ??, ?? ??? ???? ?? ?? ????? ???????? ?? ?????? ?? ???? ???? ?????? ????? ?????? ?? ?? ?? ????????? ?? ????? ???? ??, ?? ??? ??? ?????? ?? ???? ???? ?? ??? ???? ????? ??? ???? ?????? ???????? ????? ?? ??? ?? ??? ?????? ???????? progressively decreasing ???? ??? The size of each gateway depends on the platform and the load. Gateway sizes are chosen to maximize scalability and throughput.

If the query cannot pass a gateway, the query will wait until memory is available. Or, the query will return a time-out error (Error 8628). Additionally, the query may not acquire a gateway if the user cancels the query or if a deadlock is detected. If a query passes several gateways, the query does not release the smaller gateways until the compilation process has completed.

This behavior lets only a few memory-intensive compilations occur at the same time. Additionally, this behavior maximizes throughput for smaller queries.

?????? brokers

???? ??? ????? ?????? ?????? brokers ?? ???? ??? ??????? ?? ???????? ??? ??????, stolen ??????, ?? ??????? ??????? ?? ????? ?????? ??????? ???? ?????? ????? ?? ??? ????? ???? ?? ???? ??? ?????, ?? ??????? ???? ??????? ???? ???
   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)

???

???? ID: 907877 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • 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
??????: 
kbsql2005engine kbtshoot kbinfo kbmt KB907877 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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