November 28, 2023 at 7:18 pm
I'm having an issue trying to drop a service. When I issue the drop command, the process runs for multiple hours and then the server dies with the following silent scream (any ideas would be appreciated) This does the same thing on 2 different 2022 CU10 SQL Servers on copies of the same database:
11/27/2023 12:30:07,spid81,Unknown,Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (1<c/> LOOKASIDE<c/> Transaction)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 1472<nl/>MaxSizeClass 1472
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (2<c/> LOOKASIDE<c/> Transaction read set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 3096<nl/>MaxSizeClass 3096
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (3<c/> LOOKASIDE<c/> Transaction scan set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 2840<nl/>MaxSizeClass 2840
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (4<c/> LOOKASIDE<c/> Transaction write set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 1304<nl/>MaxSizeClass 1304
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (5<c/> LOOKASIDE<c/> Transaction save-point set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 536<nl/>MaxSizeClass 536
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (6<c/> LOOKASIDE<c/> Transaction constraint set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 2584<nl/>MaxSizeClass 2584
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (7<c/> LOOKASIDE<c/> Transaction partially-inserted rows set)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 536<nl/>MaxSizeClass 536
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (8<c/> LOOKASIDE<c/> Transaction FK validation sets)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 96<nl/>MaxSizeClass 96
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (9<c/> LOOKASIDE<c/> Transaction save-point set entry)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 112<nl/>MaxSizeClass 112
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (10<c/> LOOKASIDE<c/> Transaction dependent ring buffer)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 1560<nl/>MaxSizeClass 1560
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (11<c/> LOOKASIDE<c/> Hash cursor)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 320<nl/>MaxSizeClass 320
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (12<c/> LOOKASIDE<c/> Range cursor)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 832<nl/>MaxSizeClass 832
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (13<c/> LOOKASIDE<c/> Heap cursor)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 472<nl/>MaxSizeClass 472
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (14<c/> LOOKASIDE<c/> Transaction recent rows)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 720<nl/>MaxSizeClass 720
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (15<c/> LOOKASIDE<c/> Redo transaction map entry)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 72<nl/>MaxSizeClass 72
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (16<c/> LOOKASIDE<c/> Sequence object values map)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 192<nl/>MaxSizeClass 192
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (17<c/> LOOKASIDE<c/> Sequence object map entry)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 32<nl/>MaxSizeClass 32
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (18<c/> LOOKASIDE<c/> Sequence object insert row)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 88<nl/>MaxSizeClass 88
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (19<c/> LOOKASIDE<c/> Log IO completion)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 104<nl/>MaxSizeClass 104
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (20<c/> LOOKASIDE<c/> Log IO proxy)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 248<nl/>MaxSizeClass 248
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (21<c/> LOOKASIDE<c/> Creation Statement Id Map)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 72<nl/>MaxSizeClass 72
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (22<c/> LOOKASIDE<c/> Creation Statement Id Map Entry)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 32<nl/>MaxSizeClass 32
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (23<c/> LOOKASIDE<c/> Transaction delta tracker)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 48<nl/>MaxSizeClass 48
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (24<c/> LOOKASIDE<c/> Delta tracker cursor)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 64<nl/>MaxSizeClass 64
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (25<c/> LOOKASIDE<c/> Transaction list element)<nl/>---------------------------------------- ----------<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 2<nl/>MinSizeClass 24<nl/>MaxSizeClass 24
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (26<c/> VARHEAP<c/> System heap)<nl/>---------------------------------------- ----------<nl/>Database Id 0<nl/>Object Id 0<nl/>XTP Object Id -501<nl/>Index Id 0<nl/>Allocated (KB) 448<nl/>Used (KB) 391<nl/>Allocation Count 2261<nl/>SizeClass Count 112<nl/>MinSizeClass 1<nl/>MaxSizeClass 16384
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (27<c/> PGPOOL<c/> 4K page pool)<nl/>---------------------------------------- ----------<nl/>Database Id 0<nl/>Object Id 0<nl/>XTP Object Id -501<nl/>Index Id 0<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 1<nl/>MinSizeClass 4096<nl/>MaxSizeClass 4096
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (28<c/> PGPOOL<c/> 256K page pool)<nl/>---------------------------------------- ----------<nl/>Database Id 0<nl/>Object Id 0<nl/>XTP Object Id -501<nl/>Index Id 0<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 1<nl/>MinSizeClass 262144<nl/>MaxSizeClass 262144
11/27/2023 12:30:06,Server,Unknown,[INFO] MSExtra-28<nl/>XTP_MEMORY_CONSUMER (29<c/> VARHEAP<c/> Lookaside heap)<nl/>---------------------------------------- ----------<nl/>Database Id 0<nl/>Object Id 0<nl/>XTP Object Id -501<nl/>Index Id 0<nl/>Allocated (KB) 0<nl/>Used (KB) 0<nl/>Allocation Count 0<nl/>SizeClass Count 73<nl/>MinSizeClass 8<nl/>MaxSizeClass 3096
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory Broker Clerk (Buffer Pool) Pages<nl/>---------------------------------------- ----------<nl/>Total 164892 1.26 gb<nl/>Simulated 38840 303.44 mb<nl/>Simulation Benefit 0.0000004888 <nl/>Internal Benefit 0 <nl/>External Benefit 0 <nl/>Value Of Memory 0 <nl/>Periodic Freed 0 0.00 bytes<nl/>Internal Freed 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_XTP (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 64 64.00 kb<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 0 0.00 bytes<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_RESERVE (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 0 0.00 bytes<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 5044616 4.81 gb<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_STEAL (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 281832 275.23 mb<nl/>Rate -44880 -43.83 mb<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_CACHE (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 23688400 22.59 gb<nl/>Rate -31472 -30.73 mb<nl/>Target Allocations 16697768 15.92 gb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 2 SHRINK
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory Pool (default) KB<nl/>---------------------------------------- ----------<nl/>Allocations 23970296 22.86 gb<nl/>Predicted 29014912 27.67 gb<nl/>Private Target 0 0.00 bytes<nl/>Private Limit 0 0.00 bytes<nl/>Total Target 25549616 24.37 gb<nl/>Total Limit 25549616 24.37 gb<nl/>OOM Count 0
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_XTP (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 11320 11.05 mb<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 0 0.00 bytes<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_COMMITTED (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 921208 899.62 mb<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 2 SHRINK
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_RESERVE (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 0 0.00 bytes<nl/>Rate 0 0.00 bytes<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_STEAL (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 180736 176.50 mb<nl/>Rate -1144 -1.12 mb<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYBROKER_FOR_CACHE (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 453056 442.44 mb<nl/>Rate 1432 1.40 mb<nl/>Target Allocations 673664 657.88 mb<nl/>Future Allocations 0 0.00 bytes<nl/>Overall 21557488 20.56 gb<nl/>Last Notification 0 STABLE
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory Pool (internal) KB<nl/>---------------------------------------- ----------<nl/>Allocations 1566320 1.49 gb<nl/>Predicted 1567752 1.50 gb<nl/>Private Target 0 0.00 bytes<nl/>Private Limit 0 0.00 bytes<nl/>Total Target 25549616 24.37 gb<nl/>Total Limit 25549616 24.37 gb<nl/>OOM Count 0
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory Pool Manager KB<nl/>---------------------------------------- ----------<nl/>Reserved Current 0 0.00 bytes<nl/>Reserved Limit 13000 12.70 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Big Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1 <nl/>Available Units 1 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 8 <nl/>Threshold -1
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Medium Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 4 <nl/>Available Units 4 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 12 <nl/>Threshold -1
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Small Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 16 <nl/>Available Units 16 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 380000 <nl/>Threshold 380000
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Optimization Queue (default) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 22074867712 20.56 gb<nl/>Target Memory 689831936 657.88 mb<nl/>Last Notification 0 STABLE<nl/>Timeout 6 6.00 secs<nl/>Early Termination Factor 5
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1 <nl/>Available Units 1 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 8 <nl/>Threshold -1
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 4 <nl/>Available Units 4 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 12 <nl/>Threshold -1
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 16 <nl/>Available Units 16 <nl/>Acquires 0 <nl/>Waiters 0 <nl/>Threshold Factor 380000 <nl/>Threshold 380000
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 22074867712 20.56 gb<nl/>Target Memory 689831936 657.88 mb<nl/>Last Notification 0 STABLE<nl/>Timeout 6 6.00 secs<nl/>Early Termination Factor 5
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Small Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0 <nl/>Waiting 0 <nl/>Available 3947 30.84 kb<nl/>Current Max 3947 30.84 kb<nl/>Future Max 3947 30.84 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0 <nl/>Waiting 0 <nl/>Available 74998 585.92 kb<nl/>Current Max 74998 585.92 kb<nl/>Future Max 74998 585.92 kb<nl/>Physical Max 2522308 19.24 mb<nl/>Next Request 0 0.00 bytes<nl/>Waiting For 0 0.00 bytes<nl/>Cost 0 <nl/>Timeout 0 0.00 secs<nl/>Wait Time 0 0.00 secs
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0 <nl/>Waiting 0 <nl/>Available 3947 30.84 kb<nl/>Current Max 3947 30.84 kb<nl/>Future Max 3947 30.84 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0 <nl/>Waiting 0 <nl/>Available 74998 585.92 kb<nl/>Current Max 74998 585.92 kb<nl/>Future Max 74998 585.92 kb<nl/>Physical Max 2522308 19.24 mb<nl/>Next Request 0 0.00 bytes<nl/>Waiting For 0 0.00 bytes<nl/>Cost 0 <nl/>Timeout 0 0.00 secs<nl/>Wait Time 0 0.00 secs
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 806 6.30 mb<nl/>Locks 274027 2.09 gb<nl/>XDES 33033 258.07 mb<nl/>DirtyPageTracking 1787 13.96 mb<nl/>SETLS 4 32.00 kb<nl/>SubpDesc Allocators 4 32.00 kb<nl/>SE SchemaManager 1961 15.32 mb<nl/>SE Column Metadata Cache 1893 14.79 mb<nl/>SE Column Metadata Cache Store 13 104.00 kb<nl/>SE Column Store Metadata Cache 4 32.00 kb<nl/>SQLCache 215 1.68 mb<nl/>Replication 2 16.00 kb<nl/>ServerGlobal 1509 11.79 mb<nl/>XP Global 2 16.00 kb<nl/>SortTables 3 24.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 60 <nl/>TotalPages 1368 10.69 mb<nl/>InUsePages 30 240.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Buffer Pool Previous Clock Stats Count<nl/>---------------------------------------- ----------<nl/>Never Used 0 0.00 bytes<nl/>Stolen or Free 2451968 18.71 gb<nl/>Above Cutoff (HOT) 107609 840.70 mb<nl/>Not on LRU 0 0.00 bytes<nl/>Single Use 37866 295.83 mb<nl/>Long IO Queue 0 0.00 bytes<nl/>In IO 0 0.00 bytes<nl/>In Allocation 0 0.00 bytes<nl/>Preemptive 0 0.00 bytes<nl/>Skip Pool 0 0.00 bytes<nl/>Moved to L2 0 0.00 bytes<nl/>Evicted 33901 264.85 mb<nl/>Evicted Mapped 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Buffer Pool Current Clock Stats Count<nl/>---------------------------------------- ----------<nl/>Never Used 0 0.00 bytes<nl/>Stolen or Free 1554075 11.86 gb<nl/>Above Cutoff (HOT) 12424 97.06 mb<nl/>Not on LRU 0 0.00 bytes<nl/>Single Use 0 0.00 bytes<nl/>Long IO Queue 0 0.00 bytes<nl/>In IO 0 0.00 bytes<nl/>In Allocation 0 0.00 bytes<nl/>Preemptive 0 0.00 bytes<nl/>Skip Pool 14 112.00 kb<nl/>Moved to L2 0 0.00 bytes<nl/>Evicted 3472 27.12 mb<nl/>Evicted Mapped 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Buffer Pool Pages<nl/>---------------------------------------- ----------<nl/>Database 164854 1.26 gb<nl/>Simulated 38843 303.46 mb<nl/>Target 65503232 499.75 gb<nl/>Dirty 2579 20.15 mb<nl/>In IO 44 352.00 kb<nl/>Latched 7 56.00 kb<nl/>IO error 0 0.00 bytes<nl/>In Internal Pool 0 <nl/>Page Life Expectancy 5
11/27/2023 12:30:06,spid81,Unknown,Initializing Microsoft Distributed Transaction Coordinator (MS DTC) resource manager [dfc6998e-6d2e-4f80-990e-2f8f0a5f46e1] for server instance TACSQL252I. This is an informational message only. No user action is required.
11/27/2023 12:30:06,spid102,Unknown,The client was unable to reuse a session with SPID 102<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
11/27/2023 12:30:06,spid102,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_XACT_CACHE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 168 168.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,spid63,Unknown,The client was unable to reuse a session with SPID 63<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
11/27/2023 12:30:06,spid63,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131072 128.00 mb<nl/>VM Committed 131072 128.00 mb<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 2192184 2.09 gb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_LOCK_MANAGER (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 24 24.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131072 128.00 mb<nl/>VM Committed 131072 128.00 mb<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 2192160 2.09 gb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16266640 15.51 gb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 984 984.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SNI_PACKET (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 64 64.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 920 920.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 96 96.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>OBJECTSTORE_SOSTASK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 216 216.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_QDSSTMT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 568 568.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_FILETABLEFCB (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 112 112.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_SXC (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_SXC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 104 104.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_OBJPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1600 1.56 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_TOKENPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1808 1.77 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_DBMETADATA (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1384 1.35 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>USERSTORE_SCHEMAMGR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 30936 30.21 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_S3_TEMP_CREDENTIAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 24 24.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_XML_SELECTIVE_DG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_QDSRUNTIMESTATS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 464 464.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_QDSCONTEXTSETTINGS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 480 480.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 32 32.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_FILETABLETUNNELCACHE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_SEARCHPROPERTYLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_FULLTEXTSTOPLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 32 32.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_CONVPRI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 48 48.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_SYSTEMROWSET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 2504 2.45 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 608 608.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_EVENTS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERTO (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 5619712 5.36 gb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERREADONLY (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 368 368.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERRSB (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERDSH (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERKEK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_BROKERTBLACS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 328 328.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_XMLDBATTRIBUTE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_XMLDBELEMENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_XMLDBTYPE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_VIEWDEFINITIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_NOTIF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,Error: 9602<c/> Severity: 16<c/> State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing<c/> ETW<c/> notifications etc are skipped.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_TEMPTABLES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 40 40.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_XPROC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 24 24.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_PHDR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 11384 11.12 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_SQLCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 4312 4.21 mb
11/27/2023 12:30:06,spid81,Unknown,There is insufficient system memory in resource pool 'default' to run this query.
11/27/2023 12:30:06,spid81,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_OBJCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 7112 6.95 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_STACKFRAMES (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_STACKFRAMES (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>CACHESTORE_STACKFRAMES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_EXT_GOV_MGR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SECURITY (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_EXTERNAL_GOVERNANCE_AUTHORIZATION_ENGINE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,Error: 28709<c/> Severity: 16<c/> State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing<c/> ETW<c/> notifications etc are skipped.
11/27/2023 12:30:06,spid84,Unknown,There is insufficient system memory in resource pool 'default' to run this query.
11/27/2023 12:30:06,spid84,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_DBLEDGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 272 272.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_DEK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYPROFILE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 256 256.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SLOG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 320 320.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SVL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_FSCHUNKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 48 48.00 kb
11/27/2023 12:30:06,Server,Unknown,Error: 17312<c/> Severity: 16<c/> State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing<c/> ETW<c/> notifications etc are skipped.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_LWC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 32 32.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLLOGPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8376 8.18 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_HADR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 40 40.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SPATIAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 64 64.00 kb
11/27/2023 12:30:06,spid79,Unknown,There is insufficient system memory in resource pool 'default' to run this query.
11/27/2023 12:30:06,spid79,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_FILETABLE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 88 88.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_FSAGENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 24 24.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 264 264.00 kb
11/27/2023 12:30:06,Server,Unknown,Error: 17300<c/> Severity: 16<c/> State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing<c/> ETW<c/> notifications etc are skipped.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_CSILOBCOMPRESSION (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 32 32.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_XTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 11360 11.09 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLTRACE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 4240 4.14 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_BHF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 552 552.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLXP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_FULLTEXT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 296 296.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SNI (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 632 632.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SNI (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SNI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 616 616.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLHTTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 8 8.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLSERVICEBROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1136 1.11 mb
11/27/2023 12:30:06,spid1s,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
11/27/2023 12:30:06,spid1s,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 6300608 6.01 gb<nl/>VM Committed 6736 6.58 mb<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 12232 11.95 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 3656 3.57 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 74112 72.38 mb<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 74112 72.38 mb<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 334720 326.88 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLUTILITIES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 360 360.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE_QUERYVARIANT_DISPATCHERLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 480 480.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE_MESSAGING (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 480 480.00 kb
11/27/2023 12:30:06,spid102,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
11/27/2023 12:30:06,spid102,Unknown,Error: 701<c/> Severity: 17<c/> State: 89.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE_FEEDBACK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 480 480.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE_STATS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 96 96.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE_HASHMAP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 3256 3.18 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_QUERYDISKSTORE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1752 1.71 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLOPTIMIZER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1048 1.02 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLQUERYEXEC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 544 544.00 kb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLQUERYPLAN (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 2232 2.18 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 26040124 24.83 gb<nl/>VM Committed 75776 74.00 mb<nl/>Locked Pages Allocated 499004 487.31 mb<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 1298920 1.24 gb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SQLGENERAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 21920 21.41 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_BITMAP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 2097152 2.00 gb<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 416 416.00 kb<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SOSMEMMANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 91648 89.50 mb<nl/>VM Committed 82624 80.69 mb<nl/>Locked Pages Allocated 8896 8.69 mb<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SOSOS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 256 256.00 kb<nl/>VM Committed 256 256.00 kb<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 2632 2.57 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SOSNODE (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 68304 66.70 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SOSNODE (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 4632 4.52 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_SOSNODE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 63672 62.18 mb
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_HOST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 0 0.00 bytes<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 16 16.00 kb
11/27/2023 12:30:06,spid63,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
11/27/2023 12:30:06,spid63,Unknown,Error: 701<c/> Severity: 17<c/> State: 89.
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 8448 8.25 mb<nl/>VM Committed 8448 8.25 mb<nl/>Locked Pages Allocated 0 0.00 bytes<nl/>SM Reserved 0 0.00 bytes<nl/>SM Committed 0 0.00 bytes<nl/>Pages Allocated 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory node Id = 64 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0 0.00 bytes<nl/>VM Committed 36 36.00 kb<nl/>Locked Pages Allocated 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 61716612 58.86 gb<nl/>VM Committed 338740 330.80 mb<nl/>Locked Pages Allocated 26555140 25.32 gb<nl/>Pages Allocated 25926928 24.73 gb<nl/>Pages Free 45784 44.71 mb<nl/>Target Committed 26894296 25.65 gb<nl/>Current Committed 26893880 25.65 gb<nl/>Foreign Committed 0 0.00 bytes<nl/>Away Committed 0 0.00 bytes<nl/>Taken Away Committed 0 0.00 bytes
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 61716740 58.86 gb<nl/>VM Committed 338776 330.84 mb<nl/>Locked Pages Allocated 26555140 25.32 gb<nl/>Large Pages Allocated 231424 226.00 mb<nl/>Emergency Memory 1024 1.00 mb<nl/>Emergency Memory In Use 16 16.00 kb<nl/>Target Committed 26894336 25.65 gb<nl/>Current Committed 26893920 25.65 gb<nl/>Pages Allocated 25926896 24.73 gb<nl/>Pages Reserved 0 0.00 bytes<nl/>Pages Free 45816 44.74 mb<nl/>Pages In Use 25549648 24.37 gb<nl/>Page Alloc Potential -24 -24.00 kb<nl/>NUMA Growth Phase 2 Steady<nl/>Last OOM Factor 1 AllocationPotential<nl/>Last OS Error 0
11/27/2023 12:30:06,Server,Unknown,MSR-28<nl/>Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 3603464192 3.36 gb<nl/>Available Virtual Memory 140669443641344 127.94 tb<nl/>Available Paging File 8708296704 8.11 gb<nl/>Working Set 214106112 204.19 mb<nl/>Percent of Committed Memory in WS 100 <nl/>Page Faults 118870 <nl/>System physical memory high 1 true<nl/>System physical memory low 0 false<nl/>Process physical memory low 1 true<nl/>Process virtual memory low 0 false
11/27/2023 12:30:06,Server,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 2
November 28, 2023 at 10:06 pm
That is a lot of "insufficient memory" errors... any chance that the box hosting SQL Server is running out of memory?
Failing that, any chance that your service broker has a TON of open conversations that need to be cleaned up before you can drop the service? If so, might not hurt to close some of those conversations before dropping the service. If service broker can be shut down temporarily, that could also help with the cleanup of services.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 28, 2023 at 11:54 pm
Box has 32GB, 26GB allocated to SQL Server. This was the only active process on the box. The service that feeds the broker was stopped. It did this on 2 different servers, both 2022 CU10. Altering the DB to set Disable_Broker, just hangs and tells me it's blocked by a spid that doesn't exist. Is there a good article on how to close converstions that may have been somehow let open when the application service was shut down?
November 29, 2023 at 3:02 pm
did you have a look at "Troubleshooting Service Broker (SSB)"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 29, 2023 at 4:08 pm
I already had those queries, but it reminded me of something so I did some additional poking around and found the issue, I think. There are 141 million rows in sys.conversation_endpoints for the service I'm trying to delete.- I need to go clean those up. Serves me right for believing the Devs when they swear they aren't using the service.
Thanks for the help everyone!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply