API tools faq
paste
Advertisement
Guest User

DBCC Memorystatus

a guest
Nov 3rd, 2014
211
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.91 KB | None | 0 0
raw download clone embed print report
  1. Process/System Counts Value
  2. ---------------------------------------- --------------------
  3. Available Physical Memory 4892340224
  4. Available Virtual Memory 8489158438912
  5. Available Paging File 207907700736
  6. Working Set 184438390784
  7. Percent of Committed Memory in WS 100
  8. Page Faults 257665346
  9. System physical memory high 0
  10. System physical memory low 0
  11. Process physical memory low 1
  12. Process virtual memory low 0
  13.  
  14. (10 row(s) affected)
  15.  
  16. Memory Manager KB
  17. ---------------------------------------- -----------
  18. VM Reserved 78012736
  19. VM Committed 4477540
  20. Locked Pages Allocated 0
  21. Large Pages Allocated 0
  22. Emergency Memory 1024
  23. Emergency Memory In Use 16
  24. Target Committed 4379240
  25. Current Committed 4477544
  26. Pages Allocated 2126808
  27. Pages Reserved 564992
  28. Pages Free 95272
  29. Pages In Use 3489448
  30. Page Alloc Potential 58769752
  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 77945472
  40. VM Committed 2287916
  41. Locked Pages Allocated 0
  42. Pages Allocated 923056
  43. Pages Free 0
  44. Target Committed 2189608
  45. Current Committed 2287920
  46. Foreign Committed 92972
  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 67200
  55. VM Committed 2189604
  56. Locked Pages Allocated 0
  57. Pages Allocated 1203752
  58. Pages Free 95272
  59. Target Committed 2189608
  60. Current Committed 2189608
  61. Foreign Committed 2512
  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 18256
  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 2224
  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 20480
  105.  
  106. (6 row(s) affected)
  107.  
  108. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  109. ---------------------------------------- -----------
  110. VM Reserved 5111696
  111. VM Committed 1747576
  112. Locked Pages Allocated 0
  113. SM Reserved 0
  114. SM Committed 0
  115. Pages Allocated 638696
  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 819376
  127.  
  128. (6 row(s) affected)
  129.  
  130. MEMORYCLERK_SQLBUFFERPOOL (Total) KB
  131. ---------------------------------------- -----------
  132. VM Reserved 5111696
  133. VM Committed 1747576
  134. Locked Pages Allocated 0
  135. SM Reserved 0
  136. SM Committed 0
  137. Pages Allocated 1458072
  138.  
  139. (6 row(s) affected)
  140.  
  141. MEMORYCLERK_SQLQUERYPLAN (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 16
  149.  
  150. (6 row(s) affected)
  151.  
  152. MEMORYCLERK_SQLQUERYEXEC (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 280
  160.  
  161. (6 row(s) affected)
  162.  
  163. MEMORYCLERK_SQLQUERYEXEC (node 1) 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 88
  171.  
  172. (6 row(s) affected)
  173.  
  174. MEMORYCLERK_SQLQUERYEXEC (Total) 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 368
  182.  
  183. (6 row(s) affected)
  184.  
  185. MEMORYCLERK_SQLOPTIMIZER (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 4184
  193.  
  194. (6 row(s) affected)
  195.  
  196. MEMORYCLERK_SQLOPTIMIZER (node 1) KB
  197. ---------------------------------------- -----------
  198. VM Reserved 0
  199. VM Committed 0
  200. Locked Pages Allocated 0
  201. SM Reserved 0
  202. SM Committed 0
  203. Pages Allocated 208
  204.  
  205. (6 row(s) affected)
  206.  
  207. MEMORYCLERK_SQLOPTIMIZER (Total) 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 4392
  215.  
  216. (6 row(s) affected)
  217.  
  218. MEMORYCLERK_SQLUTILITIES (node 0) KB
  219. ---------------------------------------- -----------
  220. VM Reserved 1088
  221. VM Committed 1088
  222. Locked Pages Allocated 0
  223. SM Reserved 0
  224. SM Committed 0
  225. Pages Allocated 3320
  226.  
  227. (6 row(s) affected)
  228.  
  229. MEMORYCLERK_SQLUTILITIES (node 1) 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 168
  237.  
  238. (6 row(s) affected)
  239.  
  240. MEMORYCLERK_SQLUTILITIES (Total) KB
  241. ---------------------------------------- -----------
  242. VM Reserved 1088
  243. VM Committed 1088
  244. Locked Pages Allocated 0
  245. SM Reserved 0
  246. SM Committed 0
  247. Pages Allocated 3488
  248.  
  249. (6 row(s) affected)
  250.  
  251. MEMORYCLERK_SQLSTORENG (node 0) KB
  252. ---------------------------------------- -----------
  253. VM Reserved 25728
  254. VM Committed 25728
  255. Locked Pages Allocated 0
  256. SM Reserved 0
  257. SM Committed 0
  258. Pages Allocated 70728
  259.  
  260. (6 row(s) affected)
  261.  
  262. MEMORYCLERK_SQLSTORENG (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 16880
  270.  
  271. (6 row(s) affected)
  272.  
  273. MEMORYCLERK_SQLSTORENG (Total) KB
  274. ---------------------------------------- -----------
  275. VM Reserved 25728
  276. VM Committed 25728
  277. Locked Pages Allocated 0
  278. SM Reserved 0
  279. SM Committed 0
  280. Pages Allocated 87608
  281.  
  282. (6 row(s) affected)
  283.  
  284. MEMORYCLERK_SQLCONNECTIONPOOL (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 11264
  292.  
  293. (6 row(s) affected)
  294.  
  295. MEMORYCLERK_SQLCONNECTIONPOOL (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 11512
  303.  
  304. (6 row(s) affected)
  305.  
  306. MEMORYCLERK_SQLCONNECTIONPOOL (Total) 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 22776
  314.  
  315. (6 row(s) affected)
  316.  
  317. MEMORYCLERK_SQLCLR (node 0) KB
  318. ---------------------------------------- -----------
  319. VM Reserved 6300992
  320. VM Committed 6952
  321. Locked Pages Allocated 0
  322. SM Reserved 0
  323. SM Committed 0
  324. Pages Allocated 40688
  325.  
  326. (6 row(s) affected)
  327.  
  328. MEMORYCLERK_SQLSERVICEBROKER (node 0) 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 2208
  336.  
  337. (6 row(s) affected)
  338.  
  339. MEMORYCLERK_SQLSERVICEBROKER (node 1) 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 16
  347.  
  348. (6 row(s) affected)
  349.  
  350. MEMORYCLERK_SQLSERVICEBROKER (Total) 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 2224
  358.  
  359. (6 row(s) affected)
  360.  
  361. MEMORYCLERK_SQLHTTP (node 1) 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 8
  369.  
  370. (6 row(s) affected)
  371.  
  372. MEMORYCLERK_SNI (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 328
  380.  
  381. (6 row(s) affected)
  382.  
  383. MEMORYCLERK_SNI (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 344
  391.  
  392. (6 row(s) affected)
  393.  
  394. MEMORYCLERK_SNI (node 64) 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 16
  402.  
  403. (6 row(s) affected)
  404.  
  405. MEMORYCLERK_SNI (Total) KB
  406. ---------------------------------------- -----------
  407. VM Reserved 0
  408. VM Committed 0
  409. Locked Pages Allocated 0
  410. SM Reserved 0
  411. SM Committed 0
  412. Pages Allocated 688
  413.  
  414. (6 row(s) affected)
  415.  
  416. MEMORYCLERK_FULLTEXT (node 0) KB
  417. ---------------------------------------- -----------
  418. VM Reserved 0
  419. VM Committed 0
  420. Locked Pages Allocated 0
  421. SM Reserved 0
  422. SM Committed 0
  423. Pages Allocated 296
  424.  
  425. (6 row(s) affected)
  426.  
  427. MEMORYCLERK_SQLXP (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_BHF (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 256
  446.  
  447. (6 row(s) affected)
  448.  
  449. MEMORYCLERK_BHF (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 160
  457.  
  458. (6 row(s) affected)
  459.  
  460. MEMORYCLERK_BHF (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 416
  468.  
  469. (6 row(s) affected)
  470.  
  471. MEMORYCLERK_SQLQERESERVATIONS (node 1) 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 565016
  479.  
  480. (6 row(s) affected)
  481.  
  482. MEMORYCLERK_XE_BUFFER (node 0) KB
  483. ---------------------------------------- -----------
  484. VM Reserved 134400
  485. VM Committed 134400
  486. Locked Pages Allocated 0
  487. SM Reserved 0
  488. SM Committed 0
  489. Pages Allocated 0
  490.  
  491. (6 row(s) affected)
  492.  
  493. MEMORYCLERK_XE_BUFFER (node 1) KB
  494. ---------------------------------------- -----------
  495. VM Reserved 67200
  496. VM Committed 67200
  497. Locked Pages Allocated 0
  498. SM Reserved 0
  499. SM Committed 0
  500. Pages Allocated 0
  501.  
  502. (6 row(s) affected)
  503.  
  504. MEMORYCLERK_XE_BUFFER (Total) KB
  505. ---------------------------------------- -----------
  506. VM Reserved 201600
  507. VM Committed 201600
  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_XTP (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 16
  523.  
  524. (6 row(s) affected)
  525.  
  526. MEMORYCLERK_HOST (node 1) 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 160
  534.  
  535. (6 row(s) affected)
  536.  
  537. MEMORYCLERK_SOSNODE (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 69760
  545.  
  546. (6 row(s) affected)
  547.  
  548. MEMORYCLERK_SOSNODE (node 1) 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 35680
  556.  
  557. (6 row(s) affected)
  558.  
  559. MEMORYCLERK_SOSNODE (node 64) 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 2488
  567.  
  568. (6 row(s) affected)
  569.  
  570. MEMORYCLERK_SOSNODE (Total) 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 107928
  578.  
  579. (6 row(s) affected)
  580.  
  581. MEMORYCLERK_SOSOS (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 192
  589.  
  590. (6 row(s) affected)
  591.  
  592. MEMORYCLERK_SOSMEMMANAGER (node 0) KB
  593. ---------------------------------------- -----------
  594. VM Reserved 258464
  595. VM Committed 258056
  596. Locked Pages Allocated 0
  597. SM Reserved 0
  598. SM Committed 0
  599. Pages Allocated 0
  600.  
  601. (6 row(s) affected)
  602.  
  603. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (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 200
  611.  
  612. (6 row(s) affected)
  613.  
  614. MEMORYCLERK_FILETABLE (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 16
  622.  
  623. (6 row(s) affected)
  624.  
  625. MEMORYCLERK_XE (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 5360
  633.  
  634. (6 row(s) affected)
  635.  
  636. MEMORYCLERK_SQLLOGPOOL (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 600
  644.  
  645. (6 row(s) affected)
  646.  
  647. MEMORYCLERK_LWC (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 128
  655.  
  656. (6 row(s) affected)
  657.  
  658. MEMORYCLERK_FSCHUNKER (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 56
  666.  
  667. (6 row(s) affected)
  668.  
  669. CACHESTORE_OBJCP (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 18984
  677.  
  678. (6 row(s) affected)
  679.  
  680. CACHESTORE_SQLCP (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 29680
  688.  
  689. (6 row(s) affected)
  690.  
  691. CACHESTORE_PHDR (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 488
  699.  
  700. (6 row(s) affected)
  701.  
  702. CACHESTORE_XPROC (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 16
  710.  
  711. (6 row(s) affected)
  712.  
  713. CACHESTORE_TEMPTABLES (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 48
  721.  
  722. (6 row(s) affected)
  723.  
  724. CACHESTORE_NOTIF (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 16
  732.  
  733. (6 row(s) affected)
  734.  
  735. CACHESTORE_VIEWDEFINITIONS (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 16
  743.  
  744. (6 row(s) affected)
  745.  
  746. CACHESTORE_XMLDBTYPE (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_XMLDBELEMENT (node 0) 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_XMLDBATTRIBUTE (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_STACKFRAMES (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_STACKFRAMES (node 1) 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_STACKFRAMES (node 64) 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_STACKFRAMES (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 24
  820.  
  821. (6 row(s) affected)
  822.  
  823. CACHESTORE_BROKERTBLACS (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 520
  831.  
  832. (6 row(s) affected)
  833.  
  834. CACHESTORE_BROKERTBLACS (node 1) 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 96
  842.  
  843. (6 row(s) affected)
  844.  
  845. CACHESTORE_BROKERTBLACS (Total) 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 616
  853.  
  854. (6 row(s) affected)
  855.  
  856. CACHESTORE_BROKERKEK (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 8
  864.  
  865. (6 row(s) affected)
  866.  
  867. CACHESTORE_BROKERDSH (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 8
  875.  
  876. (6 row(s) affected)
  877.  
  878. CACHESTORE_BROKERUSERCERTLOOKUP (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_BROKERRSB (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 8
  897.  
  898. (6 row(s) affected)
  899.  
  900. CACHESTORE_BROKERREADONLY (node 0) 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 32
  908.  
  909. (6 row(s) affected)
  910.  
  911. CACHESTORE_BROKERTO (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 8
  919.  
  920. (6 row(s) affected)
  921.  
  922. CACHESTORE_EVENTS (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 16
  930.  
  931. (6 row(s) affected)
  932.  
  933. CACHESTORE_SEHOBTCOLUMNATTRIBUTE (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 5896
  941.  
  942. (6 row(s) affected)
  943.  
  944. CACHESTORE_SYSTEMROWSET (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 888
  952.  
  953. (6 row(s) affected)
  954.  
  955. CACHESTORE_SYSTEMROWSET (node 1) 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 40
  963.  
  964. (6 row(s) affected)
  965.  
  966. CACHESTORE_SYSTEMROWSET (Total) 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 928
  974.  
  975. (6 row(s) affected)
  976.  
  977. CACHESTORE_CONVPRI (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 1168
  985.  
  986. (6 row(s) affected)
  987.  
  988. CACHESTORE_CONVPRI (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 16
  996.  
  997. (6 row(s) affected)
  998.  
  999. CACHESTORE_CONVPRI (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 1184
  1007.  
  1008. (6 row(s) affected)
  1009.  
  1010. CACHESTORE_FULLTEXTSTOPLIST (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 32
  1018.  
  1019. (6 row(s) affected)
  1020.  
  1021. CACHESTORE_SEARCHPROPERTYLIST (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 16
  1029.  
  1030. (6 row(s) affected)
  1031.  
  1032. CACHESTORE_COLUMNSTOREOBJECTPOOL (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 128
  1040.  
  1041. (6 row(s) affected)
  1042.  
  1043. CACHESTORE_XML_SELECTIVE_DG (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 8
  1051.  
  1052. (6 row(s) affected)
  1053.  
  1054. USERSTORE_SCHEMAMGR (node 0) 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 210840
  1062.  
  1063. (6 row(s) affected)
  1064.  
  1065. USERSTORE_DBMETADATA (node 0) 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 4904
  1073.  
  1074. (6 row(s) affected)
  1075.  
  1076. USERSTORE_DBMETADATA (node 1) 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 144
  1084.  
  1085. (6 row(s) affected)
  1086.  
  1087. USERSTORE_DBMETADATA (Total) 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 5048
  1095.  
  1096. (6 row(s) affected)
  1097.  
  1098. USERSTORE_TOKENPERM (node 0) 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 29432
  1106.  
  1107. (6 row(s) affected)
  1108.  
  1109. USERSTORE_TOKENPERM (node 1) 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 5320
  1117.  
  1118. (6 row(s) affected)
  1119.  
  1120. USERSTORE_TOKENPERM (Total) 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 34752
  1128.  
  1129. (6 row(s) affected)
  1130.  
  1131. USERSTORE_OBJPERM (node 0) 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 11024
  1139.  
  1140. (6 row(s) affected)
  1141.  
  1142. USERSTORE_OBJPERM (node 1) 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 680
  1150.  
  1151. (6 row(s) affected)
  1152.  
  1153. USERSTORE_OBJPERM (Total) 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 11704
  1161.  
  1162. (6 row(s) affected)
  1163.  
  1164. USERSTORE_SXC (node 0) 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 2280
  1172.  
  1173. (6 row(s) affected)
  1174.  
  1175. USERSTORE_SXC (node 1) 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 2440
  1183.  
  1184. (6 row(s) affected)
  1185.  
  1186. USERSTORE_SXC (node 64) 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 8
  1194.  
  1195. (6 row(s) affected)
  1196.  
  1197. USERSTORE_SXC (Total) 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 4728
  1205.  
  1206. (6 row(s) affected)
  1207.  
  1208. OBJECTSTORE_LBSS (node 0) 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 160
  1216.  
  1217. (6 row(s) affected)
  1218.  
  1219. OBJECTSTORE_LBSS (node 1) 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 136
  1227.  
  1228. (6 row(s) affected)
  1229.  
  1230. OBJECTSTORE_LBSS (Total) 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 296
  1238.  
  1239. (6 row(s) affected)
  1240.  
  1241. OBJECTSTORE_SNI_PACKET (node 0) 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 13280
  1249.  
  1250. (6 row(s) affected)
  1251.  
  1252. OBJECTSTORE_SNI_PACKET (node 1) 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 14936
  1260.  
  1261. (6 row(s) affected)
  1262.  
  1263. OBJECTSTORE_SNI_PACKET (node 64) 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 56
  1271.  
  1272. (6 row(s) affected)
  1273.  
  1274. OBJECTSTORE_SNI_PACKET (Total) 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 28272
  1282.  
  1283. (6 row(s) affected)
  1284.  
  1285. OBJECTSTORE_SERVICE_BROKER (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 368
  1293.  
  1294. (6 row(s) affected)
  1295.  
  1296. OBJECTSTORE_SERVICE_BROKER (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 128
  1304.  
  1305. (6 row(s) affected)
  1306.  
  1307. OBJECTSTORE_SERVICE_BROKER (Total) 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 496
  1315.  
  1316. (6 row(s) affected)
  1317.  
  1318. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  1319. ---------------------------------------- -----------
  1320. VM Reserved 4096
  1321. VM Committed 4096
  1322. Locked Pages Allocated 0
  1323. SM Reserved 0
  1324. SM Committed 0
  1325. Pages Allocated 7952
  1326.  
  1327. (6 row(s) affected)
  1328.  
  1329. OBJECTSTORE_LOCK_MANAGER (node 1) 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 5320
  1337.  
  1338. (6 row(s) affected)
  1339.  
  1340. OBJECTSTORE_LOCK_MANAGER (node 64) 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 24
  1348.  
  1349. (6 row(s) affected)
  1350.  
  1351. OBJECTSTORE_LOCK_MANAGER (Total) KB
  1352. ---------------------------------------- -----------
  1353. VM Reserved 4096
  1354. VM Committed 4096
  1355. Locked Pages Allocated 0
  1356. SM Reserved 0
  1357. SM Committed 0
  1358. Pages Allocated 13296
  1359.  
  1360. (6 row(s) affected)
  1361.  
  1362. OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) 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 16
  1370.  
  1371. (6 row(s) affected)
  1372.  
  1373. OBJECTSTORE_XACT_CACHE (node 0) KB
  1374. ---------------------------------------- -----------
  1375. VM Reserved 0
  1376. VM Committed 0
  1377. Locked Pages Allocated 0
  1378. SM Reserved 0
  1379. SM Committed 0
  1380. Pages Allocated 648
  1381.  
  1382. (6 row(s) affected)
  1383.  
  1384. OBJECTSTORE_XACT_CACHE (node 1) KB
  1385. ---------------------------------------- -----------
  1386. VM Reserved 0
  1387. VM Committed 0
  1388. Locked Pages Allocated 0
  1389. SM Reserved 0
  1390. SM Committed 0
  1391. Pages Allocated 688
  1392.  
  1393. (6 row(s) affected)
  1394.  
  1395. OBJECTSTORE_XACT_CACHE (node 64) KB
  1396. ---------------------------------------- -----------
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!