API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 21st, 2015
1,002
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 60.42 KB | None | 0 0
raw download clone embed print report
  1. Process/System Counts Value
  2. ---------------------------------------- --------------------
  3. Available Physical Memory 16383119360
  4. Available Virtual Memory 140435947802624
  5. Available Paging File 29349691392
  6. Working Set 93258907648
  7. Percent of Committed Memory in WS 100
  8. Page Faults 240837877
  9. System physical memory high 1
  10. System physical memory low 0
  11. Process physical memory low 0
  12. Process virtual memory low 0
  13.  
  14. (10 row(s) affected)
  15.  
  16. Memory Manager KB
  17. ---------------------------------------- -----------
  18. VM Reserved 260726964
  19. VM Committed 67108820
  20. Locked Pages Allocated 0
  21. Large Pages Allocated 0
  22. Emergency Memory 1024
  23. Emergency Memory In Use 16
  24. Target Committed 67108872
  25. Current Committed 67108824
  26. Pages Allocated 58505000
  27. Pages Reserved 0
  28. Pages Free 5208520
  29. Pages In Use 5886440
  30. Page Alloc Potential 57866984
  31. NUMA Growth Phase 2
  32. Last OOM Factor 0
  33. Last OS Error 0
  34.  
  35. (16 row(s) affected)
  36.  
  37. Memory node Id = 0 KB
  38. ---------------------------------------- -----------
  39. VM Reserved 260721844
  40. VM Committed 33554420
  41. Locked Pages Allocated 0
  42. Pages Allocated 27617544
  43. Pages Free 3999176
  44. Target Committed 33554424
  45. Current Committed 33554424
  46. Foreign Committed 309348
  47. Away Committed 0
  48. Taken Away Committed 0
  49.  
  50. (10 row(s) affected)
  51.  
  52. Memory node Id = 1 KB
  53. ---------------------------------------- -----------
  54. VM Reserved 5056
  55. VM Committed 33554380
  56. Locked Pages Allocated 0
  57. Pages Allocated 30887456
  58. Pages Free 1209344
  59. Target Committed 33554424
  60. Current Committed 33554384
  61. Foreign Committed 96
  62. Away Committed 0
  63. Taken Away Committed 0
  64.  
  65. (10 row(s) affected)
  66.  
  67. Memory node Id = 64 KB
  68. ---------------------------------------- -----------
  69. VM Reserved 0
  70. VM Committed 20
  71. Locked Pages Allocated 0
  72.  
  73. (3 row(s) affected)
  74.  
  75. MEMORYCLERK_SQLGENERAL (node 0) KB
  76. ---------------------------------------- -----------
  77. VM Reserved 0
  78. VM Committed 0
  79. Locked Pages Allocated 0
  80. SM Reserved 0
  81. SM Committed 0
  82. Pages Allocated 36152
  83.  
  84. (6 row(s) affected)
  85.  
  86. MEMORYCLERK_SQLGENERAL (node 1) KB
  87. ---------------------------------------- -----------
  88. VM Reserved 0
  89. VM Committed 0
  90. Locked Pages Allocated 0
  91. SM Reserved 0
  92. SM Committed 0
  93. Pages Allocated 288
  94.  
  95. (6 row(s) affected)
  96.  
  97. MEMORYCLERK_SQLGENERAL (Total) KB
  98. ---------------------------------------- -----------
  99. VM Reserved 0
  100. VM Committed 0
  101. Locked Pages Allocated 0
  102. SM Reserved 0
  103. SM Committed 0
  104. Pages Allocated 36440
  105.  
  106. (6 row(s) affected)
  107.  
  108. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  109. ---------------------------------------- -----------
  110. VM Reserved 51976280
  111. VM Committed 2328456
  112. Locked Pages Allocated 0
  113. SM Reserved 0
  114. SM Committed 0
  115. Pages Allocated 26439360
  116.  
  117. (6 row(s) affected)
  118.  
  119. MEMORYCLERK_SQLBUFFERPOOL (node 1) KB
  120. ---------------------------------------- -----------
  121. VM Reserved 0
  122. VM Committed 0
  123. Locked Pages Allocated 0
  124. SM Reserved 0
  125. SM Committed 0
  126. Pages Allocated 29574464
  127.  
  128. (6 row(s) affected)
  129.  
  130. MEMORYCLERK_SQLBUFFERPOOL (Total) KB
  131. ---------------------------------------- -----------
  132. VM Reserved 51976280
  133. VM Committed 2328456
  134. Locked Pages Allocated 0
  135. SM Reserved 0
  136. SM Committed 0
  137. Pages Allocated 56013824
  138.  
  139. (6 row(s) affected)
  140.  
  141. MEMORYCLERK_SQLQUERYEXEC (node 0) KB
  142. ---------------------------------------- -----------
  143. VM Reserved 0
  144. VM Committed 0
  145. Locked Pages Allocated 0
  146. SM Reserved 0
  147. SM Committed 0
  148. Pages Allocated 824
  149.  
  150. (6 row(s) affected)
  151.  
  152. MEMORYCLERK_SQLQUERYEXEC (node 1) KB
  153. ---------------------------------------- -----------
  154. VM Reserved 0
  155. VM Committed 0
  156. Locked Pages Allocated 0
  157. SM Reserved 0
  158. SM Committed 0
  159. Pages Allocated 16
  160.  
  161. (6 row(s) affected)
  162.  
  163. MEMORYCLERK_SQLQUERYEXEC (Total) KB
  164. ---------------------------------------- -----------
  165. VM Reserved 0
  166. VM Committed 0
  167. Locked Pages Allocated 0
  168. SM Reserved 0
  169. SM Committed 0
  170. Pages Allocated 840
  171.  
  172. (6 row(s) affected)
  173.  
  174. MEMORYCLERK_SQLOPTIMIZER (node 0) KB
  175. ---------------------------------------- -----------
  176. VM Reserved 0
  177. VM Committed 0
  178. Locked Pages Allocated 0
  179. SM Reserved 0
  180. SM Committed 0
  181. Pages Allocated 1736
  182.  
  183. (6 row(s) affected)
  184.  
  185. MEMORYCLERK_SQLUTILITIES (node 0) KB
  186. ---------------------------------------- -----------
  187. VM Reserved 0
  188. VM Committed 0
  189. Locked Pages Allocated 0
  190. SM Reserved 0
  191. SM Committed 0
  192. Pages Allocated 192
  193.  
  194. (6 row(s) affected)
  195.  
  196. MEMORYCLERK_SQLSTORENG (node 0) KB
  197. ---------------------------------------- -----------
  198. VM Reserved 31104
  199. VM Committed 31104
  200. Locked Pages Allocated 0
  201. SM Reserved 0
  202. SM Committed 0
  203. Pages Allocated 11536
  204.  
  205. (6 row(s) affected)
  206.  
  207. MEMORYCLERK_SQLSTORENG (node 1) KB
  208. ---------------------------------------- -----------
  209. VM Reserved 0
  210. VM Committed 0
  211. Locked Pages Allocated 0
  212. SM Reserved 0
  213. SM Committed 0
  214. Pages Allocated 7792
  215.  
  216. (6 row(s) affected)
  217.  
  218. MEMORYCLERK_SQLSTORENG (Total) KB
  219. ---------------------------------------- -----------
  220. VM Reserved 31104
  221. VM Committed 31104
  222. Locked Pages Allocated 0
  223. SM Reserved 0
  224. SM Committed 0
  225. Pages Allocated 19328
  226.  
  227. (6 row(s) affected)
  228.  
  229. MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
  230. ---------------------------------------- -----------
  231. VM Reserved 0
  232. VM Committed 0
  233. Locked Pages Allocated 0
  234. SM Reserved 0
  235. SM Committed 0
  236. Pages Allocated 1224
  237.  
  238. (6 row(s) affected)
  239.  
  240. MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
  241. ---------------------------------------- -----------
  242. VM Reserved 0
  243. VM Committed 0
  244. Locked Pages Allocated 0
  245. SM Reserved 0
  246. SM Committed 0
  247. Pages Allocated 1104
  248.  
  249. (6 row(s) affected)
  250.  
  251. MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
  252. ---------------------------------------- -----------
  253. VM Reserved 0
  254. VM Committed 0
  255. Locked Pages Allocated 0
  256. SM Reserved 0
  257. SM Committed 0
  258. Pages Allocated 2328
  259.  
  260. (6 row(s) affected)
  261.  
  262. MEMORYCLERK_SQLCLR (node 0) KB
  263. ---------------------------------------- -----------
  264. VM Reserved 6306624
  265. VM Committed 38796
  266. Locked Pages Allocated 0
  267. SM Reserved 0
  268. SM Committed 0
  269. Pages Allocated 52104
  270.  
  271. (6 row(s) affected)
  272.  
  273. MEMORYCLERK_SQLCLRASSEMBLY (node 0) KB
  274. ---------------------------------------- -----------
  275. VM Reserved 5092
  276. VM Committed 5092
  277. Locked Pages Allocated 0
  278. SM Reserved 0
  279. SM Committed 0
  280. Pages Allocated 0
  281.  
  282. (6 row(s) affected)
  283.  
  284. MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
  285. ---------------------------------------- -----------
  286. VM Reserved 0
  287. VM Committed 0
  288. Locked Pages Allocated 0
  289. SM Reserved 0
  290. SM Committed 0
  291. Pages Allocated 704
  292.  
  293. (6 row(s) affected)
  294.  
  295. MEMORYCLERK_SQLHTTP (node 1) KB
  296. ---------------------------------------- -----------
  297. VM Reserved 0
  298. VM Committed 0
  299. Locked Pages Allocated 0
  300. SM Reserved 0
  301. SM Committed 0
  302. Pages Allocated 8
  303.  
  304. (6 row(s) affected)
  305.  
  306. MEMORYCLERK_SNI (node 0) KB
  307. ---------------------------------------- -----------
  308. VM Reserved 0
  309. VM Committed 0
  310. Locked Pages Allocated 0
  311. SM Reserved 0
  312. SM Committed 0
  313. Pages Allocated 128
  314.  
  315. (6 row(s) affected)
  316.  
  317. MEMORYCLERK_SNI (node 1) KB
  318. ---------------------------------------- -----------
  319. VM Reserved 0
  320. VM Committed 0
  321. Locked Pages Allocated 0
  322. SM Reserved 0
  323. SM Committed 0
  324. Pages Allocated 120
  325.  
  326. (6 row(s) affected)
  327.  
  328. MEMORYCLERK_SNI (node 64) KB
  329. ---------------------------------------- -----------
  330. VM Reserved 0
  331. VM Committed 0
  332. Locked Pages Allocated 0
  333. SM Reserved 0
  334. SM Committed 0
  335. Pages Allocated 16
  336.  
  337. (6 row(s) affected)
  338.  
  339. MEMORYCLERK_SNI (Total) KB
  340. ---------------------------------------- -----------
  341. VM Reserved 0
  342. VM Committed 0
  343. Locked Pages Allocated 0
  344. SM Reserved 0
  345. SM Committed 0
  346. Pages Allocated 264
  347.  
  348. (6 row(s) affected)
  349.  
  350. MEMORYCLERK_FULLTEXT (node 0) KB
  351. ---------------------------------------- -----------
  352. VM Reserved 0
  353. VM Committed 0
  354. Locked Pages Allocated 0
  355. SM Reserved 0
  356. SM Committed 0
  357. Pages Allocated 296
  358.  
  359. (6 row(s) affected)
  360.  
  361. MEMORYCLERK_SQLXP (node 0) KB
  362. ---------------------------------------- -----------
  363. VM Reserved 0
  364. VM Committed 0
  365. Locked Pages Allocated 0
  366. SM Reserved 0
  367. SM Committed 0
  368. Pages Allocated 16
  369.  
  370. (6 row(s) affected)
  371.  
  372. MEMORYCLERK_BHF (node 0) KB
  373. ---------------------------------------- -----------
  374. VM Reserved 0
  375. VM Committed 0
  376. Locked Pages Allocated 0
  377. SM Reserved 0
  378. SM Committed 0
  379. Pages Allocated 192
  380.  
  381. (6 row(s) affected)
  382.  
  383. MEMORYCLERK_BHF (node 1) KB
  384. ---------------------------------------- -----------
  385. VM Reserved 0
  386. VM Committed 0
  387. Locked Pages Allocated 0
  388. SM Reserved 0
  389. SM Committed 0
  390. Pages Allocated 160
  391.  
  392. (6 row(s) affected)
  393.  
  394. MEMORYCLERK_BHF (Total) KB
  395. ---------------------------------------- -----------
  396. VM Reserved 0
  397. VM Committed 0
  398. Locked Pages Allocated 0
  399. SM Reserved 0
  400. SM Committed 0
  401. Pages Allocated 352
  402.  
  403. (6 row(s) affected)
  404.  
  405. MEMORYCLERK_XE_BUFFER (node 0) KB
  406. ---------------------------------------- -----------
  407. VM Reserved 8000
  408. VM Committed 8000
  409. Locked Pages Allocated 0
  410. SM Reserved 0
  411. SM Committed 0
  412. Pages Allocated 0
  413.  
  414. (6 row(s) affected)
  415.  
  416. MEMORYCLERK_XE_BUFFER (node 1) KB
  417. ---------------------------------------- -----------
  418. VM Reserved 5056
  419. VM Committed 5056
  420. Locked Pages Allocated 0
  421. SM Reserved 0
  422. SM Committed 0
  423. Pages Allocated 0
  424.  
  425. (6 row(s) affected)
  426.  
  427. MEMORYCLERK_XE_BUFFER (Total) KB
  428. ---------------------------------------- -----------
  429. VM Reserved 13056
  430. VM Committed 13056
  431. Locked Pages Allocated 0
  432. SM Reserved 0
  433. SM Committed 0
  434. Pages Allocated 0
  435.  
  436. (6 row(s) affected)
  437.  
  438. MEMORYCLERK_TRACE_EVTNOTIF (node 0) KB
  439. ---------------------------------------- -----------
  440. VM Reserved 0
  441. VM Committed 0
  442. Locked Pages Allocated 0
  443. SM Reserved 0
  444. SM Committed 0
  445. Pages Allocated 144
  446.  
  447. (6 row(s) affected)
  448.  
  449. MEMORYCLERK_TRACE_EVTNOTIF (node 1) KB
  450. ---------------------------------------- -----------
  451. VM Reserved 0
  452. VM Committed 0
  453. Locked Pages Allocated 0
  454. SM Reserved 0
  455. SM Committed 0
  456. Pages Allocated 168
  457.  
  458. (6 row(s) affected)
  459.  
  460. MEMORYCLERK_TRACE_EVTNOTIF (Total) KB
  461. ---------------------------------------- -----------
  462. VM Reserved 0
  463. VM Committed 0
  464. Locked Pages Allocated 0
  465. SM Reserved 0
  466. SM Committed 0
  467. Pages Allocated 312
  468.  
  469. (6 row(s) affected)
  470.  
  471. MEMORYCLERK_XTP (node 0) KB
  472. ---------------------------------------- -----------
  473. VM Reserved 0
  474. VM Committed 0
  475. Locked Pages Allocated 0
  476. SM Reserved 0
  477. SM Committed 0
  478. Pages Allocated 16
  479.  
  480. (6 row(s) affected)
  481.  
  482. MEMORYCLERK_HOST (node 1) KB
  483. ---------------------------------------- -----------
  484. VM Reserved 0
  485. VM Committed 0
  486. Locked Pages Allocated 0
  487. SM Reserved 0
  488. SM Committed 0
  489. Pages Allocated 368
  490.  
  491. (6 row(s) affected)
  492.  
  493. MEMORYCLERK_SOSNODE (node 0) KB
  494. ---------------------------------------- -----------
  495. VM Reserved 0
  496. VM Committed 0
  497. Locked Pages Allocated 0
  498. SM Reserved 0
  499. SM Committed 0
  500. Pages Allocated 239832
  501.  
  502. (6 row(s) affected)
  503.  
  504. MEMORYCLERK_SOSNODE (node 1) KB
  505. ---------------------------------------- -----------
  506. VM Reserved 0
  507. VM Committed 0
  508. Locked Pages Allocated 0
  509. SM Reserved 0
  510. SM Committed 0
  511. Pages Allocated 234552
  512.  
  513. (6 row(s) affected)
  514.  
  515. MEMORYCLERK_SOSNODE (node 64) KB
  516. ---------------------------------------- -----------
  517. VM Reserved 0
  518. VM Committed 0
  519. Locked Pages Allocated 0
  520. SM Reserved 0
  521. SM Committed 0
  522. Pages Allocated 2488
  523.  
  524. (6 row(s) affected)
  525.  
  526. MEMORYCLERK_SOSNODE (Total) KB
  527. ---------------------------------------- -----------
  528. VM Reserved 0
  529. VM Committed 0
  530. Locked Pages Allocated 0
  531. SM Reserved 0
  532. SM Committed 0
  533. Pages Allocated 476872
  534.  
  535. (6 row(s) affected)
  536.  
  537. MEMORYCLERK_SOSOS (node 0) KB
  538. ---------------------------------------- -----------
  539. VM Reserved 0
  540. VM Committed 0
  541. Locked Pages Allocated 0
  542. SM Reserved 0
  543. SM Committed 0
  544. Pages Allocated 192
  545.  
  546. (6 row(s) affected)
  547.  
  548. MEMORYCLERK_SOSMEMMANAGER (node 0) KB
  549. ---------------------------------------- -----------
  550. VM Reserved 710632
  551. VM Committed 708784
  552. Locked Pages Allocated 0
  553. SM Reserved 0
  554. SM Committed 0
  555. Pages Allocated 0
  556.  
  557. (6 row(s) affected)
  558.  
  559. MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
  560. ---------------------------------------- -----------
  561. VM Reserved 0
  562. VM Committed 0
  563. Locked Pages Allocated 0
  564. SM Reserved 384
  565. SM Committed 384
  566. Pages Allocated 0
  567.  
  568. (6 row(s) affected)
  569.  
  570. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
  571. ---------------------------------------------- -----------
  572. VM Reserved 0
  573. VM Committed 0
  574. Locked Pages Allocated 0
  575. SM Reserved 0
  576. SM Committed 0
  577. Pages Allocated 208
  578.  
  579. (6 row(s) affected)
  580.  
  581. MEMORYCLERK_FILETABLE (node 0) KB
  582. ---------------------------------------- -----------
  583. VM Reserved 0
  584. VM Committed 0
  585. Locked Pages Allocated 0
  586. SM Reserved 0
  587. SM Committed 0
  588. Pages Allocated 16
  589.  
  590. (6 row(s) affected)
  591.  
  592. MEMORYCLERK_XE (node 0) KB
  593. ---------------------------------------- -----------
  594. VM Reserved 0
  595. VM Committed 0
  596. Locked Pages Allocated 0
  597. SM Reserved 0
  598. SM Committed 0
  599. Pages Allocated 2776
  600.  
  601. (6 row(s) affected)
  602.  
  603. MEMORYCLERK_SQLLOGPOOL (node 0) KB
  604. ---------------------------------------- -----------
  605. VM Reserved 0
  606. VM Committed 0
  607. Locked Pages Allocated 0
  608. SM Reserved 0
  609. SM Committed 0
  610. Pages Allocated 4184
  611.  
  612. (6 row(s) affected)
  613.  
  614. MEMORYCLERK_LWC (node 0) KB
  615. ---------------------------------------- -----------
  616. VM Reserved 0
  617. VM Committed 0
  618. Locked Pages Allocated 0
  619. SM Reserved 0
  620. SM Committed 0
  621. Pages Allocated 128
  622.  
  623. (6 row(s) affected)
  624.  
  625. MEMORYCLERK_FSCHUNKER (node 0) KB
  626. ---------------------------------------- -----------
  627. VM Reserved 0
  628. VM Committed 0
  629. Locked Pages Allocated 0
  630. SM Reserved 0
  631. SM Committed 0
  632. Pages Allocated 48
  633.  
  634. (6 row(s) affected)
  635.  
  636. CACHESTORE_OBJCP (node 0) KB
  637. ---------------------------------------- -----------
  638. VM Reserved 0
  639. VM Committed 0
  640. Locked Pages Allocated 0
  641. SM Reserved 0
  642. SM Committed 0
  643. Pages Allocated 124920
  644.  
  645. (6 row(s) affected)
  646.  
  647. CACHESTORE_SQLCP (node 0) KB
  648. ---------------------------------------- -----------
  649. VM Reserved 0
  650. VM Committed 0
  651. Locked Pages Allocated 0
  652. SM Reserved 0
  653. SM Committed 0
  654. Pages Allocated 255376
  655.  
  656. (6 row(s) affected)
  657.  
  658. CACHESTORE_PHDR (node 0) KB
  659. ---------------------------------------- -----------
  660. VM Reserved 0
  661. VM Committed 0
  662. Locked Pages Allocated 0
  663. SM Reserved 0
  664. SM Committed 0
  665. Pages Allocated 46856
  666.  
  667. (6 row(s) affected)
  668.  
  669. CACHESTORE_XPROC (node 0) KB
  670. ---------------------------------------- -----------
  671. VM Reserved 0
  672. VM Committed 0
  673. Locked Pages Allocated 0
  674. SM Reserved 0
  675. SM Committed 0
  676. Pages Allocated 216
  677.  
  678. (6 row(s) affected)
  679.  
  680. CACHESTORE_TEMPTABLES (node 0) KB
  681. ---------------------------------------- -----------
  682. VM Reserved 0
  683. VM Committed 0
  684. Locked Pages Allocated 0
  685. SM Reserved 0
  686. SM Committed 0
  687. Pages Allocated 72
  688.  
  689. (6 row(s) affected)
  690.  
  691. CACHESTORE_NOTIF (node 0) KB
  692. ---------------------------------------- -----------
  693. VM Reserved 0
  694. VM Committed 0
  695. Locked Pages Allocated 0
  696. SM Reserved 0
  697. SM Committed 0
  698. Pages Allocated 16
  699.  
  700. (6 row(s) affected)
  701.  
  702. CACHESTORE_VIEWDEFINITIONS (node 0) KB
  703. ---------------------------------------- -----------
  704. VM Reserved 0
  705. VM Committed 0
  706. Locked Pages Allocated 0
  707. SM Reserved 0
  708. SM Committed 0
  709. Pages Allocated 88
  710.  
  711. (6 row(s) affected)
  712.  
  713. CACHESTORE_XMLDBTYPE (node 0) KB
  714. ---------------------------------------- -----------
  715. VM Reserved 0
  716. VM Committed 0
  717. Locked Pages Allocated 0
  718. SM Reserved 0
  719. SM Committed 0
  720. Pages Allocated 8
  721.  
  722. (6 row(s) affected)
  723.  
  724. CACHESTORE_XMLDBELEMENT (node 0) KB
  725. ---------------------------------------- -----------
  726. VM Reserved 0
  727. VM Committed 0
  728. Locked Pages Allocated 0
  729. SM Reserved 0
  730. SM Committed 0
  731. Pages Allocated 8
  732.  
  733. (6 row(s) affected)
  734.  
  735. CACHESTORE_XMLDBATTRIBUTE (node 0) KB
  736. ---------------------------------------- -----------
  737. VM Reserved 0
  738. VM Committed 0
  739. Locked Pages Allocated 0
  740. SM Reserved 0
  741. SM Committed 0
  742. Pages Allocated 8
  743.  
  744. (6 row(s) affected)
  745.  
  746. CACHESTORE_STACKFRAMES (node 0) KB
  747. ---------------------------------------- -----------
  748. VM Reserved 0
  749. VM Committed 0
  750. Locked Pages Allocated 0
  751. SM Reserved 0
  752. SM Committed 0
  753. Pages Allocated 8
  754.  
  755. (6 row(s) affected)
  756.  
  757. CACHESTORE_STACKFRAMES (node 1) KB
  758. ---------------------------------------- -----------
  759. VM Reserved 0
  760. VM Committed 0
  761. Locked Pages Allocated 0
  762. SM Reserved 0
  763. SM Committed 0
  764. Pages Allocated 8
  765.  
  766. (6 row(s) affected)
  767.  
  768. CACHESTORE_STACKFRAMES (node 64) KB
  769. ---------------------------------------- -----------
  770. VM Reserved 0
  771. VM Committed 0
  772. Locked Pages Allocated 0
  773. SM Reserved 0
  774. SM Committed 0
  775. Pages Allocated 8
  776.  
  777. (6 row(s) affected)
  778.  
  779. CACHESTORE_STACKFRAMES (Total) KB
  780. ---------------------------------------- -----------
  781. VM Reserved 0
  782. VM Committed 0
  783. Locked Pages Allocated 0
  784. SM Reserved 0
  785. SM Committed 0
  786. Pages Allocated 24
  787.  
  788. (6 row(s) affected)
  789.  
  790. CACHESTORE_BROKERTBLACS (node 0) KB
  791. ---------------------------------------- -----------
  792. VM Reserved 0
  793. VM Committed 0
  794. Locked Pages Allocated 0
  795. SM Reserved 0
  796. SM Committed 0
  797. Pages Allocated 440
  798.  
  799. (6 row(s) affected)
  800.  
  801. CACHESTORE_BROKERTBLACS (node 1) KB
  802. ---------------------------------------- -----------
  803. VM Reserved 0
  804. VM Committed 0
  805. Locked Pages Allocated 0
  806. SM Reserved 0
  807. SM Committed 0
  808. Pages Allocated 24
  809.  
  810. (6 row(s) affected)
  811.  
  812. CACHESTORE_BROKERTBLACS (Total) KB
  813. ---------------------------------------- -----------
  814. VM Reserved 0
  815. VM Committed 0
  816. Locked Pages Allocated 0
  817. SM Reserved 0
  818. SM Committed 0
  819. Pages Allocated 464
  820.  
  821. (6 row(s) affected)
  822.  
  823. CACHESTORE_BROKERKEK (node 0) KB
  824. ---------------------------------------- -----------
  825. VM Reserved 0
  826. VM Committed 0
  827. Locked Pages Allocated 0
  828. SM Reserved 0
  829. SM Committed 0
  830. Pages Allocated 8
  831.  
  832. (6 row(s) affected)
  833.  
  834. CACHESTORE_BROKERDSH (node 0) KB
  835. ---------------------------------------- -----------
  836. VM Reserved 0
  837. VM Committed 0
  838. Locked Pages Allocated 0
  839. SM Reserved 0
  840. SM Committed 0
  841. Pages Allocated 8
  842.  
  843. (6 row(s) affected)
  844.  
  845. CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
  846. ---------------------------------------- -----------
  847. VM Reserved 0
  848. VM Committed 0
  849. Locked Pages Allocated 0
  850. SM Reserved 0
  851. SM Committed 0
  852. Pages Allocated 8
  853.  
  854. (6 row(s) affected)
  855.  
  856. CACHESTORE_BROKERRSB (node 0) KB
  857. ---------------------------------------- -----------
  858. VM Reserved 0
  859. VM Committed 0
  860. Locked Pages Allocated 0
  861. SM Reserved 0
  862. SM Committed 0
  863. Pages Allocated 16
  864.  
  865. (6 row(s) affected)
  866.  
  867. CACHESTORE_BROKERREADONLY (node 0) KB
  868. ---------------------------------------- -----------
  869. VM Reserved 0
  870. VM Committed 0
  871. Locked Pages Allocated 0
  872. SM Reserved 0
  873. SM Committed 0
  874. Pages Allocated 88
  875.  
  876. (6 row(s) affected)
  877.  
  878. CACHESTORE_BROKERTO (node 0) KB
  879. ---------------------------------------- -----------
  880. VM Reserved 0
  881. VM Committed 0
  882. Locked Pages Allocated 0
  883. SM Reserved 0
  884. SM Committed 0
  885. Pages Allocated 8
  886.  
  887. (6 row(s) affected)
  888.  
  889. CACHESTORE_EVENTS (node 0) KB
  890. ---------------------------------------- -----------
  891. VM Reserved 0
  892. VM Committed 0
  893. Locked Pages Allocated 0
  894. SM Reserved 0
  895. SM Committed 0
  896. Pages Allocated 16
  897.  
  898. (6 row(s) affected)
  899.  
  900. CACHESTORE_CLRPROC (node 1) KB
  901. ---------------------------------------- -----------
  902. VM Reserved 0
  903. VM Committed 0
  904. Locked Pages Allocated 0
  905. SM Reserved 0
  906. SM Committed 0
  907. Pages Allocated 216
  908.  
  909. (6 row(s) affected)
  910.  
  911. CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
  912. ----------------------------------------- -----------
  913. VM Reserved 0
  914. VM Committed 0
  915. Locked Pages Allocated 0
  916. SM Reserved 0
  917. SM Committed 0
  918. Pages Allocated 1144
  919.  
  920. (6 row(s) affected)
  921.  
  922. CACHESTORE_SYSTEMROWSET (node 0) KB
  923. ---------------------------------------- -----------
  924. VM Reserved 0
  925. VM Committed 0
  926. Locked Pages Allocated 0
  927. SM Reserved 0
  928. SM Committed 0
  929. Pages Allocated 2912
  930.  
  931. (6 row(s) affected)
  932.  
  933. CACHESTORE_SYSTEMROWSET (node 1) KB
  934. ---------------------------------------- -----------
  935. VM Reserved 0
  936. VM Committed 0
  937. Locked Pages Allocated 0
  938. SM Reserved 0
  939. SM Committed 0
  940. Pages Allocated 648
  941.  
  942. (6 row(s) affected)
  943.  
  944. CACHESTORE_SYSTEMROWSET (Total) KB
  945. ---------------------------------------- -----------
  946. VM Reserved 0
  947. VM Committed 0
  948. Locked Pages Allocated 0
  949. SM Reserved 0
  950. SM Committed 0
  951. Pages Allocated 3560
  952.  
  953. (6 row(s) affected)
  954.  
  955. CACHESTORE_CONVPRI (node 0) KB
  956. ---------------------------------------- -----------
  957. VM Reserved 0
  958. VM Committed 0
  959. Locked Pages Allocated 0
  960. SM Reserved 0
  961. SM Committed 0
  962. Pages Allocated 64
  963.  
  964. (6 row(s) affected)
  965.  
  966. CACHESTORE_CONVPRI (node 1) KB
  967. ---------------------------------------- -----------
  968. VM Reserved 0
  969. VM Committed 0
  970. Locked Pages Allocated 0
  971. SM Reserved 0
  972. SM Committed 0
  973. Pages Allocated 16
  974.  
  975. (6 row(s) affected)
  976.  
  977. CACHESTORE_CONVPRI (Total) KB
  978. ---------------------------------------- -----------
  979. VM Reserved 0
  980. VM Committed 0
  981. Locked Pages Allocated 0
  982. SM Reserved 0
  983. SM Committed 0
  984. Pages Allocated 80
  985.  
  986. (6 row(s) affected)
  987.  
  988. CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
  989. ---------------------------------------- -----------
  990. VM Reserved 0
  991. VM Committed 0
  992. Locked Pages Allocated 0
  993. SM Reserved 0
  994. SM Committed 0
  995. Pages Allocated 32
  996.  
  997. (6 row(s) affected)
  998.  
  999. CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
  1000. ---------------------------------------- -----------
  1001. VM Reserved 0
  1002. VM Committed 0
  1003. Locked Pages Allocated 0
  1004. SM Reserved 0
  1005. SM Committed 0
  1006. Pages Allocated 16
  1007.  
  1008. (6 row(s) affected)
  1009.  
  1010. CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
  1011. ----------------------------------------- -----------
  1012. VM Reserved 0
  1013. VM Committed 0
  1014. Locked Pages Allocated 0
  1015. SM Reserved 0
  1016. SM Committed 0
  1017. Pages Allocated 128
  1018.  
  1019. (6 row(s) affected)
  1020.  
  1021. CACHESTORE_XML_SELECTIVE_DG (node 0) KB
  1022. ---------------------------------------- -----------
  1023. VM Reserved 0
  1024. VM Committed 0
  1025. Locked Pages Allocated 0
  1026. SM Reserved 0
  1027. SM Committed 0
  1028. Pages Allocated 8
  1029.  
  1030. (6 row(s) affected)
  1031.  
  1032. USERSTORE_SCHEMAMGR (node 0) KB
  1033. ---------------------------------------- -----------
  1034. VM Reserved 0
  1035. VM Committed 0
  1036. Locked Pages Allocated 0
  1037. SM Reserved 0
  1038. SM Committed 0
  1039. Pages Allocated 30688
  1040.  
  1041. (6 row(s) affected)
  1042.  
  1043. USERSTORE_DBMETADATA (node 0) KB
  1044. ---------------------------------------- -----------
  1045. VM Reserved 0
  1046. VM Committed 0
  1047. Locked Pages Allocated 0
  1048. SM Reserved 0
  1049. SM Committed 0
  1050. Pages Allocated 5648
  1051.  
  1052. (6 row(s) affected)
  1053.  
  1054. USERSTORE_DBMETADATA (node 1) KB
  1055. ---------------------------------------- -----------
  1056. VM Reserved 0
  1057. VM Committed 0
  1058. Locked Pages Allocated 0
  1059. SM Reserved 0
  1060. SM Committed 0
  1061. Pages Allocated 5192
  1062.  
  1063. (6 row(s) affected)
  1064.  
  1065. USERSTORE_DBMETADATA (Total) KB
  1066. ---------------------------------------- -----------
  1067. VM Reserved 0
  1068. VM Committed 0
  1069. Locked Pages Allocated 0
  1070. SM Reserved 0
  1071. SM Committed 0
  1072. Pages Allocated 10840
  1073.  
  1074. (6 row(s) affected)
  1075.  
  1076. USERSTORE_TOKENPERM (node 0) KB
  1077. ---------------------------------------- -----------
  1078. VM Reserved 0
  1079. VM Committed 0
  1080. Locked Pages Allocated 0
  1081. SM Reserved 0
  1082. SM Committed 0
  1083. Pages Allocated 17016
  1084.  
  1085. (6 row(s) affected)
  1086.  
  1087. USERSTORE_TOKENPERM (node 1) KB
  1088. ---------------------------------------- -----------
  1089. VM Reserved 0
  1090. VM Committed 0
  1091. Locked Pages Allocated 0
  1092. SM Reserved 0
  1093. SM Committed 0
  1094. Pages Allocated 1952
  1095.  
  1096. (6 row(s) affected)
  1097.  
  1098. USERSTORE_TOKENPERM (Total) KB
  1099. ---------------------------------------- -----------
  1100. VM Reserved 0
  1101. VM Committed 0
  1102. Locked Pages Allocated 0
  1103. SM Reserved 0
  1104. SM Committed 0
  1105. Pages Allocated 18968
  1106.  
  1107. (6 row(s) affected)
  1108.  
  1109. USERSTORE_OBJPERM (node 0) KB
  1110. ---------------------------------------- -----------
  1111. VM Reserved 0
  1112. VM Committed 0
  1113. Locked Pages Allocated 0
  1114. SM Reserved 0
  1115. SM Committed 0
  1116. Pages Allocated 2528
  1117.  
  1118. (6 row(s) affected)
  1119.  
  1120. USERSTORE_OBJPERM (node 1) KB
  1121. ---------------------------------------- -----------
  1122. VM Reserved 0
  1123. VM Committed 0
  1124. Locked Pages Allocated 0
  1125. SM Reserved 0
  1126. SM Committed 0
  1127. Pages Allocated 416
  1128.  
  1129. (6 row(s) affected)
  1130.  
  1131. USERSTORE_OBJPERM (Total) KB
  1132. ---------------------------------------- -----------
  1133. VM Reserved 0
  1134. VM Committed 0
  1135. Locked Pages Allocated 0
  1136. SM Reserved 0
  1137. SM Committed 0
  1138. Pages Allocated 2944
  1139.  
  1140. (6 row(s) affected)
  1141.  
  1142. USERSTORE_SXC (node 0) KB
  1143. ---------------------------------------- -----------
  1144. VM Reserved 0
  1145. VM Committed 0
  1146. Locked Pages Allocated 0
  1147. SM Reserved 0
  1148. SM Committed 0
  1149. Pages Allocated 184
  1150.  
  1151. (6 row(s) affected)
  1152.  
  1153. USERSTORE_SXC (node 1) KB
  1154. ---------------------------------------- -----------
  1155. VM Reserved 0
  1156. VM Committed 0
  1157. Locked Pages Allocated 0
  1158. SM Reserved 0
  1159. SM Committed 0
  1160. Pages Allocated 128
  1161.  
  1162. (6 row(s) affected)
  1163.  
  1164. USERSTORE_SXC (node 64) KB
  1165. ---------------------------------------- -----------
  1166. VM Reserved 0
  1167. VM Committed 0
  1168. Locked Pages Allocated 0
  1169. SM Reserved 0
  1170. SM Committed 0
  1171. Pages Allocated 8
  1172.  
  1173. (6 row(s) affected)
  1174.  
  1175. USERSTORE_SXC (Total) KB
  1176. ---------------------------------------- -----------
  1177. VM Reserved 0
  1178. VM Committed 0
  1179. Locked Pages Allocated 0
  1180. SM Reserved 0
  1181. SM Committed 0
  1182. Pages Allocated 320
  1183.  
  1184. (6 row(s) affected)
  1185.  
  1186. OBJECTSTORE_LBSS (node 0) KB
  1187. ---------------------------------------- -----------
  1188. VM Reserved 0
  1189. VM Committed 0
  1190. Locked Pages Allocated 0
  1191. SM Reserved 0
  1192. SM Committed 0
  1193. Pages Allocated 1184
  1194.  
  1195. (6 row(s) affected)
  1196.  
  1197. OBJECTSTORE_LBSS (node 1) KB
  1198. ---------------------------------------- -----------
  1199. VM Reserved 0
  1200. VM Committed 0
  1201. Locked Pages Allocated 0
  1202. SM Reserved 0
  1203. SM Committed 0
  1204. Pages Allocated 1024
  1205.  
  1206. (6 row(s) affected)
  1207.  
  1208. OBJECTSTORE_LBSS (Total) KB
  1209. ---------------------------------------- -----------
  1210. VM Reserved 0
  1211. VM Committed 0
  1212. Locked Pages Allocated 0
  1213. SM Reserved 0
  1214. SM Committed 0
  1215. Pages Allocated 2208
  1216.  
  1217. (6 row(s) affected)
  1218.  
  1219. OBJECTSTORE_SNI_PACKET (node 0) KB
  1220. ---------------------------------------- -----------
  1221. VM Reserved 0
  1222. VM Committed 0
  1223. Locked Pages Allocated 0
  1224. SM Reserved 0
  1225. SM Committed 0
  1226. Pages Allocated 2288
  1227.  
  1228. (6 row(s) affected)
  1229.  
  1230. OBJECTSTORE_SNI_PACKET (node 1) KB
  1231. ---------------------------------------- -----------
  1232. VM Reserved 0
  1233. VM Committed 0
  1234. Locked Pages Allocated 0
  1235. SM Reserved 0
  1236. SM Committed 0
  1237. Pages Allocated 1792
  1238.  
  1239. (6 row(s) affected)
  1240.  
  1241. OBJECTSTORE_SNI_PACKET (node 64) KB
  1242. ---------------------------------------- -----------
  1243. VM Reserved 0
  1244. VM Committed 0
  1245. Locked Pages Allocated 0
  1246. SM Reserved 0
  1247. SM Committed 0
  1248. Pages Allocated 56
  1249.  
  1250. (6 row(s) affected)
  1251.  
  1252. OBJECTSTORE_SNI_PACKET (Total) KB
  1253. ---------------------------------------- -----------
  1254. VM Reserved 0
  1255. VM Committed 0
  1256. Locked Pages Allocated 0
  1257. SM Reserved 0
  1258. SM Committed 0
  1259. Pages Allocated 4136
  1260.  
  1261. (6 row(s) affected)
  1262.  
  1263. OBJECTSTORE_SERVICE_BROKER (node 0) KB
  1264. ---------------------------------------- -----------
  1265. VM Reserved 0
  1266. VM Committed 0
  1267. Locked Pages Allocated 0
  1268. SM Reserved 0
  1269. SM Committed 0
  1270. Pages Allocated 520
  1271.  
  1272. (6 row(s) affected)
  1273.  
  1274. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  1275. ---------------------------------------- -----------
  1276. VM Reserved 262144
  1277. VM Committed 262144
  1278. Locked Pages Allocated 0
  1279. SM Reserved 0
  1280. SM Committed 0
  1281. Pages Allocated 469184
  1282.  
  1283. (6 row(s) affected)
  1284.  
  1285. OBJECTSTORE_LOCK_MANAGER (node 1) KB
  1286. ---------------------------------------- -----------
  1287. VM Reserved 0
  1288. VM Committed 0
  1289. Locked Pages Allocated 0
  1290. SM Reserved 0
  1291. SM Committed 0
  1292. Pages Allocated 867040
  1293.  
  1294. (6 row(s) affected)
  1295.  
  1296. OBJECTSTORE_LOCK_MANAGER (node 64) KB
  1297. ---------------------------------------- -----------
  1298. VM Reserved 0
  1299. VM Committed 0
  1300. Locked Pages Allocated 0
  1301. SM Reserved 0
  1302. SM Committed 0
  1303. Pages Allocated 24
  1304.  
  1305. (6 row(s) affected)
  1306.  
  1307. OBJECTSTORE_LOCK_MANAGER (Total) KB
  1308. ---------------------------------------- -----------
  1309. VM Reserved 262144
  1310. VM Committed 262144
  1311. Locked Pages Allocated 0
  1312. SM Reserved 0
  1313. SM Committed 0
  1314. Pages Allocated 1336248
  1315.  
  1316. (6 row(s) affected)
  1317.  
  1318. OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
  1319. ------------------------------------------ -----------
  1320. VM Reserved 0
  1321. VM Committed 0
  1322. Locked Pages Allocated 0
  1323. SM Reserved 0
  1324. SM Committed 0
  1325. Pages Allocated 16
  1326.  
  1327. (6 row(s) affected)
  1328.  
  1329. OBJECTSTORE_XACT_CACHE (node 0) KB
  1330. ---------------------------------------- -----------
  1331. VM Reserved 0
  1332. VM Committed 0
  1333. Locked Pages Allocated 0
  1334. SM Reserved 0
  1335. SM Committed 0
  1336. Pages Allocated 21344
  1337.  
  1338. (6 row(s) affected)
  1339.  
  1340. OBJECTSTORE_XACT_CACHE (node 1) KB
  1341. ---------------------------------------- -----------
  1342. VM Reserved 0
  1343. VM Committed 0
  1344. Locked Pages Allocated 0
  1345. SM Reserved 0
  1346. SM Committed 0
  1347. Pages Allocated 18800
  1348.  
  1349. (6 row(s) affected)
  1350.  
  1351. OBJECTSTORE_XACT_CACHE (node 64) KB
  1352. ---------------------------------------- -----------
  1353. VM Reserved 0
  1354. VM Committed 0
  1355. Locked Pages Allocated 0
  1356. SM Reserved 0
  1357. SM Committed 0
  1358. Pages Allocated 16
  1359.  
  1360. (6 row(s) affected)
  1361.  
  1362. OBJECTSTORE_XACT_CACHE (Total) KB
  1363. ---------------------------------------- -----------
  1364. VM Reserved 0
  1365. VM Committed 0
  1366. Locked Pages Allocated 0
  1367. SM Reserved 0
  1368. SM Committed 0
  1369. Pages Allocated 40160
  1370.  
  1371. (6 row(s) affected)
  1372.  
  1373. Buffer Pool Value
  1374. ---------------------------------------- -----------
  1375. Database 7001717
  1376. Simulated 1330542
  1377. Target 261898240
  1378. Dirty 13110
  1379. In IO 0
  1380. Latched 3
  1381. Page Life Expectancy 2388
  1382.  
  1383. (7 row(s) affected)
  1384.  
  1385. Procedure Cache Value
  1386. ---------------------------------------- -----------
  1387. TotalProcs 3347
  1388. TotalPages 53421
  1389. InUsePages 2813
  1390.  
  1391. (3 row(s) affected)
  1392.  
  1393. Global Memory Objects Pages
  1394. ---------------------------------------- -----------
  1395. Resource 2770
  1396. Locks 167031
  1397. XDES 606
  1398. DirtyPageTracking 22
  1399. SETLS 16
  1400. SubpDesc Allocators 16
  1401. SE SchemaManager 2006
  1402. SE Column Metadata Cache 1829
  1403. SE Column Metadata Cache Store 27
  1404. SQLCache 580
  1405. Replication 2
  1406. ServerGlobal 55
  1407. XP Global 2
  1408. SortTables 3
  1409.  
  1410. (14 row(s) affected)
  1411.  
  1412. Query Memory Objects (internal) Value
  1413. ---------------------------------------- -----------
  1414. Grants 0
  1415. Waiting 0
  1416. Available 5609198
  1417. Current Max 5609198
  1418. Future Max 5609198
  1419. Physical Max 6299648
  1420. Next Request 0
  1421. Waiting For 0
  1422. Cost 0
  1423. Timeout 0
  1424. Wait Time 0
  1425.  
  1426. (11 row(s) affected)
  1427.  
  1428. Small Query Memory Objects (internal) Value
  1429. ---------------------------------------- -----------
  1430. Grants 0
  1431. Waiting 0
  1432. Available 90112
  1433. Current Max 90112
  1434. Future Max 90112
  1435.  
  1436. (5 row(s) affected)
  1437.  
  1438. Remote Query Memory Objects (internal) Value
  1439. ---------------------------------------- -----------
  1440. Grants 0
  1441. Waiting 0
  1442. Available 3149824
  1443. Current Max 3149824
  1444.  
  1445. (4 row(s) affected)
  1446.  
  1447. Query Memory Objects (default) Value
  1448. ---------------------------------------- -----------
  1449. Grants 0
  1450. Waiting 0
  1451. Available 6299648
  1452. Current Max 6299648
  1453. Future Max 6299648
  1454. Physical Max 6299648
  1455. Next Request 0
  1456. Waiting For 0
  1457. Cost 0
  1458. Timeout 0
  1459. Wait Time 0
  1460.  
  1461. (11 row(s) affected)
  1462.  
  1463. Small Query Memory Objects (default) Value
  1464. ---------------------------------------- -----------
  1465. Grants 0
  1466. Waiting 0
  1467. Available 90112
  1468. Current Max 90112
  1469. Future Max 90112
  1470.  
  1471. (5 row(s) affected)
  1472.  
  1473. Remote Query Memory Objects (default) Value
  1474. ---------------------------------------- -----------
  1475. Grants 0
  1476. Waiting 0
  1477. Available 3149824
  1478. Current Max 3149824
  1479.  
  1480. (4 row(s) affected)
  1481.  
  1482. Optimization Queue (internal) Value
  1483. ---------------------------------------- --------------------
  1484. Overall Memory 55834574848
  1485. Target Memory 50007924736
  1486. Last Notification 1
  1487. Timeout 6
  1488. Early Termination Factor 5
  1489.  
  1490. (5 row(s) affected)
  1491.  
  1492. Small Gateway (internal) Value
  1493. ---------------------------------------- -----------
  1494. Configured Units 64
  1495. Available Units 64
  1496. Acquires 0
  1497. Waiters 0
  1498. Threshold Factor 380000
  1499. Threshold 380000
  1500.  
  1501. (6 row(s) affected)
  1502.  
  1503. Medium Gateway (internal) Value
  1504. ---------------------------------------- -----------
  1505. Configured Units 16
  1506. Available Units 16
  1507. Acquires 0
  1508. Waiters 0
  1509. Threshold Factor 12
  1510. Threshold -1
  1511.  
  1512. (6 row(s) affected)
  1513.  
  1514. Big Gateway (internal) Value
  1515. ---------------------------------------- -----------
  1516. Configured Units 1
  1517. Available Units 1
  1518. Acquires 0
  1519. Waiters 0
  1520. Threshold Factor 8
  1521. Threshold -1
  1522.  
  1523. (6 row(s) affected)
  1524.  
  1525. Optimization Queue (default) Value
  1526. ---------------------------------------- --------------------
  1527. Overall Memory 55834574848
  1528. Target Memory 50204483584
  1529. Last Notification 1
  1530. Timeout 6
  1531. Early Termination Factor 5
  1532.  
  1533. (5 row(s) affected)
  1534.  
  1535. Small Gateway (default) Value
  1536. ---------------------------------------- -----------
  1537. Configured Units 64
  1538. Available Units 64
  1539. Acquires 0
  1540. Waiters 0
  1541. Threshold Factor 380000
  1542. Threshold 380000
  1543.  
  1544. (6 row(s) affected)
  1545.  
  1546. Medium Gateway (default) Value
  1547. ---------------------------------------- -----------
  1548. Configured Units 16
  1549. Available Units 16
  1550. Acquires 0
  1551. Waiters 0
  1552. Threshold Factor 12
  1553. Threshold -1
  1554.  
  1555. (6 row(s) affected)
  1556.  
  1557. Big Gateway (default) Value
  1558. ---------------------------------------- -----------
  1559. Configured Units 1
  1560. Available Units 1
  1561. Acquires 0
  1562. Waiters 0
  1563. Threshold Factor 8
  1564. Threshold -1
  1565.  
  1566. (6 row(s) affected)
  1567.  
  1568. Memory Pool Manager Pages
  1569. ---------------------------------------- -----------
  1570. Reserved Current 0
  1571. Reserved Limit 7654181
  1572.  
  1573. (2 row(s) affected)
  1574.  
  1575. Memory Pool (internal) Pages
  1576. ---------------------------------------- -----------
  1577. Allocations 455550
  1578. Predicted 455550
  1579. Private Target 0
  1580. Private Limit 0
  1581. Total Target 8388609
  1582. Total Limit 8388609
  1583. OOM Count 0
  1584.  
  1585. (7 row(s) affected)
  1586.  
  1587. MEMORYBROKER_FOR_CACHE (internal) Pages
  1588. ---------------------------------------- -----------
  1589. Allocations 5921
  1590. Rate 0
  1591. Target Allocations 6085190
  1592. Future Allocations 0
  1593. Overall 6815744
  1594. Last Notification 1
  1595.  
  1596. (6 row(s) affected)
  1597.  
  1598. MEMORYBROKER_FOR_STEAL (internal) Pages
  1599. ---------------------------------------- -----------
  1600. Allocations 25214
  1601. Rate 0
  1602. Target Allocations 6104483
  1603. Future Allocations 0
  1604. Overall 6815744
  1605. Last Notification 1
  1606.  
  1607. (6 row(s) affected)
  1608.  
  1609. MEMORYBROKER_FOR_RESERVE (internal) Pages
  1610. ---------------------------------------- -----------
  1611. Allocations 0
  1612. Rate 0
  1613. Target Allocations 6079269
  1614. Future Allocations 0
  1615. Overall 6815744
  1616. Last Notification 1
  1617.  
  1618. (6 row(s) affected)
  1619.  
  1620. MEMORYBROKER_FOR_COMMITTED (internal) Pages
  1621. ---------------------------------------- -----------
  1622. Allocations 424413
  1623. Rate 0
  1624. Target Allocations 6503682
  1625. Future Allocations 0
  1626. Overall 6815744
  1627. Last Notification 1
  1628.  
  1629. (6 row(s) affected)
  1630.  
  1631. MEMORYBROKER_FOR_XTP (internal) Pages
  1632. ---------------------------------------- -----------
  1633. Allocations 2
  1634. Rate 0
  1635. Target Allocations 6079271
  1636. Future Allocations 0
  1637. Overall 6815744
  1638. Last Notification 1
  1639.  
  1640. (6 row(s) affected)
  1641.  
  1642. Memory Pool (default) Pages
  1643. ---------------------------------------- -----------
  1644. Allocations 278878
  1645. Predicted 1853790
  1646. Private Target 0
  1647. Private Limit 0
  1648. Total Target 8388609
  1649. Total Limit 8388609
  1650. OOM Count 0
  1651.  
  1652. (7 row(s) affected)
  1653.  
  1654. MEMORYBROKER_FOR_CACHE (default) Pages
  1655. ---------------------------------------- -----------
  1656. Allocations 229670
  1657. Rate 0
  1658. Target Allocations 6308939
  1659. Future Allocations 0
  1660. Overall 6815744
  1661. Last Notification 1
  1662.  
  1663. (6 row(s) affected)
  1664.  
  1665. MEMORYBROKER_FOR_STEAL (default) Pages
  1666. ---------------------------------------- -----------
  1667. Allocations 49208
  1668. Rate 0
  1669. Target Allocations 6128477
  1670. Future Allocations 0
  1671. Overall 6815744
  1672. Last Notification 1
  1673.  
  1674. (6 row(s) affected)
  1675.  
  1676. MEMORYBROKER_FOR_RESERVE (default) Pages
  1677. ---------------------------------------- -----------
  1678. Allocations 0
  1679. Rate 0
  1680. Target Allocations 6815744
  1681. Future Allocations 1574912
  1682. Overall 6815744
  1683. Last Notification 1
  1684.  
  1685. (6 row(s) affected)
  1686.  
  1687. MEMORYBROKER_FOR_XTP (default) Pages
  1688. ---------------------------------------- -----------
  1689. Allocations 0
  1690. Rate 0
  1691. Target Allocations 6079269
  1692. Future Allocations 0
  1693. Overall 6815744
  1694. Last Notification 1
  1695.  
  1696. (6 row(s) affected)
  1697.  
  1698. Memory Broker Clerk (Buffer Pool) Pages
  1699. ---------------------------------------- ----------------------
  1700. Total 7001717
  1701. Simulated 1330542
  1702. Simulation Benefit 0
  1703. Internal Benefit 0
  1704. External Benefit 0
  1705. Value Of Memory 0
  1706. Periodic Freed 0
  1707. Internal Freed 0
  1708.  
  1709. (8 row(s) affected)
  1710.  
  1711. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!