API tools faq
paste
Advertisement
Guest User

ERRORLOG

a guest
Jul 4th, 2017
169
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.07 KB | None | 0 0
raw download clone embed print report
  1. 2017-07-04 15:32:47.06 Server Microsoft SQL Server 2014 (SP2-CU1) (KB3178925) - 12.0.5511.0 (X64)
  2. Aug 19 2016 14:32:30
  3. Copyright (c) Microsoft Corporation
  4. Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
  5.  
  6. 2017-07-04 15:32:47.10 Server UTC adjustment: 1:00
  7. 2017-07-04 15:32:47.11 Server (c) Microsoft Corporation.
  8. 2017-07-04 15:32:47.11 Server All rights reserved.
  9. 2017-07-04 15:32:47.11 Server Server process ID is 8504.
  10. 2017-07-04 15:32:47.11 Server System Manufacturer: 'Microsoft Corporation', System Model: 'Virtual Machine'.
  11. 2017-07-04 15:32:47.14 Server Authentication mode is MIXED.
  12. 2017-07-04 15:32:47.15 Server Logging SQL Server messages in file 'D:\sqlserver\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
  13. 2017-07-04 15:32:47.15 Server The service account is 'DOMAIN\SERVICES'. This is an informational message; no user action is required.
  14. 2017-07-04 15:32:47.15 Server Registry startup parameters:
  15. -d D:\sqlserver\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf
  16. -e D:\sqlserver\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG
  17. -l D:\sqlserver\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
  18. 2017-07-04 15:32:47.15 Server Command Line Startup Parameters:
  19. -s "MSSQLSERVER"
  20. 2017-07-04 15:32:48.76 Server SQL Server detected 1 sockets with 16 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
  21. 2017-07-04 15:32:48.76 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
  22. 2017-07-04 15:32:48.76 Server Detected 16383 MB of RAM. This is an informational message; no user action is required.
  23. 2017-07-04 15:32:48.76 Server Using conventional memory in the memory manager.
  24. 2017-07-04 15:32:49.30 Server Default collation: Latin1_General_CI_AS (Español 3082)
  25. 2017-07-04 15:32:50.69 Server This instance of SQL Server last reported using a process ID of 2896 at 04.07.2017 13:45:46 (local) 04.07.2017 12:45:46 (UTC). This is an informational message only; no user action is required.
  26. 2017-07-04 15:32:50.69 Server The maximum number of dedicated administrator connections for this instance is '1'
  27. 2017-07-04 15:32:50.71 Server Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
  28. 2017-07-04 15:32:50.72 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
  29. 2017-07-04 15:32:50.72 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
  30. 2017-07-04 15:32:50.78 Server Database Instant File Initialization: habilitado. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
  31. 2017-07-04 15:32:50.85 spid8s Starting up database 'master'.
  32. 2017-07-04 15:32:51.13 Server CLR version v4.0.30319 loaded.
  33. 2017-07-04 15:32:51.48 Server Software Usage Metrics is enabled.
  34. 2017-07-04 15:32:56.59 spid8s Failed allocate pages: FAIL_PAGE_ALLOCATION 1
  35. 2017-07-04 15:32:56.59 spid8s
  36. Process/System Counts Value
  37. ---------------------------------------- ----------
  38. Available Physical Memory 1811791872
  39. Available Virtual Memory 140723779870720
  40. Available Paging File 18075500544
  41. Working Set 158748672
  42. Percent of Committed Memory in WS 100
  43. Page Faults 66465
  44. System physical memory high 1
  45. System physical memory low 0
  46. Process physical memory low 1
  47. Process virtual memory low 0
  48. 2017-07-04 15:32:56.59 spid8s
  49. Memory Manager KB
  50. ---------------------------------------- ----------
  51. VM Reserved 12989688
  52. VM Committed 125824
  53. Locked Pages Allocated 0
  54. Large Pages Allocated 0
  55. Emergency Memory 1024
  56. Emergency Memory In Use 16
  57. Target Committed 131072
  58. Current Committed 125824
  59. Pages Allocated 82872
  60. Pages Reserved 0
  61. Pages Free 264
  62. Pages In Use 125160
  63. Page Alloc Potential -640
  64. NUMA Growth Phase 0
  65. Last OOM Factor 1
  66. Last OS Error 0
  67. 2017-07-04 15:32:56.59 spid8s
  68. Memory node Id = 0 KB
  69. ---------------------------------------- ----------
  70. VM Reserved 12989624
  71. VM Committed 125804
  72. Locked Pages Allocated 0
  73. Pages Allocated 82872
  74. Pages Free 264
  75. Target Committed 131048
  76. Current Committed 125808
  77. Foreign Committed 0
  78. Away Committed 0
  79. Taken Away Committed 0
  80. 2017-07-04 15:32:56.59 spid8s
  81. Memory node Id = 64 KB
  82. ---------------------------------------- ----------
  83. VM Reserved 0
  84. VM Committed 20
  85. Locked Pages Allocated 0
  86. 2017-07-04 15:32:56.59 spid8s
  87. MEMORYCLERK_SQLGENERAL (node 0) KB
  88. ---------------------------------------- ----------
  89. VM Reserved 0
  90. VM Committed 0
  91. Locked Pages Allocated 0
  92. SM Reserved 0
  93. SM Committed 0
  94. Pages Allocated 3536
  95. 2017-07-04 15:32:56.59 spid8s
  96. MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
  97. ---------------------------------------- ----------
  98. VM Reserved 6499872
  99. VM Committed 32964
  100. Locked Pages Allocated 0
  101. SM Reserved 0
  102. SM Committed 0
  103. Pages Allocated 280
  104. 2017-07-04 15:32:56.59 spid8s
  105. MEMORYCLERK_SQLQUERYEXEC (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. Pages Allocated 152
  113. 2017-07-04 15:32:56.59 spid8s
  114. MEMORYCLERK_SQLOPTIMIZER (node 0) KB
  115. ---------------------------------------- ----------
  116. VM Reserved 0
  117. VM Committed 0
  118. Locked Pages Allocated 0
  119. SM Reserved 0
  120. SM Committed 0
  121. Pages Allocated 1016
  122. 2017-07-04 15:32:56.59 spid8s
  123. MEMORYCLERK_QUERYDISKSTORE (node 0) KB
  124. ---------------------------------------- ----------
  125. VM Reserved 0
  126. VM Committed 0
  127. Locked Pages Allocated 0
  128. SM Reserved 0
  129. SM Committed 0
  130. Pages Allocated 40
  131. 2017-07-04 15:32:56.59 spid8s
  132. MEMORYCLERK_SQLUTILITIES (node 0) KB
  133. ---------------------------------------- ----------
  134. VM Reserved 0
  135. VM Committed 0
  136. Locked Pages Allocated 0
  137. SM Reserved 0
  138. SM Committed 0
  139. Pages Allocated 32
  140. 2017-07-04 15:32:56.59 spid8s
  141. MEMORYCLERK_SQLSTORENG (node 0) KB
  142. ---------------------------------------- ----------
  143. VM Reserved 64
  144. VM Committed 64
  145. Locked Pages Allocated 0
  146. SM Reserved 0
  147. SM Committed 0
  148. Pages Allocated 4608
  149. 2017-07-04 15:32:56.59 spid8s
  150. MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
  151. ---------------------------------------- ----------
  152. VM Reserved 0
  153. VM Committed 0
  154. Locked Pages Allocated 0
  155. SM Reserved 0
  156. SM Committed 0
  157. Pages Allocated 192
  158. 2017-07-04 15:32:56.59 spid8s
  159. MEMORYCLERK_SQLCLR (node 0) KB
  160. ---------------------------------------- ----------
  161. VM Reserved 6300992
  162. VM Committed 6892
  163. Locked Pages Allocated 0
  164. SM Reserved 0
  165. SM Committed 0
  166. Pages Allocated 42816
  167. 2017-07-04 15:32:56.59 spid8s
  168. MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
  169. ---------------------------------------- ----------
  170. VM Reserved 0
  171. VM Committed 0
  172. Locked Pages Allocated 0
  173. SM Reserved 0
  174. SM Committed 0
  175. Pages Allocated 288
  176. 2017-07-04 15:32:56.59 spid8s
  177. MEMORYCLERK_SNI (node 0) KB
  178. ---------------------------------------- ----------
  179. VM Reserved 0
  180. VM Committed 0
  181. Locked Pages Allocated 0
  182. SM Reserved 0
  183. SM Committed 0
  184. Pages Allocated 16
  185. 2017-07-04 15:32:56.59 spid8s
  186. MEMORYCLERK_SNI (node 64) KB
  187. ---------------------------------------- ----------
  188. VM Reserved 0
  189. VM Committed 0
  190. Locked Pages Allocated 0
  191. SM Reserved 0
  192. SM Committed 0
  193. Pages Allocated 16
  194. 2017-07-04 15:32:56.59 spid8s
  195. MEMORYCLERK_SNI (Total) KB
  196. ---------------------------------------- ----------
  197. VM Reserved 0
  198. VM Committed 0
  199. Locked Pages Allocated 0
  200. SM Reserved 0
  201. SM Committed 0
  202. Pages Allocated 32
  203. 2017-07-04 15:32:56.59 spid8s
  204. MEMORYCLERK_SQLXP (node 0) KB
  205. ---------------------------------------- ----------
  206. VM Reserved 0
  207. VM Committed 0
  208. Locked Pages Allocated 0
  209. SM Reserved 0
  210. SM Committed 0
  211. Pages Allocated 16
  212. 2017-07-04 15:32:56.59 spid8s
  213. MEMORYCLERK_HOST (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. Pages Allocated 16
  221. 2017-07-04 15:32:56.59 spid8s
  222. MEMORYCLERK_SOSNODE (node 0) KB
  223. ---------------------------------------- ----------
  224. VM Reserved 0
  225. VM Committed 0
  226. Locked Pages Allocated 0
  227. SM Reserved 0
  228. SM Committed 0
  229. Pages Allocated 21904
  230. 2017-07-04 15:32:56.59 spid8s
  231. MEMORYCLERK_SOSNODE (node 64) KB
  232. ---------------------------------------- ----------
  233. VM Reserved 0
  234. VM Committed 0
  235. Locked Pages Allocated 0
  236. SM Reserved 0
  237. SM Committed 0
  238. Pages Allocated 2600
  239. 2017-07-04 15:32:56.59 spid8s
  240. MEMORYCLERK_SOSNODE (Total) KB
  241. ---------------------------------------- ----------
  242. VM Reserved 0
  243. VM Committed 0
  244. Locked Pages Allocated 0
  245. SM Reserved 0
  246. SM Committed 0
  247. Pages Allocated 24504
  248. 2017-07-04 15:32:56.59 spid8s
  249. MEMORYCLERK_SOSOS (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. Pages Allocated 192
  257. 2017-07-04 15:32:56.59 spid8s
  258. MEMORYCLERK_SOSMEMMANAGER (node 0) KB
  259. ---------------------------------------- ----------
  260. VM Reserved 456
  261. VM Committed 360
  262. Locked Pages Allocated 0
  263. SM Reserved 0
  264. SM Committed 0
  265. Pages Allocated 0
  266. 2017-07-04 15:32:56.59 spid8s
  267. MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
  268. ---------------------------------------- ----------
  269. VM Reserved 0
  270. VM Committed 0
  271. Locked Pages Allocated 0
  272. SM Reserved 0
  273. SM Committed 0
  274. Pages Allocated 200
  275. 2017-07-04 15:32:56.59 spid8s
  276. MEMORYCLERK_XE (node 0) KB
  277. ---------------------------------------- ----------
  278. VM Reserved 0
  279. VM Committed 0
  280. Locked Pages Allocated 0
  281. SM Reserved 0
  282. SM Committed 0
  283. Pages Allocated 376
  284. 2017-07-04 15:32:56.59 spid8s
  285. MEMORYCLERK_SPATIAL (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. Pages Allocated 16
  293. 2017-07-04 15:32:56.59 spid8s
  294. MEMORYCLERK_SQLLOGPOOL (node 0) KB
  295. ---------------------------------------- ----------
  296. VM Reserved 0
  297. VM Committed 0
  298. Locked Pages Allocated 0
  299. SM Reserved 0
  300. SM Committed 0
  301. Pages Allocated 152
  302. 2017-07-04 15:32:56.59 spid8s
  303. MEMORYCLERK_FSCHUNKER (node 0) KB
  304. ---------------------------------------- ----------
  305. VM Reserved 0
  306. VM Committed 0
  307. Locked Pages Allocated 0
  308. SM Reserved 0
  309. SM Committed 0
  310. Pages Allocated 48
  311. 2017-07-04 15:32:56.59 spid8s
  312. CACHESTORE_OBJCP (node 0) KB
  313. ---------------------------------------- ----------
  314. VM Reserved 0
  315. VM Committed 0
  316. Locked Pages Allocated 0
  317. SM Reserved 0
  318. SM Committed 0
  319. Pages Allocated 8
  320. 2017-07-04 15:32:56.59 spid8s
  321. CACHESTORE_SQLCP (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. Pages Allocated 1704
  329. 2017-07-04 15:32:56.59 spid8s
  330. CACHESTORE_PHDR (node 0) KB
  331. ---------------------------------------- ----------
  332. VM Reserved 0
  333. VM Committed 0
  334. Locked Pages Allocated 0
  335. SM Reserved 0
  336. SM Committed 0
  337. Pages Allocated 8
  338. 2017-07-04 15:32:56.59 spid8s
  339. CACHESTORE_XPROC (node 0) KB
  340. ---------------------------------------- ----------
  341. VM Reserved 0
  342. VM Committed 0
  343. Locked Pages Allocated 0
  344. SM Reserved 0
  345. SM Committed 0
  346. Pages Allocated 16
  347. 2017-07-04 15:32:56.59 spid8s
  348. CACHESTORE_TEMPTABLES (node 0) KB
  349. ---------------------------------------- ----------
  350. VM Reserved 0
  351. VM Committed 0
  352. Locked Pages Allocated 0
  353. SM Reserved 0
  354. SM Committed 0
  355. Pages Allocated 16
  356. 2017-07-04 15:32:56.59 spid8s
  357. CACHESTORE_NOTIF (node 0) KB
  358. ---------------------------------------- ----------
  359. VM Reserved 0
  360. VM Committed 0
  361. Locked Pages Allocated 0
  362. SM Reserved 0
  363. SM Committed 0
  364. Pages Allocated 16
  365. 2017-07-04 15:32:56.59 spid8s
  366. CACHESTORE_VIEWDEFINITIONS (node 0) KB
  367. ---------------------------------------- ----------
  368. VM Reserved 0
  369. VM Committed 0
  370. Locked Pages Allocated 0
  371. SM Reserved 0
  372. SM Committed 0
  373. Pages Allocated 16
  374. 2017-07-04 15:32:56.59 spid8s
  375. CACHESTORE_XMLDBTYPE (node 0) KB
  376. ---------------------------------------- ----------
  377. VM Reserved 0
  378. VM Committed 0
  379. Locked Pages Allocated 0
  380. SM Reserved 0
  381. SM Committed 0
  382. Pages Allocated 8
  383. 2017-07-04 15:32:56.59 spid8s
  384. CACHESTORE_XMLDBELEMENT (node 0) KB
  385. ---------------------------------------- ----------
  386. VM Reserved 0
  387. VM Committed 0
  388. Locked Pages Allocated 0
  389. SM Reserved 0
  390. SM Committed 0
  391. Pages Allocated 8
  392. 2017-07-04 15:32:56.59 spid8s
  393. CACHESTORE_XMLDBATTRIBUTE (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. Pages Allocated 8
  401. 2017-07-04 15:32:56.59 spid8s
  402. CACHESTORE_STACKFRAMES (node 0) KB
  403. ---------------------------------------- ----------
  404. VM Reserved 0
  405. VM Committed 0
  406. Locked Pages Allocated 0
  407. SM Reserved 0
  408. SM Committed 0
  409. Pages Allocated 8
  410. 2017-07-04 15:32:56.59 spid8s
  411. CACHESTORE_STACKFRAMES (node 64) KB
  412. ---------------------------------------- ----------
  413. VM Reserved 0
  414. VM Committed 0
  415. Locked Pages Allocated 0
  416. SM Reserved 0
  417. SM Committed 0
  418. Pages Allocated 8
  419. 2017-07-04 15:32:56.59 spid8s
  420. CACHESTORE_STACKFRAMES (Total) KB
  421. ---------------------------------------- ----------
  422. VM Reserved 0
  423. VM Committed 0
  424. Locked Pages Allocated 0
  425. SM Reserved 0
  426. SM Committed 0
  427. Pages Allocated 16
  428. 2017-07-04 15:32:56.59 spid8s
  429. CACHESTORE_BROKERTBLACS (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. Pages Allocated 16
  437. 2017-07-04 15:32:56.59 spid8s
  438. CACHESTORE_BROKERKEK (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 8
  446. 2017-07-04 15:32:56.59 spid8s
  447. CACHESTORE_BROKERDSH (node 0) KB
  448. ---------------------------------------- ----------
  449. VM Reserved 0
  450. VM Committed 0
  451. Locked Pages Allocated 0
  452. SM Reserved 0
  453. SM Committed 0
  454. Pages Allocated 8
  455. 2017-07-04 15:32:56.59 spid8s
  456. CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
  457. ---------------------------------------- ----------
  458. VM Reserved 0
  459. VM Committed 0
  460. Locked Pages Allocated 0
  461. SM Reserved 0
  462. SM Committed 0
  463. Pages Allocated 8
  464. 2017-07-04 15:32:56.59 spid8s
  465. CACHESTORE_BROKERRSB (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. Pages Allocated 8
  473. 2017-07-04 15:32:56.59 spid8s
  474. CACHESTORE_BROKERREADONLY (node 0) KB
  475. ---------------------------------------- ----------
  476. VM Reserved 0
  477. VM Committed 0
  478. Locked Pages Allocated 0
  479. SM Reserved 0
  480. SM Committed 0
  481. Pages Allocated 32
  482. 2017-07-04 15:32:56.59 spid8s
  483. CACHESTORE_BROKERTO (node 0) KB
  484. ---------------------------------------- ----------
  485. VM Reserved 0
  486. VM Committed 0
  487. Locked Pages Allocated 0
  488. SM Reserved 0
  489. SM Committed 0
  490. Pages Allocated 8
  491. 2017-07-04 15:32:56.59 spid8s
  492. CACHESTORE_EVENTS (node 0) KB
  493. ---------------------------------------- ----------
  494. VM Reserved 0
  495. VM Committed 0
  496. Locked Pages Allocated 0
  497. SM Reserved 0
  498. SM Committed 0
  499. Pages Allocated 16
  500. 2017-07-04 15:32:56.59 spid8s
  501. CACHESTORE_SEHOBTCOLUMNATTRIBUTE (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. Pages Allocated 128
  509. 2017-07-04 15:32:56.59 spid8s
  510. CACHESTORE_SYSTEMROWSET (node 0) KB
  511. ---------------------------------------- ----------
  512. VM Reserved 0
  513. VM Committed 0
  514. Locked Pages Allocated 0
  515. SM Reserved 0
  516. SM Committed 0
  517. Pages Allocated 128
  518. 2017-07-04 15:32:56.59 spid8s
  519. CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
  520. ---------------------------------------- ----------
  521. VM Reserved 0
  522. VM Committed 0
  523. Locked Pages Allocated 0
  524. SM Reserved 0
  525. SM Committed 0
  526. Pages Allocated 128
  527. 2017-07-04 15:32:56.59 spid8s
  528. CACHESTORE_XML_SELECTIVE_DG (node 0) KB
  529. ---------------------------------------- ----------
  530. VM Reserved 0
  531. VM Committed 0
  532. Locked Pages Allocated 0
  533. SM Reserved 0
  534. SM Committed 0
  535. Pages Allocated 8
  536. 2017-07-04 15:32:56.59 spid8s
  537. USERSTORE_SCHEMAMGR (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 480
  545. 2017-07-04 15:32:56.59 spid8s
  546. USERSTORE_DBMETADATA (node 0) KB
  547. ---------------------------------------- ----------
  548. VM Reserved 0
  549. VM Committed 0
  550. Locked Pages Allocated 0
  551. SM Reserved 0
  552. SM Committed 0
  553. Pages Allocated 16
  554. 2017-07-04 15:32:56.59 spid8s
  555. USERSTORE_TOKENPERM (node 0) KB
  556. ---------------------------------------- ----------
  557. VM Reserved 0
  558. VM Committed 0
  559. Locked Pages Allocated 0
  560. SM Reserved 0
  561. SM Committed 0
  562. Pages Allocated 168
  563. 2017-07-04 15:32:56.59 spid8s
  564. USERSTORE_OBJPERM (node 0) KB
  565. ---------------------------------------- ----------
  566. VM Reserved 0
  567. VM Committed 0
  568. Locked Pages Allocated 0
  569. SM Reserved 0
  570. SM Committed 0
  571. Pages Allocated 136
  572. 2017-07-04 15:32:56.59 spid8s
  573. USERSTORE_SXC (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. Pages Allocated 8
  581. 2017-07-04 15:32:56.59 spid8s
  582. USERSTORE_SXC (node 64) KB
  583. ---------------------------------------- ----------
  584. VM Reserved 0
  585. VM Committed 0
  586. Locked Pages Allocated 0
  587. SM Reserved 0
  588. SM Committed 0
  589. Pages Allocated 8
  590. 2017-07-04 15:32:56.59 spid8s
  591. USERSTORE_SXC (Total) KB
  592. ---------------------------------------- ----------
  593. VM Reserved 0
  594. VM Committed 0
  595. Locked Pages Allocated 0
  596. SM Reserved 0
  597. SM Committed 0
  598. Pages Allocated 16
  599. 2017-07-04 15:32:56.59 spid8s
  600. OBJECTSTORE_LBSS (node 0) KB
  601. ---------------------------------------- ----------
  602. VM Reserved 0
  603. VM Committed 0
  604. Locked Pages Allocated 0
  605. SM Reserved 0
  606. SM Committed 0
  607. Pages Allocated 16
  608. 2017-07-04 15:32:56.59 spid8s
  609. OBJECTSTORE_SNI_PACKET (node 0) KB
  610. ---------------------------------------- ----------
  611. VM Reserved 0
  612. VM Committed 0
  613. Locked Pages Allocated 0
  614. SM Reserved 0
  615. SM Committed 0
  616. Pages Allocated 56
  617. 2017-07-04 15:32:56.59 spid8s
  618. OBJECTSTORE_SNI_PACKET (node 64) KB
  619. ---------------------------------------- ----------
  620. VM Reserved 0
  621. VM Committed 0
  622. Locked Pages Allocated 0
  623. SM Reserved 0
  624. SM Committed 0
  625. Pages Allocated 56
  626. 2017-07-04 15:32:56.59 spid8s
  627. OBJECTSTORE_SNI_PACKET (Total) KB
  628. ---------------------------------------- ----------
  629. VM Reserved 0
  630. VM Committed 0
  631. Locked Pages Allocated 0
  632. SM Reserved 0
  633. SM Committed 0
  634. Pages Allocated 112
  635. 2017-07-04 15:32:56.59 spid8s
  636. OBJECTSTORE_SERVICE_BROKER (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 384
  644. 2017-07-04 15:32:56.59 spid8s
  645. OBJECTSTORE_LOCK_MANAGER (node 0) KB
  646. ---------------------------------------- ----------
  647. VM Reserved 512
  648. VM Committed 512
  649. Locked Pages Allocated 0
  650. SM Reserved 0
  651. SM Committed 0
  652. Pages Allocated 648
  653. 2017-07-04 15:32:56.59 spid8s
  654. OBJECTSTORE_LOCK_MANAGER (node 64) KB
  655. ---------------------------------------- ----------
  656. VM Reserved 0
  657. VM Committed 0
  658. Locked Pages Allocated 0
  659. SM Reserved 0
  660. SM Committed 0
  661. Pages Allocated 24
  662. 2017-07-04 15:32:56.59 spid8s
  663. OBJECTSTORE_LOCK_MANAGER (Total) KB
  664. ---------------------------------------- ----------
  665. VM Reserved 512
  666. VM Committed 512
  667. Locked Pages Allocated 0
  668. SM Reserved 0
  669. SM Committed 0
  670. Pages Allocated 672
  671. 2017-07-04 15:32:56.59 spid8s
  672. OBJECTSTORE_XACT_CACHE (node 0) KB
  673. ---------------------------------------- ----------
  674. VM Reserved 0
  675. VM Committed 0
  676. Locked Pages Allocated 0
  677. SM Reserved 0
  678. SM Committed 0
  679. Pages Allocated 16
  680. 2017-07-04 15:32:56.59 spid8s
  681. OBJECTSTORE_XACT_CACHE (node 64) KB
  682. ---------------------------------------- ----------
  683. VM Reserved 0
  684. VM Committed 0
  685. Locked Pages Allocated 0
  686. SM Reserved 0
  687. SM Committed 0
  688. Pages Allocated 16
  689. 2017-07-04 15:32:56.59 spid8s
  690. OBJECTSTORE_XACT_CACHE (Total) KB
  691. ---------------------------------------- ----------
  692. VM Reserved 0
  693. VM Committed 0
  694. Locked Pages Allocated 0
  695. SM Reserved 0
  696. SM Committed 0
  697. Pages Allocated 32
  698. 2017-07-04 15:32:56.59 spid8s
  699. Buffer Pool Value
  700. ---------------------------------------- ----------
  701. Database 34
  702. Simulated 0
  703. Target 32751616
  704. Dirty 0
  705. In IO 0
  706. Latched 1
  707. Page Life Expectancy 7
  708. 2017-07-04 15:32:56.59 spid8s
  709. Procedure Cache Value
  710. ---------------------------------------- ----------
  711. TotalProcs 0
  712. TotalPages 217
  713. InUsePages 0
  714. 2017-07-04 15:32:56.59 spid8s
  715. Global Memory Objects Pages
  716. ---------------------------------------- ----------
  717. Resource 325
  718. Locks 84
  719. XDES 37
  720. DirtyPageTracking 16
  721. SETLS 16
  722. SubpDesc Allocators 16
  723. SE SchemaManager 37
  724. SE Column Metadata Cache 22
  725. SE Column Metadata Cache Store 1
  726. SQLCache 197
  727. Replication 2
  728. ServerGlobal 52
  729. XP Global 2
  730. SortTables 3
  731. 2017-07-04 15:32:56.59 spid8s
  732. Query Memory Objects (internal) Value
  733. ---------------------------------------- ----------
  734. Grants 0
  735. Waiting 0
  736. Available 375
  737. Current Max 375
  738. Future Max 375
  739. Physical Max 12300
  740. Next Request 0
  741. Waiting For 0
  742. Cost 0
  743. Timeout 0
  744. Wait Time 0
  745. 2017-07-04 15:32:56.59 spid8s
  746. Small Query Memory Objects (internal) Value
  747. ---------------------------------------- ----------
  748. Grants 0
  749. Waiting 0
  750. Available 0
  751. Current Max 0
  752. Future Max 0
  753. 2017-07-04 15:32:56.59 spid8s
  754. Remote Query Memory Objects (internal) Value
  755. ---------------------------------------- ----------
  756. Grants 0
  757. Waiting 0
  758. Available 6150
  759. Current Max 6150
  760. 2017-07-04 15:32:56.60 spid8s
  761. Optimization Queue (internal) Value
  762. ---------------------------------------- ----------
  763. Overall Memory 107577344
  764. Target Memory 56918016
  765. Last Notification 2
  766. Timeout 6
  767. Early Termination Factor 5
  768. 2017-07-04 15:32:56.62 spid8s
  769. Small Gateway (internal) Value
  770. ---------------------------------------- ----------
  771. Configured Units 64
  772. Available Units 64
  773. Acquires 0
  774. Waiters 0
  775. Threshold Factor 380000
  776. Threshold 380000
  777. 2017-07-04 15:32:56.62 spid8s
  778. Medium Gateway (internal) Value
  779. ---------------------------------------- ----------
  780. Configured Units 16
  781. Available Units 16
  782. Acquires 0
  783. Waiters 0
  784. Threshold Factor 12
  785. Threshold -1
  786. 2017-07-04 15:32:56.62 spid8s
  787. Big Gateway (internal) Value
  788. ---------------------------------------- ----------
  789. Configured Units 1
  790. Available Units 1
  791. Acquires 0
  792. Waiters 0
  793. Threshold Factor 8
  794. Threshold -1
  795. 2017-07-04 15:32:56.62 spid8s
  796. Memory Pool Manager KB
  797. ---------------------------------------- ----------
  798. Reserved Current 0
  799. Reserved Limit 0
  800. 2017-07-04 15:32:56.62 spid8s
  801. Memory Pool (internal) KB
  802. ---------------------------------------- ----------
  803. Allocations 125296
  804. Predicted 153664
  805. Private Target 0
  806. Private Limit 0
  807. Total Target 124512
  808. Total Limit 124512
  809. OOM Count 0
  810. 2017-07-04 15:32:56.62 spid8s
  811. MEMORYBROKER_FOR_CACHE (internal) KB
  812. ---------------------------------------- ----------
  813. Allocations 4496
  814. Rate 32
  815. Target Allocations 3280
  816. Future Allocations 0
  817. Overall 105056
  818. Last Notification 2
  819. 2017-07-04 15:32:56.62 spid8s
  820. MEMORYBROKER_FOR_STEAL (internal) KB
  821. ---------------------------------------- ----------
  822. Allocations 78112
  823. Rate 3200
  824. Target Allocations 55584
  825. Future Allocations 0
  826. Overall 105056
  827. Last Notification 2
  828. 2017-07-04 15:32:56.62 spid8s
  829. MEMORYBROKER_FOR_RESERVE (internal) KB
  830. ---------------------------------------- ----------
  831. Allocations 0
  832. Rate 0
  833. Target Allocations 3280
  834. Future Allocations 24600
  835. Overall 105056
  836. Last Notification 0
  837. 2017-07-04 15:32:56.62 spid8s
  838. MEMORYBROKER_FOR_COMMITTED (internal) KB
  839. ---------------------------------------- ----------
  840. Allocations 42688
  841. Rate 536
  842. Target Allocations 29544
  843. Future Allocations 0
  844. Overall 105056
  845. Last Notification 2
  846. 2017-07-04 15:32:56.62 spid8s
  847. MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
  848. ---------------------------------------- ----------
  849. Allocations 0
  850. Rate 0
  851. Target Allocations 3280
  852. Future Allocations 0
  853. Overall 105056
  854. Last Notification 0
  855. 2017-07-04 15:32:56.62 spid8s
  856. MEMORYBROKER_FOR_XTP (internal) KB
  857. ---------------------------------------- ----------
  858. Allocations 0
  859. Rate 0
  860. Target Allocations 3280
  861. Future Allocations 0
  862. Overall 105056
  863. Last Notification 0
  864. 2017-07-04 15:32:56.62 spid8s
  865. Memory Broker Clerk (Buffer Pool) Pages
  866. ---------------------------------------- ----------
  867. Total 34
  868. Simulated 0
  869. Simulation Benefit 0
  870. Internal Benefit 0
  871. External Benefit 0
  872. Value Of Memory 0
  873. Periodic Freed 0
  874. Internal Freed 0
  875. 2017-07-04 15:32:56.62 spid8s Error: 701, Severity: 17, State: 123.
  876. 2017-07-04 15:32:56.62 spid8s There is insufficient system memory in resource pool 'internal' to run this query.
  877. 2017-07-04 15:32:56.65 spid8s SQL Server shutdown has been initiated
  878. 2017-07-04 15:32:56.68 spid8s Error: 701, Severity: 17, State: 123.
  879. 2017-07-04 15:32:56.68 spid8s There is insufficient system memory in resource pool 'internal' to run this query.
  880. 2017-07-04 15:32:56.77 spid8s SQL Server shutdown has been initiated
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!