Advertisement
Guest User

Updated DBCC

a guest
Nov 3rd, 2014
325
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Process/System Counts Value
  2. ---------------------------------------- --------------------
  3. Available Physical Memory 59720187904
  4. Available Virtual Memory 8598251843584
  5. Available Paging File 86066405376
  6. Working Set 134914818048
  7. Percent of Committed Memory in WS 100
  8. Page Faults 34814614
  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 77616648
  19. VM Committed 17173516
  20. Locked Pages Allocated 0
  21. Large Pages Allocated 0
  22. Emergency Memory 1024
  23. Emergency Memory In Use 16
  24. Target Committed 65536008
  25. Current Committed 17173520
  26. Pages Allocated 8169152
  27. Pages Reserved 0
  28. Pages Free 7970344
  29. Pages In Use 2834752
  30. Page Alloc Potential 59424448
  31. NUMA Growth Phase 0
  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 77549384
  40. VM Committed 13953412
  41. Locked Pages Allocated 0
  42. Pages Allocated 5110728
  43. Pages Free 7932848
  44. Target Committed 32767992
  45. Current Committed 13953416
  46. Foreign Committed 71672
  47. Away Committed 0
  48. Taken Away Committed 7900640
  49.  
  50. (10 row(s) affected)
  51.  
  52. Memory node Id = 1 KB
  53. ---------------------------------------- -----------
  54. VM Reserved 67200
  55. VM Committed 3220084
  56. Locked Pages Allocated 0
  57. Pages Allocated 3058424
  58. Pages Free 37496
  59. Target Committed 32767992
  60. Current Committed 3220088
  61. Foreign Committed 0
  62. Away Committed 7900640
  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 29664
  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 2184
  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 31848
  105.  
  106. (6 row(s) affected)
  107.  
  108. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  109. ---------------------------------------- -----------
  110. VM Reserved 5111696
  111. VM Committed 414112
  112. Locked Pages Allocated 0
  113. SM Reserved 0
  114. SM Committed 0
  115. Pages Allocated 3997384
  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 2371000
  127.  
  128. (6 row(s) affected)
  129.  
  130. MEMORYCLERK_SQLBUFFERPOOL (Total) KB
  131. ---------------------------------------- -----------
  132. VM Reserved 5111696
  133. VM Committed 414112
  134. Locked Pages Allocated 0
  135. SM Reserved 0
  136. SM Committed 0
  137. Pages Allocated 6368384
  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 2048
  149.  
  150. (6 row(s) affected)
  151.  
  152. MEMORYCLERK_SQLOPTIMIZER (node 0) 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 1824
  160.  
  161. (6 row(s) affected)
  162.  
  163. MEMORYCLERK_SQLUTILITIES (node 0) 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 720
  171.  
  172. (6 row(s) affected)
  173.  
  174. MEMORYCLERK_SQLSTORENG (node 0) KB
  175. ---------------------------------------- -----------
  176. VM Reserved 12096
  177. VM Committed 12096
  178. Locked Pages Allocated 0
  179. SM Reserved 0
  180. SM Committed 0
  181. Pages Allocated 35976
  182.  
  183. (6 row(s) affected)
  184.  
  185. MEMORYCLERK_SQLSTORENG (node 1) 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 14320
  193.  
  194. (6 row(s) affected)
  195.  
  196. MEMORYCLERK_SQLSTORENG (Total) KB
  197. ---------------------------------------- -----------
  198. VM Reserved 12096
  199. VM Committed 12096
  200. Locked Pages Allocated 0
  201. SM Reserved 0
  202. SM Committed 0
  203. Pages Allocated 50296
  204.  
  205. (6 row(s) affected)
  206.  
  207. MEMORYCLERK_SQLCONNECTIONPOOL (node 0) 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 6608
  215.  
  216. (6 row(s) affected)
  217.  
  218. MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
  219. ---------------------------------------- -----------
  220. VM Reserved 0
  221. VM Committed 0
  222. Locked Pages Allocated 0
  223. SM Reserved 0
  224. SM Committed 0
  225. Pages Allocated 6136
  226.  
  227. (6 row(s) affected)
  228.  
  229. MEMORYCLERK_SQLCONNECTIONPOOL (Total) 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 12744
  237.  
  238. (6 row(s) affected)
  239.  
  240. MEMORYCLERK_SQLCLR (node 0) KB
  241. ---------------------------------------- -----------
  242. VM Reserved 6301440
  243. VM Committed 7400
  244. Locked Pages Allocated 0
  245. SM Reserved 0
  246. SM Committed 0
  247. Pages Allocated 40688
  248.  
  249. (6 row(s) affected)
  250.  
  251. MEMORYCLERK_SQLSERVICEBROKER (node 0) 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 2208
  259.  
  260. (6 row(s) affected)
  261.  
  262. MEMORYCLERK_SQLSERVICEBROKER (node 1) KB
  263. ---------------------------------------- -----------
  264. VM Reserved 0
  265. VM Committed 0
  266. Locked Pages Allocated 0
  267. SM Reserved 0
  268. SM Committed 0
  269. Pages Allocated 16
  270.  
  271. (6 row(s) affected)
  272.  
  273. MEMORYCLERK_SQLSERVICEBROKER (Total) KB
  274. ---------------------------------------- -----------
  275. VM Reserved 0
  276. VM Committed 0
  277. Locked Pages Allocated 0
  278. SM Reserved 0
  279. SM Committed 0
  280. Pages Allocated 2224
  281.  
  282. (6 row(s) affected)
  283.  
  284. MEMORYCLERK_SQLHTTP (node 1) 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 8
  292.  
  293. (6 row(s) affected)
  294.  
  295. MEMORYCLERK_SNI (node 0) 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 288
  303.  
  304. (6 row(s) affected)
  305.  
  306. MEMORYCLERK_SNI (node 1) 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 304
  314.  
  315. (6 row(s) affected)
  316.  
  317. MEMORYCLERK_SNI (node 64) 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 16
  325.  
  326. (6 row(s) affected)
  327.  
  328. MEMORYCLERK_SNI (Total) 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 608
  336.  
  337. (6 row(s) affected)
  338.  
  339. MEMORYCLERK_FULLTEXT (node 0) 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 296
  347.  
  348. (6 row(s) affected)
  349.  
  350. MEMORYCLERK_SQLXP (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 16
  358.  
  359. (6 row(s) affected)
  360.  
  361. MEMORYCLERK_BHF (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 64
  369.  
  370. (6 row(s) affected)
  371.  
  372. MEMORYCLERK_BHF (node 1) 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 96
  380.  
  381. (6 row(s) affected)
  382.  
  383. MEMORYCLERK_BHF (Total) 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_XE_BUFFER (node 0) KB
  395. ---------------------------------------- -----------
  396. VM Reserved 134400
  397. VM Committed 134400
  398. Locked Pages Allocated 0
  399. SM Reserved 0
  400. SM Committed 0
  401. Pages Allocated 0
  402.  
  403. (6 row(s) affected)
  404.  
  405. MEMORYCLERK_XE_BUFFER (node 1) KB
  406. ---------------------------------------- -----------
  407. VM Reserved 67200
  408. VM Committed 67200
  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 (Total) KB
  417. ---------------------------------------- -----------
  418. VM Reserved 201600
  419. VM Committed 201600
  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_XTP (node 0) KB
  428. ---------------------------------------- -----------
  429. VM Reserved 0
  430. VM Committed 0
  431. Locked Pages Allocated 0
  432. SM Reserved 0
  433. SM Committed 0
  434. Pages Allocated 16
  435.  
  436. (6 row(s) affected)
  437.  
  438. MEMORYCLERK_HOST (node 1) 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 152
  446.  
  447. (6 row(s) affected)
  448.  
  449. MEMORYCLERK_SOSNODE (node 0) 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 52504
  457.  
  458. (6 row(s) affected)
  459.  
  460. MEMORYCLERK_SOSNODE (node 1) 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 23968
  468.  
  469. (6 row(s) affected)
  470.  
  471. MEMORYCLERK_SOSNODE (node 64) 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 2488
  479.  
  480. (6 row(s) affected)
  481.  
  482. MEMORYCLERK_SOSNODE (Total) 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 78960
  490.  
  491. (6 row(s) affected)
  492.  
  493. MEMORYCLERK_SOSOS (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 192
  501.  
  502. (6 row(s) affected)
  503.  
  504. MEMORYCLERK_SOSMEMMANAGER (node 0) KB
  505. ---------------------------------------- -----------
  506. VM Reserved 126504
  507. VM Committed 126304
  508. Locked Pages Allocated 0
  509. SM Reserved 0
  510. SM Committed 0
  511. Pages Allocated 0
  512.  
  513. (6 row(s) affected)
  514.  
  515. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) 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 200
  523.  
  524. (6 row(s) affected)
  525.  
  526. MEMORYCLERK_FILETABLE (node 0) 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 16
  534.  
  535. (6 row(s) affected)
  536.  
  537. MEMORYCLERK_XE (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 1296
  545.  
  546. (6 row(s) affected)
  547.  
  548. MEMORYCLERK_SQLLOGPOOL (node 0) KB
  549. ---------------------------------------- -----------
  550. VM Reserved 0
  551. VM Committed 0
  552. Locked Pages Allocated 0
  553. SM Reserved 0
  554. SM Committed 0
  555. Pages Allocated 25712
  556.  
  557. (6 row(s) affected)
  558.  
  559. MEMORYCLERK_LWC (node 0) KB
  560. ---------------------------------------- -----------
  561. VM Reserved 0
  562. VM Committed 0
  563. Locked Pages Allocated 0
  564. SM Reserved 0
  565. SM Committed 0
  566. Pages Allocated 128
  567.  
  568. (6 row(s) affected)
  569.  
  570. MEMORYCLERK_FSCHUNKER (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 56
  578.  
  579. (6 row(s) affected)
  580.  
  581. CACHESTORE_OBJCP (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 760016
  589.  
  590. (6 row(s) affected)
  591.  
  592. CACHESTORE_SQLCP (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 305288
  600.  
  601. (6 row(s) affected)
  602.  
  603. CACHESTORE_PHDR (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 203488
  611.  
  612. (6 row(s) affected)
  613.  
  614. CACHESTORE_XPROC (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 136
  622.  
  623. (6 row(s) affected)
  624.  
  625. CACHESTORE_TEMPTABLES (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 248
  633.  
  634. (6 row(s) affected)
  635.  
  636. CACHESTORE_NOTIF (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 16
  644.  
  645. (6 row(s) affected)
  646.  
  647. CACHESTORE_VIEWDEFINITIONS (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 16
  655.  
  656. (6 row(s) affected)
  657.  
  658. CACHESTORE_XMLDBTYPE (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 8
  666.  
  667. (6 row(s) affected)
  668.  
  669. CACHESTORE_XMLDBELEMENT (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 8
  677.  
  678. (6 row(s) affected)
  679.  
  680. CACHESTORE_XMLDBATTRIBUTE (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 8
  688.  
  689. (6 row(s) affected)
  690.  
  691. CACHESTORE_STACKFRAMES (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 8
  699.  
  700. (6 row(s) affected)
  701.  
  702. CACHESTORE_STACKFRAMES (node 1) 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 8
  710.  
  711. (6 row(s) affected)
  712.  
  713. CACHESTORE_STACKFRAMES (node 64) 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_STACKFRAMES (Total) 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 24
  732.  
  733. (6 row(s) affected)
  734.  
  735. CACHESTORE_BROKERTBLACS (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 1992
  743.  
  744. (6 row(s) affected)
  745.  
  746. CACHESTORE_BROKERTBLACS (node 1) 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 752
  754.  
  755. (6 row(s) affected)
  756.  
  757. CACHESTORE_BROKERTBLACS (Total) 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 2744
  765.  
  766. (6 row(s) affected)
  767.  
  768. CACHESTORE_BROKERKEK (node 0) 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_BROKERDSH (node 0) 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 8
  787.  
  788. (6 row(s) affected)
  789.  
  790. CACHESTORE_BROKERUSERCERTLOOKUP (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 8
  798.  
  799. (6 row(s) affected)
  800.  
  801. CACHESTORE_BROKERRSB (node 0) 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 8
  809.  
  810. (6 row(s) affected)
  811.  
  812. CACHESTORE_BROKERREADONLY (node 0) 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 32
  820.  
  821. (6 row(s) affected)
  822.  
  823. CACHESTORE_BROKERTO (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_EVENTS (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 16
  842.  
  843. (6 row(s) affected)
  844.  
  845. CACHESTORE_SEHOBTCOLUMNATTRIBUTE (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 2944
  853.  
  854. (6 row(s) affected)
  855.  
  856. CACHESTORE_SYSTEMROWSET (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 16784
  864.  
  865. (6 row(s) affected)
  866.  
  867. CACHESTORE_SYSTEMROWSET (node 1) 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 1232
  875.  
  876. (6 row(s) affected)
  877.  
  878. CACHESTORE_SYSTEMROWSET (Total) 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 18016
  886.  
  887. (6 row(s) affected)
  888.  
  889. CACHESTORE_CONVPRI (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 1168
  897.  
  898. (6 row(s) affected)
  899.  
  900. CACHESTORE_CONVPRI (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 16
  908.  
  909. (6 row(s) affected)
  910.  
  911. CACHESTORE_CONVPRI (Total) 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 1184
  919.  
  920. (6 row(s) affected)
  921.  
  922. CACHESTORE_FULLTEXTSTOPLIST (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 32
  930.  
  931. (6 row(s) affected)
  932.  
  933. CACHESTORE_SEARCHPROPERTYLIST (node 0) 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 16
  941.  
  942. (6 row(s) affected)
  943.  
  944. CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) 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 128
  952.  
  953. (6 row(s) affected)
  954.  
  955. CACHESTORE_XML_SELECTIVE_DG (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 8
  963.  
  964. (6 row(s) affected)
  965.  
  966. USERSTORE_SCHEMAMGR (node 0) 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 149192
  974.  
  975. (6 row(s) affected)
  976.  
  977. USERSTORE_DBMETADATA (node 0) 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 44840
  985.  
  986. (6 row(s) affected)
  987.  
  988. USERSTORE_DBMETADATA (node 1) 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 5496
  996.  
  997. (6 row(s) affected)
  998.  
  999. USERSTORE_DBMETADATA (Total) 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 50336
  1007.  
  1008. (6 row(s) affected)
  1009.  
  1010. USERSTORE_TOKENPERM (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 4304
  1018.  
  1019. (6 row(s) affected)
  1020.  
  1021. USERSTORE_TOKENPERM (node 1) 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 2376
  1029.  
  1030. (6 row(s) affected)
  1031.  
  1032. USERSTORE_TOKENPERM (Total) 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 6680
  1040.  
  1041. (6 row(s) affected)
  1042.  
  1043. USERSTORE_OBJPERM (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 11024
  1051.  
  1052. (6 row(s) affected)
  1053.  
  1054. USERSTORE_OBJPERM (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 544
  1062.  
  1063. (6 row(s) affected)
  1064.  
  1065. USERSTORE_OBJPERM (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 11568
  1073.  
  1074. (6 row(s) affected)
  1075.  
  1076. USERSTORE_SXC (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 2064
  1084.  
  1085. (6 row(s) affected)
  1086.  
  1087. USERSTORE_SXC (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 2112
  1095.  
  1096. (6 row(s) affected)
  1097.  
  1098. USERSTORE_SXC (node 64) 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 8
  1106.  
  1107. (6 row(s) affected)
  1108.  
  1109. USERSTORE_SXC (Total) 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 4184
  1117.  
  1118. (6 row(s) affected)
  1119.  
  1120. OBJECTSTORE_LBSS (node 0) 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 1080
  1128.  
  1129. (6 row(s) affected)
  1130.  
  1131. OBJECTSTORE_LBSS (node 1) 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 1072
  1139.  
  1140. (6 row(s) affected)
  1141.  
  1142. OBJECTSTORE_LBSS (Total) 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 2152
  1150.  
  1151. (6 row(s) affected)
  1152.  
  1153. OBJECTSTORE_SNI_PACKET (node 0) 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 7256
  1161.  
  1162. (6 row(s) affected)
  1163.  
  1164. OBJECTSTORE_SNI_PACKET (node 1) 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 7512
  1172.  
  1173. (6 row(s) affected)
  1174.  
  1175. OBJECTSTORE_SNI_PACKET (node 64) 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 56
  1183.  
  1184. (6 row(s) affected)
  1185.  
  1186. OBJECTSTORE_SNI_PACKET (Total) 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 14824
  1194.  
  1195. (6 row(s) affected)
  1196.  
  1197. OBJECTSTORE_SERVICE_BROKER (node 0) 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 368
  1205.  
  1206. (6 row(s) affected)
  1207.  
  1208. OBJECTSTORE_SERVICE_BROKER (node 1) 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 128
  1216.  
  1217. (6 row(s) affected)
  1218.  
  1219. OBJECTSTORE_SERVICE_BROKER (Total) 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 496
  1227.  
  1228. (6 row(s) affected)
  1229.  
  1230. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  1231. ---------------------------------------- -----------
  1232. VM Reserved 262144
  1233. VM Committed 262144
  1234. Locked Pages Allocated 0
  1235. SM Reserved 0
  1236. SM Committed 0
  1237. Pages Allocated 4168
  1238.  
  1239. (6 row(s) affected)
  1240.  
  1241. OBJECTSTORE_LOCK_MANAGER (node 1) 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 7832
  1249.  
  1250. (6 row(s) affected)
  1251.  
  1252. OBJECTSTORE_LOCK_MANAGER (node 64) 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 24
  1260.  
  1261. (6 row(s) affected)
  1262.  
  1263. OBJECTSTORE_LOCK_MANAGER (Total) KB
  1264. ---------------------------------------- -----------
  1265. VM Reserved 262144
  1266. VM Committed 262144
  1267. Locked Pages Allocated 0
  1268. SM Reserved 0
  1269. SM Committed 0
  1270. Pages Allocated 12024
  1271.  
  1272. (6 row(s) affected)
  1273.  
  1274. OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
  1275. ------------------------------------------ -----------
  1276. VM Reserved 0
  1277. VM Committed 0
  1278. Locked Pages Allocated 0
  1279. SM Reserved 0
  1280. SM Committed 0
  1281. Pages Allocated 16
  1282.  
  1283. (6 row(s) affected)
  1284.  
  1285. OBJECTSTORE_XACT_CACHE (node 0) 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 336
  1293.  
  1294. (6 row(s) affected)
  1295.  
  1296. OBJECTSTORE_XACT_CACHE (node 1) 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 200
  1304.  
  1305. (6 row(s) affected)
  1306.  
  1307. OBJECTSTORE_XACT_CACHE (node 64) KB
  1308. ---------------------------------------- -----------
  1309. VM Reserved 0
  1310. VM Committed 0
  1311. Locked Pages Allocated 0
  1312. SM Reserved 0
  1313. SM Committed 0
  1314. Pages Allocated 16
  1315.  
  1316. (6 row(s) affected)
  1317.  
  1318. OBJECTSTORE_XACT_CACHE (Total) 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 552
  1326.  
  1327. (6 row(s) affected)
  1328.  
  1329. Buffer Pool Value
  1330. ---------------------------------------- -----------
  1331. Database 796037
  1332. Simulated 0
  1333. Target 8388608
  1334. Dirty 89324
  1335. In IO 0
  1336. Latched 0
  1337. Page Life Expectancy 8676
  1338.  
  1339. (7 row(s) affected)
  1340.  
  1341. Procedure Cache Value
  1342. ---------------------------------------- -----------
  1343. TotalProcs 4849
  1344. TotalPages 158616
  1345. InUsePages 72
  1346.  
  1347. (3 row(s) affected)
  1348.  
  1349. Global Memory Objects Pages
  1350. ---------------------------------------- -----------
  1351. Resource 801
  1352. Locks 1503
  1353. XDES 598
  1354. DirtyPageTracking 16
  1355. SETLS 16
  1356. SubpDesc Allocators 16
  1357. SE SchemaManager 3242
  1358. SE Column Metadata Cache 15406
  1359. SE Column Metadata Cache Store 22
  1360. SQLCache 685
  1361. Replication 2
  1362. ServerGlobal 54
  1363. XP Global 2
  1364. SortTables 3
  1365.  
  1366. (14 row(s) affected)
  1367.  
  1368. Query Memory Objects (internal) Value
  1369. ---------------------------------------- -----------
  1370. Grants 0
  1371. Waiting 0
  1372. Available 6149888
  1373. Current Max 6149888
  1374. Future Max 6149888
  1375. Physical Max 6149888
  1376. Next Request 0
  1377. Waiting For 0
  1378. Cost 0
  1379. Timeout 0
  1380. Wait Time 0
  1381.  
  1382. (11 row(s) affected)
  1383.  
  1384. Small Query Memory Objects (internal) Value
  1385. ---------------------------------------- -----------
  1386. Grants 0
  1387. Waiting 0
  1388. Available 90112
  1389. Current Max 90112
  1390. Future Max 90112
  1391.  
  1392. (5 row(s) affected)
  1393.  
  1394. Remote Query Memory Objects (internal) Value
  1395. ---------------------------------------- -----------
  1396. Grants 0
  1397. Waiting 0
  1398. Available 3074944
  1399. Current Max 3074944
  1400.  
  1401. (4 row(s) affected)
  1402.  
  1403. Optimization Queue (internal) Value
  1404. ---------------------------------------- --------------------
  1405. Overall Memory 54525952000
  1406. Target Memory 51845120000
  1407. Last Notification 1
  1408. Timeout 6
  1409. Early Termination Factor 5
  1410.  
  1411. (5 row(s) affected)
  1412.  
  1413. Small Gateway (internal) Value
  1414. ---------------------------------------- -----------
  1415. Configured Units 64
  1416. Available Units 64
  1417. Acquires 0
  1418. Waiters 0
  1419. Threshold Factor 380000
  1420. Threshold 380000
  1421.  
  1422. (6 row(s) affected)
  1423.  
  1424. Medium Gateway (internal) Value
  1425. ---------------------------------------- -----------
  1426. Configured Units 16
  1427. Available Units 16
  1428. Acquires 0
  1429. Waiters 0
  1430. Threshold Factor 12
  1431. Threshold -1
  1432.  
  1433. (6 row(s) affected)
  1434.  
  1435. Big Gateway (internal) Value
  1436. ---------------------------------------- -----------
  1437. Configured Units 1
  1438. Available Units 1
  1439. Acquires 0
  1440. Waiters 0
  1441. Threshold Factor 8
  1442. Threshold -1
  1443.  
  1444. (6 row(s) affected)
  1445.  
  1446. Memory Pool Manager Pages
  1447. ---------------------------------------- -----------
  1448. Reserved Current 0
  1449. Reserved Limit 7838193
  1450.  
  1451. (2 row(s) affected)
  1452.  
  1453. Memory Pool (internal) Pages
  1454. ---------------------------------------- -----------
  1455. Allocations 353808
  1456. Predicted 1891283
  1457. Private Target 0
  1458. Private Limit 0
  1459. Total Target 8192001
  1460. Total Limit 8192001
  1461. OOM Count 0
  1462.  
  1463. (7 row(s) affected)
  1464.  
  1465. MEMORYBROKER_FOR_CACHE (internal) Pages
  1466. ---------------------------------------- -----------
  1467. Allocations 196521
  1468. Rate -3
  1469. Target Allocations 6497239
  1470. Future Allocations 0
  1471. Overall 6656000
  1472. Last Notification 1
  1473.  
  1474. (6 row(s) affected)
  1475.  
  1476. MEMORYBROKER_FOR_STEAL (internal) Pages
  1477. ---------------------------------------- -----------
  1478. Allocations 28032
  1479. Rate -27
  1480. Target Allocations 6328750
  1481. Future Allocations 0
  1482. Overall 6656000
  1483. Last Notification 1
  1484.  
  1485. (6 row(s) affected)
  1486.  
  1487. MEMORYBROKER_FOR_RESERVE (internal) Pages
  1488. ---------------------------------------- -----------
  1489. Allocations 0
  1490. Rate -119
  1491. Target Allocations 6656000
  1492. Future Allocations 1537472
  1493. Overall 6656000
  1494. Last Notification 1
  1495.  
  1496. (6 row(s) affected)
  1497.  
  1498. MEMORYBROKER_FOR_COMMITTED (internal) Pages
  1499. ---------------------------------------- -----------
  1500. Allocations 129253
  1501. Rate 3
  1502. Target Allocations 6429974
  1503. Future Allocations 0
  1504. Overall 6656000
  1505. Last Notification 1
  1506.  
  1507. (6 row(s) affected)
  1508.  
  1509. MEMORYBROKER_FOR_XTP (internal) Pages
  1510. ---------------------------------------- -----------
  1511. Allocations 2
  1512. Rate 0
  1513. Target Allocations 6300720
  1514. Future Allocations 0
  1515. Overall 6656000
  1516. Last Notification 1
  1517.  
  1518. (6 row(s) affected)
  1519.  
  1520. Memory Broker Clerk (Buffer Pool) Pages
  1521. ---------------------------------------- ----------------------
  1522. Total 796037
  1523. Simulated 0
  1524. Simulation Benefit 0
  1525. Internal Benefit 0
  1526. External Benefit 0
  1527. Value Of Memory 0
  1528. Periodic Freed 0
  1529. Internal Freed 0
  1530.  
  1531. (8 row(s) affected)
  1532.  
  1533. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Advertisement
RAW Paste Data Copied
Advertisement