API tools faq
paste
Advertisement
Guest User

DBCC Mem 8/17

a guest
Aug 17th, 2017
457
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.01 KB | None | 0 0
raw download clone embed print report
  1. Process/System Counts Value
  2. ---------------------------------------- --------------------
  3. Available Physical Memory 1986715648
  4. Available Virtual Memory 140699568984064
  5. Available Paging File 5020770304
  6. Working Set 165380096
  7. Percent of Committed Memory in WS 99
  8. Page Faults 642205
  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 36626224
  19. VM Committed 185740
  20. Locked Pages Allocated 20876540
  21. Large Pages Allocated 0
  22. Emergency Memory 1024
  23. Emergency Memory In Use 16
  24. Target Committed 21504000
  25. Current Committed 21062280
  26. Pages Allocated 1020224
  27. Pages Reserved 0
  28. Pages Free 19808816
  29. Pages In Use 640696
  30. Page Alloc Potential 19788104
  31. NUMA Growth Phase 0
  32. Last OOM Factor 1
  33. Last OS Error 0
  34.  
  35. (16 row(s) affected)
  36.  
  37. Memory node Id = 0 KB
  38. ---------------------------------------- -----------
  39. VM Reserved 36626160
  40. VM Committed 185720
  41. Locked Pages Allocated 20876540
  42. Pages Allocated 1020224
  43. Pages Free 19808816
  44. Target Committed 21503976
  45. Current Committed 21062264
  46. Foreign Committed 0
  47. Away Committed 0
  48. Taken Away Committed 0
  49.  
  50. (10 row(s) affected)
  51.  
  52. Memory node Id = 64 KB
  53. ---------------------------------------- -----------
  54. VM Reserved 0
  55. VM Committed 20
  56. Locked Pages Allocated 0
  57.  
  58. (3 row(s) affected)
  59.  
  60. MEMORYCLERK_SQLGENERAL (node 0) KB
  61. ---------------------------------------- -----------
  62. VM Reserved 0
  63. VM Committed 0
  64. Locked Pages Allocated 0
  65. SM Reserved 0
  66. SM Committed 0
  67. Pages Allocated 7776
  68.  
  69. (6 row(s) affected)
  70.  
  71. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  72. ---------------------------------------- -----------
  73. VM Reserved 9731808
  74. VM Committed 32768
  75. Locked Pages Allocated 30580
  76. SM Reserved 0
  77. SM Committed 0
  78. Pages Allocated 612776
  79.  
  80. (6 row(s) affected)
  81.  
  82. MEMORYCLERK_SQLQUERYEXEC (node 0) KB
  83. ---------------------------------------- -----------
  84. VM Reserved 0
  85. VM Committed 0
  86. Locked Pages Allocated 0
  87. SM Reserved 0
  88. SM Committed 0
  89. Pages Allocated 320
  90.  
  91. (6 row(s) affected)
  92.  
  93. MEMORYCLERK_SQLOPTIMIZER (node 0) KB
  94. ---------------------------------------- -----------
  95. VM Reserved 0
  96. VM Committed 0
  97. Locked Pages Allocated 0
  98. SM Reserved 0
  99. SM Committed 0
  100. Pages Allocated 1168
  101.  
  102. (6 row(s) affected)
  103.  
  104. MEMORYCLERK_SQLUTILITIES (node 0) KB
  105. ---------------------------------------- -----------
  106. VM Reserved 0
  107. VM Committed 0
  108. Locked Pages Allocated 0
  109. SM Reserved 0
  110. SM Committed 0
  111. Pages Allocated 27256
  112.  
  113. (6 row(s) affected)
  114.  
  115. MEMORYCLERK_SQLSTORENG (node 0) KB
  116. ---------------------------------------- -----------
  117. VM Reserved 2240
  118. VM Committed 2240
  119. Locked Pages Allocated 0
  120. SM Reserved 0
  121. SM Committed 0
  122. Pages Allocated 9616
  123.  
  124. (6 row(s) affected)
  125.  
  126. MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
  127. ---------------------------------------- -----------
  128. VM Reserved 0
  129. VM Committed 0
  130. Locked Pages Allocated 0
  131. SM Reserved 0
  132. SM Committed 0
  133. Pages Allocated 2688
  134.  
  135. (6 row(s) affected)
  136.  
  137. MEMORYCLERK_SQLCLR (node 0) KB
  138. ---------------------------------------- -----------
  139. VM Reserved 3151360
  140. VM Committed 3540
  141. Locked Pages Allocated 0
  142. SM Reserved 0
  143. SM Committed 0
  144. Pages Allocated 5960
  145.  
  146. (6 row(s) affected)
  147.  
  148. MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
  149. ---------------------------------------- -----------
  150. VM Reserved 0
  151. VM Committed 0
  152. Locked Pages Allocated 0
  153. SM Reserved 0
  154. SM Committed 0
  155. Pages Allocated 520
  156.  
  157. (6 row(s) affected)
  158.  
  159. MEMORYCLERK_SQLHTTP (node 0) KB
  160. ---------------------------------------- -----------
  161. VM Reserved 0
  162. VM Committed 0
  163. Locked Pages Allocated 0
  164. SM Reserved 0
  165. SM Committed 0
  166. Pages Allocated 8
  167.  
  168. (6 row(s) affected)
  169.  
  170. MEMORYCLERK_SNI (node 0) KB
  171. ---------------------------------------- -----------
  172. VM Reserved 0
  173. VM Committed 0
  174. Locked Pages Allocated 0
  175. SM Reserved 0
  176. SM Committed 0
  177. Pages Allocated 192
  178.  
  179. (6 row(s) affected)
  180.  
  181. MEMORYCLERK_SNI (node 64) KB
  182. ---------------------------------------- -----------
  183. VM Reserved 0
  184. VM Committed 0
  185. Locked Pages Allocated 0
  186. SM Reserved 0
  187. SM Committed 0
  188. Pages Allocated 16
  189.  
  190. (6 row(s) affected)
  191.  
  192. MEMORYCLERK_SNI (Total) KB
  193. ---------------------------------------- -----------
  194. VM Reserved 0
  195. VM Committed 0
  196. Locked Pages Allocated 0
  197. SM Reserved 0
  198. SM Committed 0
  199. Pages Allocated 208
  200.  
  201. (6 row(s) affected)
  202.  
  203. MEMORYCLERK_FULLTEXT (node 0) KB
  204. ---------------------------------------- -----------
  205. VM Reserved 0
  206. VM Committed 0
  207. Locked Pages Allocated 0
  208. SM Reserved 0
  209. SM Committed 0
  210. Pages Allocated 296
  211.  
  212. (6 row(s) affected)
  213.  
  214. MEMORYCLERK_SQLXP (node 0) KB
  215. ---------------------------------------- -----------
  216. VM Reserved 0
  217. VM Committed 0
  218. Locked Pages Allocated 0
  219. SM Reserved 0
  220. SM Committed 0
  221. Pages Allocated 16
  222.  
  223. (6 row(s) affected)
  224.  
  225. MEMORYCLERK_BHF (node 0) KB
  226. ---------------------------------------- -----------
  227. VM Reserved 0
  228. VM Committed 0
  229. Locked Pages Allocated 0
  230. SM Reserved 0
  231. SM Committed 0
  232. Pages Allocated 48
  233.  
  234. (6 row(s) affected)
  235.  
  236. MEMORYCLERK_XE_BUFFER (node 0) KB
  237. ---------------------------------------- -----------
  238. VM Reserved 4608
  239. VM Committed 4608
  240. Locked Pages Allocated 0
  241. SM Reserved 0
  242. SM Committed 0
  243. Pages Allocated 0
  244.  
  245. (6 row(s) affected)
  246.  
  247. MEMORYCLERK_XTP (node 0) KB
  248. ---------------------------------------- -----------
  249. VM Reserved 0
  250. VM Committed 0
  251. Locked Pages Allocated 0
  252. SM Reserved 0
  253. SM Committed 0
  254. Pages Allocated 16
  255.  
  256. (6 row(s) affected)
  257.  
  258. MEMORYCLERK_HOST (node 0) KB
  259. ---------------------------------------- -----------
  260. VM Reserved 0
  261. VM Committed 0
  262. Locked Pages Allocated 0
  263. SM Reserved 0
  264. SM Committed 0
  265. Pages Allocated 24
  266.  
  267. (6 row(s) affected)
  268.  
  269. MEMORYCLERK_SOSNODE (node 0) KB
  270. ---------------------------------------- -----------
  271. VM Reserved 0
  272. VM Committed 0
  273. Locked Pages Allocated 0
  274. SM Reserved 0
  275. SM Committed 0
  276. Pages Allocated 47920
  277.  
  278. (6 row(s) affected)
  279.  
  280. MEMORYCLERK_SOSNODE (node 64) KB
  281. ---------------------------------------- -----------
  282. VM Reserved 0
  283. VM Committed 0
  284. Locked Pages Allocated 0
  285. SM Reserved 0
  286. SM Committed 0
  287. Pages Allocated 2432
  288.  
  289. (6 row(s) affected)
  290.  
  291. MEMORYCLERK_SOSNODE (Total) KB
  292. ---------------------------------------- -----------
  293. VM Reserved 0
  294. VM Committed 0
  295. Locked Pages Allocated 0
  296. SM Reserved 0
  297. SM Committed 0
  298. Pages Allocated 50352
  299.  
  300. (6 row(s) affected)
  301.  
  302. MEMORYCLERK_SOSOS (node 0) KB
  303. ---------------------------------------- -----------
  304. VM Reserved 0
  305. VM Committed 0
  306. Locked Pages Allocated 0
  307. SM Reserved 0
  308. SM Committed 0
  309. Pages Allocated 192
  310.  
  311. (6 row(s) affected)
  312.  
  313. MEMORYCLERK_SOSMEMMANAGER (node 0) KB
  314. ---------------------------------------- -----------
  315. VM Reserved 91800
  316. VM Committed 74776
  317. Locked Pages Allocated 16920
  318. SM Reserved 0
  319. SM Committed 0
  320. Pages Allocated 0
  321.  
  322. (6 row(s) affected)
  323.  
  324. MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
  325. ---------------------------------------- -----------
  326. VM Reserved 0
  327. VM Committed 0
  328. Locked Pages Allocated 0
  329. SM Reserved 48
  330. SM Committed 48
  331. Pages Allocated 0
  332.  
  333. (6 row(s) affected)
  334.  
  335. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
  336. ---------------------------------------------- -----------
  337. VM Reserved 0
  338. VM Committed 0
  339. Locked Pages Allocated 0
  340. SM Reserved 0
  341. SM Committed 0
  342. Pages Allocated 232
  343.  
  344. (6 row(s) affected)
  345.  
  346. MEMORYCLERK_FILETABLE (node 0) KB
  347. ---------------------------------------- -----------
  348. VM Reserved 0
  349. VM Committed 0
  350. Locked Pages Allocated 0
  351. SM Reserved 0
  352. SM Committed 0
  353. Pages Allocated 16
  354.  
  355. (6 row(s) affected)
  356.  
  357. MEMORYCLERK_XE (node 0) KB
  358. ---------------------------------------- -----------
  359. VM Reserved 0
  360. VM Committed 0
  361. Locked Pages Allocated 0
  362. SM Reserved 0
  363. SM Committed 0
  364. Pages Allocated 6232
  365.  
  366. (6 row(s) affected)
  367.  
  368. MEMORYCLERK_SPATIAL (node 0) KB
  369. ---------------------------------------- -----------
  370. VM Reserved 0
  371. VM Committed 0
  372. Locked Pages Allocated 0
  373. SM Reserved 0
  374. SM Committed 0
  375. Pages Allocated 16
  376.  
  377. (6 row(s) affected)
  378.  
  379. MEMORYCLERK_SQLLOGPOOL (node 0) KB
  380. ---------------------------------------- -----------
  381. VM Reserved 0
  382. VM Committed 0
  383. Locked Pages Allocated 0
  384. SM Reserved 0
  385. SM Committed 0
  386. Pages Allocated 4184
  387.  
  388. (6 row(s) affected)
  389.  
  390. MEMORYCLERK_LWC (node 0) KB
  391. ---------------------------------------- -----------
  392. VM Reserved 0
  393. VM Committed 0
  394. Locked Pages Allocated 0
  395. SM Reserved 0
  396. SM Committed 0
  397. Pages Allocated 16
  398.  
  399. (6 row(s) affected)
  400.  
  401. MEMORYCLERK_FSCHUNKER (node 0) KB
  402. ---------------------------------------- -----------
  403. VM Reserved 0
  404. VM Committed 0
  405. Locked Pages Allocated 0
  406. SM Reserved 0
  407. SM Committed 0
  408. Pages Allocated 48
  409.  
  410. (6 row(s) affected)
  411.  
  412. CACHESTORE_OBJCP (node 0) KB
  413. ---------------------------------------- -----------
  414. VM Reserved 0
  415. VM Committed 0
  416. Locked Pages Allocated 0
  417. SM Reserved 0
  418. SM Committed 0
  419. Pages Allocated 122952
  420.  
  421. (6 row(s) affected)
  422.  
  423. CACHESTORE_SQLCP (node 0) KB
  424. ---------------------------------------- -----------
  425. VM Reserved 0
  426. VM Committed 0
  427. Locked Pages Allocated 0
  428. SM Reserved 0
  429. SM Committed 0
  430. Pages Allocated 81240
  431.  
  432. (6 row(s) affected)
  433.  
  434. CACHESTORE_PHDR (node 0) KB
  435. ---------------------------------------- -----------
  436. VM Reserved 0
  437. VM Committed 0
  438. Locked Pages Allocated 0
  439. SM Reserved 0
  440. SM Committed 0
  441. Pages Allocated 30912
  442.  
  443. (6 row(s) affected)
  444.  
  445. CACHESTORE_XPROC (node 0) KB
  446. ---------------------------------------- -----------
  447. VM Reserved 0
  448. VM Committed 0
  449. Locked Pages Allocated 0
  450. SM Reserved 0
  451. SM Committed 0
  452. Pages Allocated 112
  453.  
  454. (6 row(s) affected)
  455.  
  456. CACHESTORE_TEMPTABLES (node 0) KB
  457. ---------------------------------------- -----------
  458. VM Reserved 0
  459. VM Committed 0
  460. Locked Pages Allocated 0
  461. SM Reserved 0
  462. SM Committed 0
  463. Pages Allocated 152
  464.  
  465. (6 row(s) affected)
  466.  
  467. CACHESTORE_NOTIF (node 0) KB
  468. ---------------------------------------- -----------
  469. VM Reserved 0
  470. VM Committed 0
  471. Locked Pages Allocated 0
  472. SM Reserved 0
  473. SM Committed 0
  474. Pages Allocated 16
  475.  
  476. (6 row(s) affected)
  477.  
  478. CACHESTORE_VIEWDEFINITIONS (node 0) KB
  479. ---------------------------------------- -----------
  480. VM Reserved 0
  481. VM Committed 0
  482. Locked Pages Allocated 0
  483. SM Reserved 0
  484. SM Committed 0
  485. Pages Allocated 16
  486.  
  487. (6 row(s) affected)
  488.  
  489. CACHESTORE_XMLDBTYPE (node 0) KB
  490. ---------------------------------------- -----------
  491. VM Reserved 0
  492. VM Committed 0
  493. Locked Pages Allocated 0
  494. SM Reserved 0
  495. SM Committed 0
  496. Pages Allocated 8
  497.  
  498. (6 row(s) affected)
  499.  
  500. CACHESTORE_XMLDBELEMENT (node 0) KB
  501. ---------------------------------------- -----------
  502. VM Reserved 0
  503. VM Committed 0
  504. Locked Pages Allocated 0
  505. SM Reserved 0
  506. SM Committed 0
  507. Pages Allocated 8
  508.  
  509. (6 row(s) affected)
  510.  
  511. CACHESTORE_XMLDBATTRIBUTE (node 0) KB
  512. ---------------------------------------- -----------
  513. VM Reserved 0
  514. VM Committed 0
  515. Locked Pages Allocated 0
  516. SM Reserved 0
  517. SM Committed 0
  518. Pages Allocated 8
  519.  
  520. (6 row(s) affected)
  521.  
  522. CACHESTORE_STACKFRAMES (node 0) KB
  523. ---------------------------------------- -----------
  524. VM Reserved 0
  525. VM Committed 0
  526. Locked Pages Allocated 0
  527. SM Reserved 0
  528. SM Committed 0
  529. Pages Allocated 8
  530.  
  531. (6 row(s) affected)
  532.  
  533. CACHESTORE_STACKFRAMES (node 64) KB
  534. ---------------------------------------- -----------
  535. VM Reserved 0
  536. VM Committed 0
  537. Locked Pages Allocated 0
  538. SM Reserved 0
  539. SM Committed 0
  540. Pages Allocated 8
  541.  
  542. (6 row(s) affected)
  543.  
  544. CACHESTORE_STACKFRAMES (Total) KB
  545. ---------------------------------------- -----------
  546. VM Reserved 0
  547. VM Committed 0
  548. Locked Pages Allocated 0
  549. SM Reserved 0
  550. SM Committed 0
  551. Pages Allocated 16
  552.  
  553. (6 row(s) affected)
  554.  
  555. CACHESTORE_BROKERTBLACS (node 0) KB
  556. ---------------------------------------- -----------
  557. VM Reserved 0
  558. VM Committed 0
  559. Locked Pages Allocated 0
  560. SM Reserved 0
  561. SM Committed 0
  562. Pages Allocated 72
  563.  
  564. (6 row(s) affected)
  565.  
  566. CACHESTORE_BROKERKEK (node 0) KB
  567. ---------------------------------------- -----------
  568. VM Reserved 0
  569. VM Committed 0
  570. Locked Pages Allocated 0
  571. SM Reserved 0
  572. SM Committed 0
  573. Pages Allocated 8
  574.  
  575. (6 row(s) affected)
  576.  
  577. CACHESTORE_BROKERDSH (node 0) KB
  578. ---------------------------------------- -----------
  579. VM Reserved 0
  580. VM Committed 0
  581. Locked Pages Allocated 0
  582. SM Reserved 0
  583. SM Committed 0
  584. Pages Allocated 8
  585.  
  586. (6 row(s) affected)
  587.  
  588. CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
  589. ---------------------------------------- -----------
  590. VM Reserved 0
  591. VM Committed 0
  592. Locked Pages Allocated 0
  593. SM Reserved 0
  594. SM Committed 0
  595. Pages Allocated 8
  596.  
  597. (6 row(s) affected)
  598.  
  599. CACHESTORE_BROKERRSB (node 0) KB
  600. ---------------------------------------- -----------
  601. VM Reserved 0
  602. VM Committed 0
  603. Locked Pages Allocated 0
  604. SM Reserved 0
  605. SM Committed 0
  606. Pages Allocated 8
  607.  
  608. (6 row(s) affected)
  609.  
  610. CACHESTORE_BROKERREADONLY (node 0) KB
  611. ---------------------------------------- -----------
  612. VM Reserved 0
  613. VM Committed 0
  614. Locked Pages Allocated 0
  615. SM Reserved 0
  616. SM Committed 0
  617. Pages Allocated 32
  618.  
  619. (6 row(s) affected)
  620.  
  621. CACHESTORE_BROKERTO (node 0) KB
  622. ---------------------------------------- -----------
  623. VM Reserved 0
  624. VM Committed 0
  625. Locked Pages Allocated 0
  626. SM Reserved 0
  627. SM Committed 0
  628. Pages Allocated 8
  629.  
  630. (6 row(s) affected)
  631.  
  632. CACHESTORE_EVENTS (node 0) KB
  633. ---------------------------------------- -----------
  634. VM Reserved 0
  635. VM Committed 0
  636. Locked Pages Allocated 0
  637. SM Reserved 0
  638. SM Committed 0
  639. Pages Allocated 16
  640.  
  641. (6 row(s) affected)
  642.  
  643. CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
  644. ----------------------------------------- -----------
  645. VM Reserved 0
  646. VM Committed 0
  647. Locked Pages Allocated 0
  648. SM Reserved 0
  649. SM Committed 0
  650. Pages Allocated 424
  651.  
  652. (6 row(s) affected)
  653.  
  654. CACHESTORE_SYSTEMROWSET (node 0) KB
  655. ---------------------------------------- -----------
  656. VM Reserved 0
  657. VM Committed 0
  658. Locked Pages Allocated 0
  659. SM Reserved 0
  660. SM Committed 0
  661. Pages Allocated 3056
  662.  
  663. (6 row(s) affected)
  664.  
  665. CACHESTORE_CONVPRI (node 0) KB
  666. ---------------------------------------- -----------
  667. VM Reserved 0
  668. VM Committed 0
  669. Locked Pages Allocated 0
  670. SM Reserved 0
  671. SM Committed 0
  672. Pages Allocated 96
  673.  
  674. (6 row(s) affected)
  675.  
  676. CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
  677. ---------------------------------------- -----------
  678. VM Reserved 0
  679. VM Committed 0
  680. Locked Pages Allocated 0
  681. SM Reserved 0
  682. SM Committed 0
  683. Pages Allocated 32
  684.  
  685. (6 row(s) affected)
  686.  
  687. CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
  688. ---------------------------------------- -----------
  689. VM Reserved 0
  690. VM Committed 0
  691. Locked Pages Allocated 0
  692. SM Reserved 0
  693. SM Committed 0
  694. Pages Allocated 16
  695.  
  696. (6 row(s) affected)
  697.  
  698. CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
  699. ----------------------------------------- -----------
  700. VM Reserved 0
  701. VM Committed 0
  702. Locked Pages Allocated 0
  703. SM Reserved 0
  704. SM Committed 0
  705. Pages Allocated 16
  706.  
  707. (6 row(s) affected)
  708.  
  709. CACHESTORE_XML_SELECTIVE_DG (node 0) KB
  710. ---------------------------------------- -----------
  711. VM Reserved 0
  712. VM Committed 0
  713. Locked Pages Allocated 0
  714. SM Reserved 0
  715. SM Committed 0
  716. Pages Allocated 8
  717.  
  718. (6 row(s) affected)
  719.  
  720. USERSTORE_SCHEMAMGR (node 0) KB
  721. ---------------------------------------- -----------
  722. VM Reserved 0
  723. VM Committed 0
  724. Locked Pages Allocated 0
  725. SM Reserved 0
  726. SM Committed 0
  727. Pages Allocated 8736
  728.  
  729. (6 row(s) affected)
  730.  
  731. USERSTORE_DBMETADATA (node 0) KB
  732. ---------------------------------------- -----------
  733. VM Reserved 0
  734. VM Committed 0
  735. Locked Pages Allocated 0
  736. SM Reserved 0
  737. SM Committed 0
  738. Pages Allocated 11736
  739.  
  740. (6 row(s) affected)
  741.  
  742. USERSTORE_TOKENPERM (node 0) KB
  743. ---------------------------------------- -----------
  744. VM Reserved 0
  745. VM Committed 0
  746. Locked Pages Allocated 0
  747. SM Reserved 0
  748. SM Committed 0
  749. Pages Allocated 9272
  750.  
  751. (6 row(s) affected)
  752.  
  753. USERSTORE_OBJPERM (node 0) KB
  754. ---------------------------------------- -----------
  755. VM Reserved 0
  756. VM Committed 0
  757. Locked Pages Allocated 0
  758. SM Reserved 0
  759. SM Committed 0
  760. Pages Allocated 1960
  761.  
  762. (6 row(s) affected)
  763.  
  764. USERSTORE_SXC (node 0) KB
  765. ---------------------------------------- -----------
  766. VM Reserved 0
  767. VM Committed 0
  768. Locked Pages Allocated 0
  769. SM Reserved 0
  770. SM Committed 0
  771. Pages Allocated 568
  772.  
  773. (6 row(s) affected)
  774.  
  775. USERSTORE_SXC (node 64) KB
  776. ---------------------------------------- -----------
  777. VM Reserved 0
  778. VM Committed 0
  779. Locked Pages Allocated 0
  780. SM Reserved 0
  781. SM Committed 0
  782. Pages Allocated 8
  783.  
  784. (6 row(s) affected)
  785.  
  786. USERSTORE_SXC (Total) KB
  787. ---------------------------------------- -----------
  788. VM Reserved 0
  789. VM Committed 0
  790. Locked Pages Allocated 0
  791. SM Reserved 0
  792. SM Committed 0
  793. Pages Allocated 576
  794.  
  795. (6 row(s) affected)
  796.  
  797. OBJECTSTORE_LBSS (node 0) KB
  798. ---------------------------------------- -----------
  799. VM Reserved 0
  800. VM Committed 0
  801. Locked Pages Allocated 0
  802. SM Reserved 0
  803. SM Committed 0
  804. Pages Allocated 256
  805.  
  806. (6 row(s) affected)
  807.  
  808. OBJECTSTORE_SNI_PACKET (node 0) KB
  809. ---------------------------------------- -----------
  810. VM Reserved 0
  811. VM Committed 0
  812. Locked Pages Allocated 0
  813. SM Reserved 0
  814. SM Committed 0
  815. Pages Allocated 11592
  816.  
  817. (6 row(s) affected)
  818.  
  819. OBJECTSTORE_SNI_PACKET (node 64) KB
  820. ---------------------------------------- -----------
  821. VM Reserved 0
  822. VM Committed 0
  823. Locked Pages Allocated 0
  824. SM Reserved 0
  825. SM Committed 0
  826. Pages Allocated 56
  827.  
  828. (6 row(s) affected)
  829.  
  830. OBJECTSTORE_SNI_PACKET (Total) KB
  831. ---------------------------------------- -----------
  832. VM Reserved 0
  833. VM Committed 0
  834. Locked Pages Allocated 0
  835. SM Reserved 0
  836. SM Committed 0
  837. Pages Allocated 11648
  838.  
  839. (6 row(s) affected)
  840.  
  841. OBJECTSTORE_SERVICE_BROKER (node 0) KB
  842. ---------------------------------------- -----------
  843. VM Reserved 0
  844. VM Committed 0
  845. Locked Pages Allocated 0
  846. SM Reserved 0
  847. SM Committed 0
  848. Pages Allocated 504
  849.  
  850. (6 row(s) affected)
  851.  
  852. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  853. ---------------------------------------- -----------
  854. VM Reserved 65536
  855. VM Committed 65536
  856. Locked Pages Allocated 0
  857. SM Reserved 0
  858. SM Committed 0
  859. Pages Allocated 3232
  860.  
  861. (6 row(s) affected)
  862.  
  863. OBJECTSTORE_LOCK_MANAGER (node 64) KB
  864. ---------------------------------------- -----------
  865. VM Reserved 0
  866. VM Committed 0
  867. Locked Pages Allocated 0
  868. SM Reserved 0
  869. SM Committed 0
  870. Pages Allocated 24
  871.  
  872. (6 row(s) affected)
  873.  
  874. OBJECTSTORE_LOCK_MANAGER (Total) KB
  875. ---------------------------------------- -----------
  876. VM Reserved 65536
  877. VM Committed 65536
  878. Locked Pages Allocated 0
  879. SM Reserved 0
  880. SM Committed 0
  881. Pages Allocated 3256
  882.  
  883. (6 row(s) affected)
  884.  
  885. OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
  886. ------------------------------------------ -----------
  887. VM Reserved 0
  888. VM Committed 0
  889. Locked Pages Allocated 0
  890. SM Reserved 0
  891. SM Committed 0
  892. Pages Allocated 16
  893.  
  894. (6 row(s) affected)
  895.  
  896. OBJECTSTORE_XACT_CACHE (node 0) KB
  897. ---------------------------------------- -----------
  898. VM Reserved 0
  899. VM Committed 0
  900. Locked Pages Allocated 0
  901. SM Reserved 0
  902. SM Committed 0
  903. Pages Allocated 144
  904.  
  905. (6 row(s) affected)
  906.  
  907. OBJECTSTORE_XACT_CACHE (node 64) KB
  908. ---------------------------------------- -----------
  909. VM Reserved 0
  910. VM Committed 0
  911. Locked Pages Allocated 0
  912. SM Reserved 0
  913. SM Committed 0
  914. Pages Allocated 16
  915.  
  916. (6 row(s) affected)
  917.  
  918. OBJECTSTORE_XACT_CACHE (Total) KB
  919. ---------------------------------------- -----------
  920. VM Reserved 0
  921. VM Committed 0
  922. Locked Pages Allocated 0
  923. SM Reserved 0
  924. SM Committed 0
  925. Pages Allocated 160
  926.  
  927. (6 row(s) affected)
  928.  
  929. Buffer Pool Value
  930. ---------------------------------------- -----------
  931. Database 76594
  932. Simulated 13178
  933. Target 49119232
  934. Dirty 9995
  935. In IO 0
  936. Latched 0
  937. Page Life Expectancy 155932
  938.  
  939. (7 row(s) affected)
  940.  
  941. Procedure Cache Value
  942. ---------------------------------------- -----------
  943. TotalProcs 1554
  944. TotalPages 29402
  945. InUsePages 15
  946.  
  947. (3 row(s) affected)
  948.  
  949. Global Memory Objects Pages
  950. ---------------------------------------- -----------
  951. Resource 399
  952. Locks 407
  953. XDES 114
  954. DirtyPageTracking 2
  955. SETLS 2
  956. SubpDesc Allocators 2
  957. SE SchemaManager 507
  958. SE Column Metadata Cache 584
  959. SE Column Metadata Cache Store 21
  960. SQLCache 279
  961. Replication 2
  962. ServerGlobal 52
  963. XP Global 2
  964. SortTables 3
  965.  
  966. (14 row(s) affected)
  967.  
  968. Query Memory Objects (internal) Value
  969. ---------------------------------------- -----------
  970. Grants 0
  971. Waiting 0
  972. Available 1981964
  973. Current Max 1981964
  974. Future Max 1981964
  975. Physical Max 1981964
  976. Next Request 0
  977. Waiting For 0
  978. Cost 0
  979. Timeout 0
  980. Wait Time 0
  981.  
  982. (11 row(s) affected)
  983.  
  984. Small Query Memory Objects (internal) Value
  985. ---------------------------------------- -----------
  986. Grants 0
  987. Waiting 0
  988. Available 65536
  989. Current Max 65536
  990. Future Max 65536
  991.  
  992. (5 row(s) affected)
  993.  
  994. Remote Query Memory Objects (internal) Value
  995. ---------------------------------------- -----------
  996. Grants 0
  997. Waiting 0
  998. Available 990982
  999. Current Max 990982
  1000.  
  1001. (4 row(s) affected)
  1002.  
  1003. Optimization Queue (internal) Value
  1004. ---------------------------------------- --------------------
  1005. Overall Memory 17891328000
  1006. Target Memory 17423613952
  1007. Last Notification 1
  1008. Timeout 6
  1009. Early Termination Factor 5
  1010.  
  1011. (5 row(s) affected)
  1012.  
  1013. Small Gateway (internal) Value
  1014. ---------------------------------------- -----------
  1015. Configured Units 8
  1016. Available Units 8
  1017. Acquires 0
  1018. Waiters 0
  1019. Threshold Factor 380000
  1020. Threshold 380000
  1021.  
  1022. (6 row(s) affected)
  1023.  
  1024. Medium Gateway (internal) Value
  1025. ---------------------------------------- -----------
  1026. Configured Units 2
  1027. Available Units 2
  1028. Acquires 0
  1029. Waiters 0
  1030. Threshold Factor 12
  1031. Threshold -1
  1032.  
  1033. (6 row(s) affected)
  1034.  
  1035. Big Gateway (internal) Value
  1036. ---------------------------------------- -----------
  1037. Configured Units 1
  1038. Available Units 1
  1039. Acquires 0
  1040. Waiters 0
  1041. Threshold Factor 8
  1042. Threshold -1
  1043.  
  1044. (6 row(s) affected)
  1045.  
  1046. Memory Pool Manager Pages
  1047. ---------------------------------------- -----------
  1048. Reserved Current 0
  1049. Reserved Limit 2608277
  1050.  
  1051. (2 row(s) affected)
  1052.  
  1053. Memory Pool (internal) Pages
  1054. ---------------------------------------- -----------
  1055. Allocations 79723
  1056. Predicted 575215
  1057. Private Target 0
  1058. Private Limit 0
  1059. Total Target 2688000
  1060. Total Limit 2688000
  1061. OOM Count 0
  1062.  
  1063. (7 row(s) affected)
  1064.  
  1065. MEMORYBROKER_FOR_CACHE (internal) Pages
  1066. ---------------------------------------- -----------
  1067. Allocations 36445
  1068. Rate 1
  1069. Target Allocations 2149231
  1070. Future Allocations 0
  1071. Overall 2184000
  1072. Last Notification 1
  1073.  
  1074. (6 row(s) affected)
  1075.  
  1076. MEMORYBROKER_FOR_STEAL (internal) Pages
  1077. ---------------------------------------- -----------
  1078. Allocations 14121
  1079. Rate 0
  1080. Target Allocations 2126906
  1081. Future Allocations 0
  1082. Overall 2184000
  1083. Last Notification 1
  1084.  
  1085. (6 row(s) affected)
  1086.  
  1087. MEMORYBROKER_FOR_RESERVE (internal) Pages
  1088. ---------------------------------------- -----------
  1089. Allocations 0
  1090. Rate 0
  1091. Target Allocations 2184000
  1092. Future Allocations 495491
  1093. Overall 2184000
  1094. Last Notification 1
  1095.  
  1096. (6 row(s) affected)
  1097.  
  1098. MEMORYBROKER_FOR_COMMITTED (internal) Pages
  1099. ---------------------------------------- -----------
  1100. Allocations 29155
  1101. Rate 0
  1102. Target Allocations 2141940
  1103. Future Allocations 0
  1104. Overall 2184000
  1105. Last Notification 1
  1106.  
  1107. (6 row(s) affected)
  1108.  
  1109. MEMORYBROKER_FOR_XTP (internal) Pages
  1110. ---------------------------------------- -----------
  1111. Allocations 2
  1112. Rate 0
  1113. Target Allocations 2112787
  1114. Future Allocations 0
  1115. Overall 2184000
  1116. Last Notification 1
  1117.  
  1118. (6 row(s) affected)
  1119.  
  1120. Memory Broker Clerk (Buffer Pool) Pages
  1121. ---------------------------------------- ----------------------
  1122. Total 76594
  1123. Simulated 13178
  1124. Simulation Benefit 0
  1125. Internal Benefit 0
  1126. External Benefit 0
  1127. Value Of Memory 0
  1128. Periodic Freed 0
  1129. Internal Freed 0
  1130.  
  1131. (8 row(s) affected)
  1132.  
  1133. 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!