API tools faq
paste
Advertisement
Guest User

Untitled

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