Advertisement
Guest User

DBCC MEMORYSTATUS

a guest
May 14th, 2013
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.73 KB | None | 0 0
  1. Memory Manager KB
  2. ---------------------------------------- -----------
  3. VM Reserved 3184048
  4. VM Committed 578300
  5. Locked Pages Allocated 0
  6. Reserved Memory 1024
  7. Reserved Memory In Use 0
  8.  
  9. (5 row(s) affected)
  10.  
  11. Memory node Id = 0 KB
  12. ---------------------------------------- -----------
  13. VM Reserved 3182960
  14. VM Committed 577272
  15. Locked Pages Allocated 0
  16. MultiPage Allocator 23480
  17. SinglePage Allocator 39512
  18.  
  19. (5 row(s) affected)
  20.  
  21. MEMORYCLERK_SQLGENERAL (node 0) KB
  22. ---------------------------------------- -----------
  23. VM Reserved 0
  24. VM Committed 0
  25. Locked Pages Allocated 0
  26. SM Reserved 0
  27. SM Committed 0
  28. SinglePage Allocator 1168
  29. MultiPage Allocator 3864
  30.  
  31. (7 row(s) affected)
  32.  
  33. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  34. ---------------------------------------- -----------
  35. VM Reserved 3149824
  36. VM Committed 546048
  37. Locked Pages Allocated 0
  38. SM Reserved 0
  39. SM Committed 0
  40. SinglePage Allocator 0
  41. MultiPage Allocator 400
  42.  
  43. (7 row(s) affected)
  44.  
  45. MEMORYCLERK_SQLQUERYEXEC (node 0) KB
  46. ---------------------------------------- -----------
  47. VM Reserved 0
  48. VM Committed 0
  49. Locked Pages Allocated 0
  50. SM Reserved 0
  51. SM Committed 0
  52. SinglePage Allocator 16
  53. MultiPage Allocator 0
  54.  
  55. (7 row(s) affected)
  56.  
  57. MEMORYCLERK_SQLOPTIMIZER (node 0) KB
  58. ---------------------------------------- -----------
  59. VM Reserved 0
  60. VM Committed 0
  61. Locked Pages Allocated 0
  62. SM Reserved 0
  63. SM Committed 0
  64. SinglePage Allocator 96
  65. MultiPage Allocator 896
  66.  
  67. (7 row(s) affected)
  68.  
  69. MEMORYCLERK_SQLUTILITIES (node 0) KB
  70. ---------------------------------------- -----------
  71. VM Reserved 240
  72. VM Committed 240
  73. Locked Pages Allocated 0
  74. SM Reserved 0
  75. SM Committed 0
  76. SinglePage Allocator 96
  77. MultiPage Allocator 0
  78.  
  79. (7 row(s) affected)
  80.  
  81. MEMORYCLERK_SQLSTORENG (node 0) KB
  82. ---------------------------------------- -----------
  83. VM Reserved 768
  84. VM Committed 768
  85. Locked Pages Allocated 0
  86. SM Reserved 0
  87. SM Committed 0
  88. SinglePage Allocator 896
  89. MultiPage Allocator 3976
  90.  
  91. (7 row(s) affected)
  92.  
  93. MEMORYCLERK_SQLCONNECTIONPOOL (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. SinglePage Allocator 440
  101. MultiPage Allocator 0
  102.  
  103. (7 row(s) affected)
  104.  
  105. MEMORYCLERK_SQLCLR (node 0) KB
  106. ---------------------------------------- -----------
  107. VM Reserved 0
  108. VM Committed 0
  109. Locked Pages Allocated 0
  110. SM Reserved 0
  111. SM Committed 0
  112. SinglePage Allocator 8
  113. MultiPage Allocator 0
  114.  
  115. (7 row(s) affected)
  116.  
  117. MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
  118. ---------------------------------------- -----------
  119. VM Reserved 0
  120. VM Committed 0
  121. Locked Pages Allocated 0
  122. SM Reserved 0
  123. SM Committed 0
  124. SinglePage Allocator 128
  125. MultiPage Allocator 544
  126.  
  127. (7 row(s) affected)
  128.  
  129. MEMORYCLERK_SQLHTTP (node 0) KB
  130. ---------------------------------------- -----------
  131. VM Reserved 0
  132. VM Committed 0
  133. Locked Pages Allocated 0
  134. SM Reserved 0
  135. SM Committed 0
  136. SinglePage Allocator 8
  137. MultiPage Allocator 0
  138.  
  139. (7 row(s) affected)
  140.  
  141. MEMORYCLERK_SNI (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. SinglePage Allocator 16
  149. MultiPage Allocator 16
  150.  
  151. (7 row(s) affected)
  152.  
  153. MEMORYCLERK_FULLTEXT (node 0) KB
  154. ---------------------------------------- -----------
  155. VM Reserved 0
  156. VM Committed 0
  157. Locked Pages Allocated 0
  158. SM Reserved 0
  159. SM Committed 0
  160. SinglePage Allocator 24
  161. MultiPage Allocator 0
  162.  
  163. (7 row(s) affected)
  164.  
  165. MEMORYCLERK_SQLXP (node 0) KB
  166. ---------------------------------------- -----------
  167. VM Reserved 0
  168. VM Committed 0
  169. Locked Pages Allocated 0
  170. SM Reserved 0
  171. SM Committed 0
  172. SinglePage Allocator 16
  173. MultiPage Allocator 0
  174.  
  175. (7 row(s) affected)
  176.  
  177. MEMORYCLERK_XE_BUFFER (node 0) KB
  178. ---------------------------------------- -----------
  179. VM Reserved 4224
  180. VM Committed 4224
  181. Locked Pages Allocated 0
  182. SM Reserved 0
  183. SM Committed 0
  184. SinglePage Allocator 0
  185. MultiPage Allocator 0
  186.  
  187. (7 row(s) affected)
  188.  
  189. MEMORYCLERK_HOST (node 0) KB
  190. ---------------------------------------- -----------
  191. VM Reserved 0
  192. VM Committed 0
  193. Locked Pages Allocated 0
  194. SM Reserved 0
  195. SM Committed 0
  196. SinglePage Allocator 16
  197. MultiPage Allocator 0
  198.  
  199. (7 row(s) affected)
  200.  
  201. MEMORYCLERK_SOSNODE (node 0) KB
  202. ---------------------------------------- -----------
  203. VM Reserved 0
  204. VM Committed 0
  205. Locked Pages Allocated 0
  206. SM Reserved 0
  207. SM Committed 0
  208. SinglePage Allocator 2384
  209. MultiPage Allocator 10912
  210.  
  211. (7 row(s) affected)
  212.  
  213. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
  214. ---------------------------------------------- -----------
  215. VM Reserved 0
  216. VM Committed 0
  217. Locked Pages Allocated 0
  218. SM Reserved 0
  219. SM Committed 0
  220. SinglePage Allocator 48
  221. MultiPage Allocator 0
  222.  
  223. (7 row(s) affected)
  224.  
  225. MEMORYCLERK_XE (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. SinglePage Allocator 64
  233. MultiPage Allocator 816
  234.  
  235. (7 row(s) affected)
  236.  
  237. CACHESTORE_OBJCP (node 0) KB
  238. ---------------------------------------- -----------
  239. VM Reserved 0
  240. VM Committed 0
  241. Locked Pages Allocated 0
  242. SM Reserved 0
  243. SM Committed 0
  244. SinglePage Allocator 616
  245. MultiPage Allocator 0
  246.  
  247. (7 row(s) affected)
  248.  
  249. CACHESTORE_SQLCP (node 0) KB
  250. ---------------------------------------- -----------
  251. VM Reserved 0
  252. VM Committed 0
  253. Locked Pages Allocated 0
  254. SM Reserved 0
  255. SM Committed 0
  256. SinglePage Allocator 19568
  257. MultiPage Allocator 1752
  258.  
  259. (7 row(s) affected)
  260.  
  261. CACHESTORE_PHDR (node 0) KB
  262. ---------------------------------------- -----------
  263. VM Reserved 0
  264. VM Committed 0
  265. Locked Pages Allocated 0
  266. SM Reserved 0
  267. SM Committed 0
  268. SinglePage Allocator 136
  269. MultiPage Allocator 0
  270.  
  271. (7 row(s) affected)
  272.  
  273. CACHESTORE_XPROC (node 0) KB
  274. ---------------------------------------- -----------
  275. VM Reserved 0
  276. VM Committed 0
  277. Locked Pages Allocated 0
  278. SM Reserved 0
  279. SM Committed 0
  280. SinglePage Allocator 16
  281. MultiPage Allocator 0
  282.  
  283. (7 row(s) affected)
  284.  
  285. CACHESTORE_TEMPTABLES (node 0) KB
  286. ---------------------------------------- -----------
  287. VM Reserved 0
  288. VM Committed 0
  289. Locked Pages Allocated 0
  290. SM Reserved 0
  291. SM Committed 0
  292. SinglePage Allocator 16
  293. MultiPage Allocator 0
  294.  
  295. (7 row(s) affected)
  296.  
  297. CACHESTORE_NOTIF (node 0) KB
  298. ---------------------------------------- -----------
  299. VM Reserved 0
  300. VM Committed 0
  301. Locked Pages Allocated 0
  302. SM Reserved 0
  303. SM Committed 0
  304. SinglePage Allocator 16
  305. MultiPage Allocator 0
  306.  
  307. (7 row(s) affected)
  308.  
  309. CACHESTORE_VIEWDEFINITIONS (node 0) KB
  310. ---------------------------------------- -----------
  311. VM Reserved 0
  312. VM Committed 0
  313. Locked Pages Allocated 0
  314. SM Reserved 0
  315. SM Committed 0
  316. SinglePage Allocator 16
  317. MultiPage Allocator 0
  318.  
  319. (7 row(s) affected)
  320.  
  321. CACHESTORE_XMLDBTYPE (node 0) KB
  322. ---------------------------------------- -----------
  323. VM Reserved 0
  324. VM Committed 0
  325. Locked Pages Allocated 0
  326. SM Reserved 0
  327. SM Committed 0
  328. SinglePage Allocator 8
  329. MultiPage Allocator 0
  330.  
  331. (7 row(s) affected)
  332.  
  333. CACHESTORE_XMLDBELEMENT (node 0) KB
  334. ---------------------------------------- -----------
  335. VM Reserved 0
  336. VM Committed 0
  337. Locked Pages Allocated 0
  338. SM Reserved 0
  339. SM Committed 0
  340. SinglePage Allocator 8
  341. MultiPage Allocator 0
  342.  
  343. (7 row(s) affected)
  344.  
  345. CACHESTORE_XMLDBATTRIBUTE (node 0) KB
  346. ---------------------------------------- -----------
  347. VM Reserved 0
  348. VM Committed 0
  349. Locked Pages Allocated 0
  350. SM Reserved 0
  351. SM Committed 0
  352. SinglePage Allocator 8
  353. MultiPage Allocator 0
  354.  
  355. (7 row(s) affected)
  356.  
  357. CACHESTORE_BROKERTBLACS (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. SinglePage Allocator 40
  365. MultiPage Allocator 0
  366.  
  367. (7 row(s) affected)
  368.  
  369. CACHESTORE_BROKERKEK (node 0) KB
  370. ---------------------------------------- -----------
  371. VM Reserved 0
  372. VM Committed 0
  373. Locked Pages Allocated 0
  374. SM Reserved 0
  375. SM Committed 0
  376. SinglePage Allocator 8
  377. MultiPage Allocator 0
  378.  
  379. (7 row(s) affected)
  380.  
  381. CACHESTORE_BROKERDSH (node 0) KB
  382. ---------------------------------------- -----------
  383. VM Reserved 0
  384. VM Committed 0
  385. Locked Pages Allocated 0
  386. SM Reserved 0
  387. SM Committed 0
  388. SinglePage Allocator 8
  389. MultiPage Allocator 0
  390.  
  391. (7 row(s) affected)
  392.  
  393. CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
  394. ---------------------------------------- -----------
  395. VM Reserved 0
  396. VM Committed 0
  397. Locked Pages Allocated 0
  398. SM Reserved 0
  399. SM Committed 0
  400. SinglePage Allocator 8
  401. MultiPage Allocator 0
  402.  
  403. (7 row(s) affected)
  404.  
  405. CACHESTORE_BROKERRSB (node 0) KB
  406. ---------------------------------------- -----------
  407. VM Reserved 0
  408. VM Committed 0
  409. Locked Pages Allocated 0
  410. SM Reserved 0
  411. SM Committed 0
  412. SinglePage Allocator 8
  413. MultiPage Allocator 0
  414.  
  415. (7 row(s) affected)
  416.  
  417. CACHESTORE_BROKERREADONLY (node 0) KB
  418. ---------------------------------------- -----------
  419. VM Reserved 0
  420. VM Committed 0
  421. Locked Pages Allocated 0
  422. SM Reserved 0
  423. SM Committed 0
  424. SinglePage Allocator 32
  425. MultiPage Allocator 0
  426.  
  427. (7 row(s) affected)
  428.  
  429. CACHESTORE_BROKERTO (node 0) KB
  430. ---------------------------------------- -----------
  431. VM Reserved 0
  432. VM Committed 0
  433. Locked Pages Allocated 0
  434. SM Reserved 0
  435. SM Committed 0
  436. SinglePage Allocator 8
  437. MultiPage Allocator 0
  438.  
  439. (7 row(s) affected)
  440.  
  441. CACHESTORE_EVENTS (node 0) KB
  442. ---------------------------------------- -----------
  443. VM Reserved 0
  444. VM Committed 0
  445. Locked Pages Allocated 0
  446. SM Reserved 0
  447. SM Committed 0
  448. SinglePage Allocator 16
  449. MultiPage Allocator 0
  450.  
  451. (7 row(s) affected)
  452.  
  453. CACHESTORE_SYSTEMROWSET (node 0) KB
  454. ---------------------------------------- -----------
  455. VM Reserved 0
  456. VM Committed 0
  457. Locked Pages Allocated 0
  458. SM Reserved 0
  459. SM Committed 0
  460. SinglePage Allocator 600
  461. MultiPage Allocator 0
  462.  
  463. (7 row(s) affected)
  464.  
  465. CACHESTORE_CONVPRI (node 0) KB
  466. ---------------------------------------- -----------
  467. VM Reserved 0
  468. VM Committed 0
  469. Locked Pages Allocated 0
  470. SM Reserved 0
  471. SM Committed 0
  472. SinglePage Allocator 32
  473. MultiPage Allocator 0
  474.  
  475. (7 row(s) affected)
  476.  
  477. CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
  478. ---------------------------------------- -----------
  479. VM Reserved 0
  480. VM Committed 0
  481. Locked Pages Allocated 0
  482. SM Reserved 0
  483. SM Committed 0
  484. SinglePage Allocator 32
  485. MultiPage Allocator 0
  486.  
  487. (7 row(s) affected)
  488.  
  489. USERSTORE_SCHEMAMGR (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. SinglePage Allocator 1992
  497. MultiPage Allocator 16
  498.  
  499. (7 row(s) affected)
  500.  
  501. USERSTORE_DBMETADATA (node 0) KB
  502. ---------------------------------------- -----------
  503. VM Reserved 0
  504. VM Committed 0
  505. Locked Pages Allocated 0
  506. SM Reserved 0
  507. SM Committed 0
  508. SinglePage Allocator 600
  509. MultiPage Allocator 0
  510.  
  511. (7 row(s) affected)
  512.  
  513. USERSTORE_TOKENPERM (node 0) KB
  514. ---------------------------------------- -----------
  515. VM Reserved 0
  516. VM Committed 0
  517. Locked Pages Allocated 0
  518. SM Reserved 0
  519. SM Committed 0
  520. SinglePage Allocator 224
  521. MultiPage Allocator 0
  522.  
  523. (7 row(s) affected)
  524.  
  525. USERSTORE_OBJPERM (node 0) KB
  526. ---------------------------------------- -----------
  527. VM Reserved 0
  528. VM Committed 0
  529. Locked Pages Allocated 0
  530. SM Reserved 0
  531. SM Committed 0
  532. SinglePage Allocator 168
  533. MultiPage Allocator 0
  534.  
  535. (7 row(s) affected)
  536.  
  537. USERSTORE_SXC (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. SinglePage Allocator 24
  545. MultiPage Allocator 0
  546.  
  547. (7 row(s) affected)
  548.  
  549. OBJECTSTORE_LBSS (node 0) KB
  550. ---------------------------------------- -----------
  551. VM Reserved 0
  552. VM Committed 0
  553. Locked Pages Allocated 0
  554. SM Reserved 0
  555. SM Committed 0
  556. SinglePage Allocator 32
  557. MultiPage Allocator 48
  558.  
  559. (7 row(s) affected)
  560.  
  561. OBJECTSTORE_SNI_PACKET (node 0) KB
  562. ---------------------------------------- -----------
  563. VM Reserved 0
  564. VM Committed 0
  565. Locked Pages Allocated 0
  566. SM Reserved 0
  567. SM Committed 0
  568. SinglePage Allocator 8344
  569. MultiPage Allocator 56
  570.  
  571. (7 row(s) affected)
  572.  
  573. OBJECTSTORE_SERVICE_BROKER (node 0) KB
  574. ---------------------------------------- -----------
  575. VM Reserved 0
  576. VM Committed 0
  577. Locked Pages Allocated 0
  578. SM Reserved 0
  579. SM Committed 0
  580. SinglePage Allocator 424
  581. MultiPage Allocator 0
  582.  
  583. (7 row(s) affected)
  584.  
  585. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  586. ---------------------------------------- -----------
  587. VM Reserved 2048
  588. VM Committed 2048
  589. Locked Pages Allocated 0
  590. SM Reserved 0
  591. SM Committed 0
  592. SinglePage Allocator 1072
  593. MultiPage Allocator 0
  594.  
  595. (7 row(s) affected)
  596.  
  597. Buffer Pool Value
  598. ---------------------------------------- -----------
  599. Committed 64000
  600. Target 128000
  601. Database 3488
  602. Dirty 71
  603. In IO 0
  604. Latched 0
  605. Free 55573
  606. Stolen 4939
  607. Reserved 0
  608. Visible 128000
  609. Stolen Potential 116661
  610. Limiting Factor 17
  611. Last OOM Factor 0
  612. Page Life Expectancy 1007
  613.  
  614. (14 row(s) affected)
  615.  
  616. Process/System Counts Value
  617. ---------------------------------------- --------------------
  618. Available Physical Memory 845840384
  619. Available Virtual Memory 8792597913600
  620. Available Paging File 3720708096
  621. Working Set 591941632
  622. Percent of Committed Memory in WS 99
  623. Page Faults 414020
  624. System physical memory high 1
  625. System physical memory low 0
  626. Process physical memory low 0
  627. Process virtual memory low 0
  628.  
  629. (10 row(s) affected)
  630.  
  631. Procedure Cache Value
  632. ---------------------------------------- -----------
  633. TotalProcs 3
  634. TotalPages 2761
  635. InUsePages 0
  636.  
  637. (3 row(s) affected)
  638.  
  639. Global Memory Objects Pages
  640. ---------------------------------------- -----------
  641. Resource 227
  642. Locks 134
  643. XDES 24
  644. SETLS 2
  645. SE Dataset Allocators 4
  646. SubpDesc Allocators 2
  647. SE SchemaManager 139
  648. SE Column Metadata Cache 111
  649. SQLCache 2661
  650. Replication 2
  651. ServerGlobal 50
  652. XP Global 2
  653. SortTables 2
  654.  
  655. (13 row(s) affected)
  656.  
  657. Query Memory Objects (internal) Value
  658. ---------------------------------------- -----------
  659. Grants 0
  660. Waiting 0
  661. Available 91371
  662. Current Max 91371
  663. Future Max 91371
  664. Physical Max 91371
  665. Next Request 0
  666. Waiting For 0
  667. Cost 0
  668. Timeout 0
  669. Wait Time 0
  670.  
  671. (11 row(s) affected)
  672.  
  673. Small Query Memory Objects (internal) Value
  674. ---------------------------------------- -----------
  675. Grants 0
  676. Waiting 0
  677. Available 4809
  678. Current Max 4809
  679. Future Max 4809
  680.  
  681. (5 row(s) affected)
  682.  
  683. Optimization Queue (internal) Value
  684. ---------------------------------------- -----------
  685. Overall Memory 840499200
  686. Target Memory 774152192
  687. Last Notification 1
  688. Timeout 6
  689. Early Termination Factor 5
  690.  
  691. (5 row(s) affected)
  692.  
  693. Small Gateway (internal) Value
  694. ---------------------------------------- -----------
  695. Configured Units 8
  696. Available Units 8
  697. Acquires 0
  698. Waiters 0
  699. Threshold Factor 380000
  700. Threshold 380000
  701.  
  702. (6 row(s) affected)
  703.  
  704. Medium Gateway (internal) Value
  705. ---------------------------------------- -----------
  706. Configured Units 2
  707. Available Units 2
  708. Acquires 0
  709. Waiters 0
  710. Threshold Factor 12
  711. Threshold -1
  712.  
  713. (6 row(s) affected)
  714.  
  715. Big Gateway (internal) Value
  716. ---------------------------------------- -----------
  717. Configured Units 1
  718. Available Units 1
  719. Acquires 0
  720. Waiters 0
  721. Threshold Factor 8
  722. Threshold -1
  723.  
  724. (6 row(s) affected)
  725.  
  726. Memory Pool Manager Pages
  727. ---------------------------------------- -----------
  728. Reserved Current 0
  729. Reserved Limit 116665
  730.  
  731. (2 row(s) affected)
  732.  
  733. Memory Pool (internal) Pages
  734. ---------------------------------------- -----------
  735. Allocations 4935
  736. Predicted 27777
  737. Private Target 0
  738. Private Limit 0
  739. Total Target 121600
  740. Total Limit 121600
  741. OOM Count 80
  742.  
  743. (7 row(s) affected)
  744.  
  745. MEMORYBROKER_FOR_CACHE (internal) Pages
  746. ---------------------------------------- -----------
  747. Allocations 4257
  748. Rate -2
  749. Target Allocations 98080
  750. Future Allocations 0
  751. Overall 102600
  752. Last Notification 1
  753.  
  754. (6 row(s) affected)
  755.  
  756. MEMORYBROKER_FOR_STEAL (internal) Pages
  757. ---------------------------------------- -----------
  758. Allocations 678
  759. Rate 0
  760. Target Allocations 94501
  761. Future Allocations 0
  762. Overall 102600
  763. Last Notification 1
  764.  
  765. (6 row(s) affected)
  766.  
  767. MEMORYBROKER_FOR_RESERVE (internal) Pages
  768. ---------------------------------------- -----------
  769. Allocations 0
  770. Rate 0
  771. Target Allocations 102600
  772. Future Allocations 22842
  773. Overall 102600
  774. Last Notification 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement