1. Memory Manager KB
  2. ------------------------------ --------------------
  3. VM Reserved 1805144
  4. VM Committed 1737792
  5. AWE Allocated 0
  6. Reserved Memory 1024
  7. Reserved Memory In Use 0
  8.  
  9. (5 row(s) affected)
  10.  
  11. Memory node Id = 0 KB
  12. ------------------------------ --------------------
  13. VM Reserved 1800984
  14. VM Committed 1733784
  15. AWE Allocated 0
  16. MultiPage Allocator 23528
  17. SinglePage Allocator 43624
  18.  
  19. (5 row(s) affected)
  20.  
  21. MEMORYCLERK_SQLGENERAL (Total) KB
  22. ---------------------------------------------------------------- --------------------
  23. VM Reserved 0
  24. VM Committed 0
  25. AWE Allocated 0
  26. SM Reserved 0
  27. SM Commited 0
  28. SinglePage Allocator 3640
  29. MultiPage Allocator 3104
  30.  
  31. (7 row(s) affected)
  32.  
  33. MEMORYCLERK_SQLBUFFERPOOL (Total) KB
  34. ---------------------------------------------------------------- --------------------
  35. VM Reserved 1654624
  36. VM Committed 1654624
  37. AWE Allocated 0
  38. SM Reserved 0
  39. SM Commited 0
  40. SinglePage Allocator 0
  41. MultiPage Allocator 400
  42.  
  43. (7 row(s) affected)
  44.  
  45. MEMORYCLERK_SQLQUERYEXEC (Total) KB
  46. ---------------------------------------------------------------- --------------------
  47. VM Reserved 0
  48. VM Committed 0
  49. AWE Allocated 0
  50. SM Reserved 0
  51. SM Commited 0
  52. SinglePage Allocator 8
  53. MultiPage Allocator 0
  54.  
  55. (7 row(s) affected)
  56.  
  57. MEMORYCLERK_SQLOPTIMIZER (Total) KB
  58. ---------------------------------------------------------------- --------------------
  59. VM Reserved 0
  60. VM Committed 0
  61. AWE Allocated 0
  62. SM Reserved 0
  63. SM Commited 0
  64. SinglePage Allocator 2464
  65. MultiPage Allocator 72
  66.  
  67. (7 row(s) affected)
  68.  
  69. MEMORYCLERK_SQLUTILITIES (Total) KB
  70. ---------------------------------------------------------------- --------------------
  71. VM Reserved 120
  72. VM Committed 120
  73. AWE Allocated 0
  74. SM Reserved 0
  75. SM Commited 0
  76. SinglePage Allocator 592
  77. MultiPage Allocator 0
  78.  
  79. (7 row(s) affected)
  80.  
  81. MEMORYCLERK_SQLSTORENG (Total) KB
  82. ---------------------------------------------------------------- --------------------
  83. VM Reserved 8064
  84. VM Committed 8064
  85. AWE Allocated 0
  86. SM Reserved 0
  87. SM Commited 0
  88. SinglePage Allocator 4928
  89. MultiPage Allocator 512
  90.  
  91. (7 row(s) affected)
  92.  
  93. MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
  94. ---------------------------------------------------------------- --------------------
  95. VM Reserved 0
  96. VM Committed 0
  97. AWE Allocated 0
  98. SM Reserved 0
  99. SM Commited 0
  100. SinglePage Allocator 616
  101. MultiPage Allocator 0
  102.  
  103. (7 row(s) affected)
  104.  
  105. MEMORYCLERK_SQLCLR (Total) KB
  106. ---------------------------------------------------------------- --------------------
  107. VM Reserved 102464
  108. VM Committed 36208
  109. AWE Allocated 0
  110. SM Reserved 0
  111. SM Commited 0
  112. SinglePage Allocator 1024
  113. MultiPage Allocator 5232
  114.  
  115. (7 row(s) affected)
  116.  
  117. MEMORYCLERK_SQLSERVICEBROKER (Total) KB
  118. ---------------------------------------------------------------- --------------------
  119. VM Reserved 0
  120. VM Committed 0
  121. AWE Allocated 0
  122. SM Reserved 0
  123. SM Commited 0
  124. SinglePage Allocator 216
  125. MultiPage Allocator 192
  126.  
  127. (7 row(s) affected)
  128.  
  129. MEMORYCLERK_SQLHTTP (Total) KB
  130. ---------------------------------------------------------------- --------------------
  131. VM Reserved 0
  132. VM Committed 0
  133. AWE Allocated 0
  134. SM Reserved 0
  135. SM Commited 0
  136. SinglePage Allocator 8
  137. MultiPage Allocator 0
  138.  
  139. (7 row(s) affected)
  140.  
  141. MEMORYCLERK_SNI (Total) KB
  142. ---------------------------------------------------------------- --------------------
  143. VM Reserved 0
  144. VM Committed 0
  145. AWE Allocated 0
  146. SM Reserved 0
  147. SM Commited 0
  148. SinglePage Allocator 96
  149. MultiPage Allocator 16
  150.  
  151. (7 row(s) affected)
  152.  
  153. MEMORYCLERK_FULLTEXT (Total) KB
  154. ---------------------------------------------------------------- --------------------
  155. VM Reserved 0
  156. VM Committed 0
  157. AWE Allocated 0
  158. SM Reserved 0
  159. SM Commited 0
  160. SinglePage Allocator 72
  161. MultiPage Allocator 0
  162.  
  163. (7 row(s) affected)
  164.  
  165. MEMORYCLERK_SQLXP (Total) KB
  166. ---------------------------------------------------------------- --------------------
  167. VM Reserved 0
  168. VM Committed 0
  169. AWE Allocated 0
  170. SM Reserved 0
  171. SM Commited 0
  172. SinglePage Allocator 16
  173. MultiPage Allocator 0
  174.  
  175. (7 row(s) affected)
  176.  
  177. MEMORYCLERK_BHF (Total) KB
  178. ---------------------------------------------------------------- --------------------
  179. VM Reserved 0
  180. VM Committed 0
  181. AWE Allocated 0
  182. SM Reserved 0
  183. SM Commited 0
  184. SinglePage Allocator 96
  185. MultiPage Allocator 0
  186.  
  187. (7 row(s) affected)
  188.  
  189. MEMORYCLERK_HOST (Total) KB
  190. ---------------------------------------------------------------- --------------------
  191. VM Reserved 0
  192. VM Committed 0
  193. AWE Allocated 0
  194. SM Reserved 0
  195. SM Commited 0
  196. SinglePage Allocator 24
  197. MultiPage Allocator 0
  198.  
  199. (7 row(s) affected)
  200.  
  201. MEMORYCLERK_SOSNODE (Total) KB
  202. ---------------------------------------------------------------- --------------------
  203. VM Reserved 0
  204. VM Committed 0
  205. AWE Allocated 0
  206. SM Reserved 0
  207. SM Commited 0
  208. SinglePage Allocator 14200
  209. MultiPage Allocator 13760
  210.  
  211. (7 row(s) affected)
  212.  
  213. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) KB
  214. ---------------------------------------------------------------- --------------------
  215. VM Reserved 0
  216. VM Committed 0
  217. AWE Allocated 0
  218. SM Reserved 0
  219. SM Commited 0
  220. SinglePage Allocator 24
  221. MultiPage Allocator 0
  222.  
  223. (7 row(s) affected)
  224.  
  225. CACHESTORE_OBJCP (Total) KB
  226. ---------------------------------------------------------------- --------------------
  227. VM Reserved 0
  228. VM Committed 0
  229. AWE Allocated 0
  230. SM Reserved 0
  231. SM Commited 0
  232. SinglePage Allocator 8
  233. MultiPage Allocator 0
  234.  
  235. (7 row(s) affected)
  236.  
  237. CACHESTORE_SQLCP (Total) KB
  238. ---------------------------------------------------------------- --------------------
  239. VM Reserved 0
  240. VM Committed 0
  241. AWE Allocated 0
  242. SM Reserved 0
  243. SM Commited 0
  244. SinglePage Allocator 56
  245. MultiPage Allocator 0
  246.  
  247. (7 row(s) affected)
  248.  
  249. CACHESTORE_PHDR (Total) KB
  250. ---------------------------------------------------------------- --------------------
  251. VM Reserved 0
  252. VM Committed 0
  253. AWE Allocated 0
  254. SM Reserved 0
  255. SM Commited 0
  256. SinglePage Allocator 8
  257. MultiPage Allocator 0
  258.  
  259. (7 row(s) affected)
  260.  
  261. CACHESTORE_XPROC (Total) KB
  262. ---------------------------------------------------------------- --------------------
  263. VM Reserved 0
  264. VM Committed 0
  265. AWE Allocated 0
  266. SM Reserved 0
  267. SM Commited 0
  268. SinglePage Allocator 16
  269. MultiPage Allocator 0
  270.  
  271. (7 row(s) affected)
  272.  
  273. CACHESTORE_TEMPTABLES (Total) KB
  274. ---------------------------------------------------------------- --------------------
  275. VM Reserved 0
  276. VM Committed 0
  277. AWE Allocated 0
  278. SM Reserved 0
  279. SM Commited 0
  280. SinglePage Allocator 16
  281. MultiPage Allocator 0
  282.  
  283. (7 row(s) affected)
  284.  
  285. CACHESTORE_NOTIF (Total) KB
  286. ---------------------------------------------------------------- --------------------
  287. VM Reserved 0
  288. VM Committed 0
  289. AWE Allocated 0
  290. SM Reserved 0
  291. SM Commited 0
  292. SinglePage Allocator 16
  293. MultiPage Allocator 0
  294.  
  295. (7 row(s) affected)
  296.  
  297. CACHESTORE_VIEWDEFINITIONS (Total) KB
  298. ---------------------------------------------------------------- --------------------
  299. VM Reserved 0
  300. VM Committed 0
  301. AWE Allocated 0
  302. SM Reserved 0
  303. SM Commited 0
  304. SinglePage Allocator 16
  305. MultiPage Allocator 0
  306.  
  307. (7 row(s) affected)
  308.  
  309. CACHESTORE_XMLDBTYPE (Total) KB
  310. ---------------------------------------------------------------- --------------------
  311. VM Reserved 0
  312. VM Committed 0
  313. AWE Allocated 0
  314. SM Reserved 0
  315. SM Commited 0
  316. SinglePage Allocator 8
  317. MultiPage Allocator 0
  318.  
  319. (7 row(s) affected)
  320.  
  321. CACHESTORE_XMLDBELEMENT (Total) KB
  322. ---------------------------------------------------------------- --------------------
  323. VM Reserved 0
  324. VM Committed 0
  325. AWE Allocated 0
  326. SM Reserved 0
  327. SM Commited 0
  328. SinglePage Allocator 8
  329. MultiPage Allocator 0
  330.  
  331. (7 row(s) affected)
  332.  
  333. CACHESTORE_XMLDBATTRIBUTE (Total) KB
  334. ---------------------------------------------------------------- --------------------
  335. VM Reserved 0
  336. VM Committed 0
  337. AWE Allocated 0
  338. SM Reserved 0
  339. SM Commited 0
  340. SinglePage Allocator 8
  341. MultiPage Allocator 0
  342.  
  343. (7 row(s) affected)
  344.  
  345. CACHESTORE_STACKFRAMES (Total) KB
  346. ---------------------------------------------------------------- --------------------
  347. VM Reserved 0
  348. VM Committed 0
  349. AWE Allocated 0
  350. SM Reserved 0
  351. SM Commited 0
  352. SinglePage Allocator 0
  353. MultiPage Allocator 8
  354.  
  355. (7 row(s) affected)
  356.  
  357. CACHESTORE_BROKERTBLACS (Total) KB
  358. ---------------------------------------------------------------- --------------------
  359. VM Reserved 0
  360. VM Committed 0
  361. AWE Allocated 0
  362. SM Reserved 0
  363. SM Commited 0
  364. SinglePage Allocator 408
  365. MultiPage Allocator 0
  366.  
  367. (7 row(s) affected)
  368.  
  369. CACHESTORE_BROKERKEK (Total) KB
  370. ---------------------------------------------------------------- --------------------
  371. VM Reserved 0
  372. VM Committed 0
  373. AWE Allocated 0
  374. SM Reserved 0
  375. SM Commited 0
  376. SinglePage Allocator 8
  377. MultiPage Allocator 0
  378.  
  379. (7 row(s) affected)
  380.  
  381. CACHESTORE_BROKERDSH (Total) KB
  382. ---------------------------------------------------------------- --------------------
  383. VM Reserved 0
  384. VM Committed 0
  385. AWE Allocated 0
  386. SM Reserved 0
  387. SM Commited 0
  388. SinglePage Allocator 8
  389. MultiPage Allocator 0
  390.  
  391. (7 row(s) affected)
  392.  
  393. CACHESTORE_BROKERUSERCERTLOOKUP (Total) KB
  394. ---------------------------------------------------------------- --------------------
  395. VM Reserved 0
  396. VM Committed 0
  397. AWE Allocated 0
  398. SM Reserved 0
  399. SM Commited 0
  400. SinglePage Allocator 8
  401. MultiPage Allocator 0
  402.  
  403. (7 row(s) affected)
  404.  
  405. CACHESTORE_BROKERRSB (Total) KB
  406. ---------------------------------------------------------------- --------------------
  407. VM Reserved 0
  408. VM Committed 0
  409. AWE Allocated 0
  410. SM Reserved 0
  411. SM Commited 0
  412. SinglePage Allocator 8
  413. MultiPage Allocator 0
  414.  
  415. (7 row(s) affected)
  416.  
  417. CACHESTORE_BROKERREADONLY (Total) KB
  418. ---------------------------------------------------------------- --------------------
  419. VM Reserved 0
  420. VM Committed 0
  421. AWE Allocated 0
  422. SM Reserved 0
  423. SM Commited 0
  424. SinglePage Allocator 32
  425. MultiPage Allocator 0
  426.  
  427. (7 row(s) affected)
  428.  
  429. CACHESTORE_BROKERTO (Total) KB
  430. ---------------------------------------------------------------- --------------------
  431. VM Reserved 0
  432. VM Committed 0
  433. AWE Allocated 0
  434. SM Reserved 0
  435. SM Commited 0
  436. SinglePage Allocator 8
  437. MultiPage Allocator 0
  438.  
  439. (7 row(s) affected)
  440.  
  441. CACHESTORE_EVENTS (Total) KB
  442. ---------------------------------------------------------------- --------------------
  443. VM Reserved 0
  444. VM Committed 0
  445. AWE Allocated 0
  446. SM Reserved 0
  447. SM Commited 0
  448. SinglePage Allocator 16
  449. MultiPage Allocator 0
  450.  
  451. (7 row(s) affected)
  452.  
  453. CACHESTORE_SYSTEMROWSET (Total) KB
  454. ---------------------------------------------------------------- --------------------
  455. VM Reserved 0
  456. VM Committed 0
  457. AWE Allocated 0
  458. SM Reserved 0
  459. SM Commited 0
  460. SinglePage Allocator 592
  461. MultiPage Allocator 0
  462.  
  463. (7 row(s) affected)
  464.  
  465. USERSTORE_SCHEMAMGR (Total) KB
  466. ---------------------------------------------------------------- --------------------
  467. VM Reserved 0
  468. VM Committed 0
  469. AWE Allocated 0
  470. SM Reserved 0
  471. SM Commited 0
  472. SinglePage Allocator 6928
  473. MultiPage Allocator 48
  474.  
  475. (7 row(s) affected)
  476.  
  477. USERSTORE_DBMETADATA (Total) KB
  478. ---------------------------------------------------------------- --------------------
  479. VM Reserved 0
  480. VM Committed 0
  481. AWE Allocated 0
  482. SM Reserved 0
  483. SM Commited 0
  484. SinglePage Allocator 1392
  485. MultiPage Allocator 0
  486.  
  487. (7 row(s) affected)
  488.  
  489. USERSTORE_TOKENPERM (Total) KB
  490. ---------------------------------------------------------------- --------------------
  491. VM Reserved 0
  492. VM Committed 0
  493. AWE Allocated 0
  494. SM Reserved 0
  495. SM Commited 0
  496. SinglePage Allocator 304
  497. MultiPage Allocator 0
  498.  
  499. (7 row(s) affected)
  500.  
  501. USERSTORE_OBJPERM (Total) KB
  502. ---------------------------------------------------------------- --------------------
  503. VM Reserved 0
  504. VM Committed 0
  505. AWE Allocated 0
  506. SM Reserved 0
  507. SM Commited 0
  508. SinglePage Allocator 3072
  509. MultiPage Allocator 0
  510.  
  511. (7 row(s) affected)
  512.  
  513. USERSTORE_SXC (Total) KB
  514. ---------------------------------------------------------------- --------------------
  515. VM Reserved 0
  516. VM Committed 0
  517. AWE Allocated 0
  518. SM Reserved 0
  519. SM Commited 0
  520. SinglePage Allocator 8
  521. MultiPage Allocator 0
  522.  
  523. (7 row(s) affected)
  524.  
  525. OBJECTSTORE_LBSS (Total) KB
  526. ---------------------------------------------------------------- --------------------
  527. VM Reserved 0
  528. VM Committed 0
  529. AWE Allocated 0
  530. SM Reserved 0
  531. SM Commited 0
  532. SinglePage Allocator 64
  533. MultiPage Allocator 0
  534.  
  535. (7 row(s) affected)
  536.  
  537. OBJECTSTORE_SNI_PACKET (Total) KB
  538. ---------------------------------------------------------------- --------------------
  539. VM Reserved 0
  540. VM Committed 0
  541. AWE Allocated 0
  542. SM Reserved 0
  543. SM Commited 0
  544. SinglePage Allocator 1128
  545. MultiPage Allocator 48
  546.  
  547. (7 row(s) affected)
  548.  
  549. OBJECTSTORE_SERVICE_BROKER (Total) KB
  550. ---------------------------------------------------------------- --------------------
  551. VM Reserved 0
  552. VM Committed 0
  553. AWE Allocated 0
  554. SM Reserved 0
  555. SM Commited 0
  556. SinglePage Allocator 256
  557. MultiPage Allocator 0
  558.  
  559. (7 row(s) affected)
  560.  
  561. OBJECTSTORE_LOCK_MANAGER (Total) KB
  562. ---------------------------------------------------------------- --------------------
  563. VM Reserved 8192
  564. VM Committed 8192
  565. AWE Allocated 0
  566. SM Reserved 0
  567. SM Commited 0
  568. SinglePage Allocator 1160
  569. MultiPage Allocator 0
  570.  
  571. (7 row(s) affected)
  572.  
  573. Buffer Distribution Buffers
  574. ------------------------------ -----------
  575. Stolen 3509
  576. Free 5971
  577. Cached 1944
  578. Database (clean) 191509
  579. Database (dirty) 1867
  580. I/O 0
  581. Latched 0
  582.  
  583. (7 row(s) affected)
  584.  
  585. Buffer Counts Buffers
  586. ------------------------------ --------------------
  587. Committed 204800
  588. Target 204800
  589. Hashed 193376
  590. Stolen Potential 189107
  591. External Reservation 0
  592. Min Free 128
  593. Visible 204800
  594. Available Paging File 271475
  595.  
  596. (8 row(s) affected)
  597.  
  598. Procedure Cache Value
  599. ------------------------------ -----------
  600. TotalProcs 0
  601. TotalPages 11
  602. InUsePages 0
  603.  
  604. (3 row(s) affected)
  605.  
  606.  
  607. Global Memory Objects Buffers
  608. ------------------------------ --------------------
  609. Resource 472
  610. Locks 148
  611. XDES 39
  612. SETLS 4
  613. SE Dataset Allocators 8
  614. SubpDesc Allocators 4
  615. SE SchemaManager 871
  616. SQLCache 50
  617. Replication 2
  618. ServerGlobal 26
  619. XP Global 2
  620. SortTables 2
  621.  
  622. (12 row(s) affected)
  623.  
  624.  
  625. Query Memory Objects Value
  626. ------------------------------ -----------
  627. Grants 0
  628. Waiting 0
  629. Available (Buffers) 146205
  630. Maximum (Buffers) 146205
  631. Limit 146205
  632. Next Request 0
  633. Waiting For 0
  634. Cost 0
  635. Timeout 0
  636. Wait Time 0
  637. Last Target 153900
  638.  
  639. (11 row(s) affected)
  640.  
  641. Small Query Memory Objects Value
  642. ------------------------------ -----------
  643. Grants 0
  644. Waiting 0
  645. Available (Buffers) 7695
  646. Maximum (Buffers) 7695
  647. Limit 7695
  648.  
  649. (5 row(s) affected)
  650.  
  651. Optimization Queue Value
  652. ------------------------------ --------------------
  653. Overall Memory 1344798720
  654. Target Memory 1289166848
  655. Last Notification 1
  656. Timeout 6
  657. Early Termination Factor 5
  658.  
  659. (5 row(s) affected)
  660.  
  661. Small Gateway Value
  662. ------------------------------ --------------------
  663. Configured Units 16
  664. Available Units 16
  665. Acquires 0
  666. Waiters 0
  667. Threshold Factor 250000
  668. Threshold 250000
  669.  
  670. (6 row(s) affected)
  671.  
  672. Medium Gateway Value
  673. ------------------------------ --------------------
  674. Configured Units 4
  675. Available Units 4
  676. Acquires 0
  677. Waiters 0
  678. Threshold Factor 12
  679.  
  680. (5 row(s) affected)
  681.  
  682. Big Gateway Value
  683. ------------------------------ --------------------
  684. Configured Units 1
  685. Available Units 1
  686. Acquires 0
  687. Waiters 0
  688. Threshold Factor 8
  689.  
  690. (5 row(s) affected)
  691.  
  692. MEMORYBROKER_FOR_CACHE Value
  693. -------------------------------- --------------------
  694. Allocations 1945
  695. Rate -1305
  696. Target Allocations 154528
  697. Future Allocations 0
  698. Last Notification 1
  699.  
  700. (5 row(s) affected)
  701.  
  702. MEMORYBROKER_FOR_STEAL Value
  703. -------------------------------- --------------------
  704. Allocations 3502
  705. Rate -21
  706. Target Allocations 157369
  707. Future Allocations 0
  708. Last Notification 1
  709.  
  710. (5 row(s) affected)
  711.  
  712. MEMORYBROKER_FOR_RESERVE Value
  713. -------------------------------- --------------------
  714. Allocations 0
  715. Rate -354
  716. Target Allocations 164160
  717. Future Allocations 36551
  718. Last Notification 1
  719.  
  720. (5 row(s) affected)
  721.  
  722. DBCC execution completed. If DBCC printed error messages, contact your system administrator.