December 18, 2017 at 8:57 am
HI Everyone,
I am getting this error on SQL server developer edition 2014 SP2 server .
We have installed the cloudberry service on server ...because we are using this server for keeeping log backup on cloud of around 25 server approx 70 database .
RAM is 16GB
Max memory assign to SQL server is 1024*6 = 6144
--------------------------Error---------------------------------------
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 18052, Severity: -1, State: 0. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 802, Severity: 17, State: 2. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 28709, Severity: 16, State: 19. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Error: 701, Severity: 17, State: 123.
December 18, 2017 at 9:03 am
Quick thought, get a bigger server for the task, the specs are in the laptop range, not production!
😎
What more are you seeing in the SQL Server Error Log and the Windows Event Logs?
December 18, 2017 at 9:09 am
Failed allocate pages: FAIL_PAGE_ALLOCATION 1
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 16:04 Server
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2017-12-15 16:04 Server
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2017-12-15 16:04 Server
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 16:04 Server
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
2017-12-15 16:04 Server
CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 224
2017-12-15 16:04 Server
CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
2017-12-15 16:04 Server
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2017-12-15 16:04 Server
CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 16:04 Server
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2017-12-15 16:04 Server
CACHESTORE_XML_SELECTIVE_DG (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2080
2017-12-15 16:04 Server
USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 152
2017-12-15 16:04 Server
USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1080
2017-12-15 16:04 Server
USERSTORE_OBJPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
2017-12-15 16:04 Server
USERSTORE_SXC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
2017-12-15 16:04 Server
USERSTORE_SXC (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 16:04 Server
USERSTORE_SXC (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2017-12-15 16:04 Server
USERSTORE_QDSSTMT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
2017-12-15 16:04 Server
OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
2017-12-15 16:04 Server
OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
2017-12-15 16:04 Server
OBJECTSTORE_SNI_PACKET (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2017-12-15 16:04 Server
OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 248
2017-12-15 16:04 Server
OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 544
2017-12-15 16:04 Server
OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 16384
VM Committed 16384
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 808
2017-12-15 16:04 Server
OBJECTSTORE_LOCK_MANAGER (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
2017-12-15 16:04 Server
OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- ----------
VM Reserved 16384
VM Committed 16384
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 832
2017-12-15 16:04 Server
OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 16:04 Server
OBJECTSTORE_XACT_CACHE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
2017-12-15 16:04 Server
Buffer Pool Value
---------------------------------------- ----------
Database 0
Simulated 0
Target 32751616
Dirty 0
In IO 0
Latched 0
Page Life Expectancy 0
2017-12-15 16:04 Server
Procedure Cache Value
---------------------------------------- ----------
TotalProcs 0
TotalPages 210
InUsePages 0
2017-12-15 16:04 Server
Global Memory Objects Pages
---------------------------------------- ----------
Resource 395
Locks 104
XDES 32
DirtyPageTracking 4
SETLS 4
SubpDesc Allocators 4
SE SchemaManager 130
SE Column Metadata Cache 129
SE Column Metadata Cache Store 1
SQLCache 202
Replication 2
ServerGlobal 52
XP Global 2
SortTables 3
2017-12-15 16:04 Server
Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 435
Current Max 435
Future Max 435
Physical Max 14265
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
2017-12-15 16:04 Server
Small Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 0
Current Max 0
Future Max 0
2017-12-15 16:04 Server
Remote Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 7132
Current Max 7132
2017-12-15 16:04 Server
Query Memory Objects (default) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 435
Current Max 435
Future Max 435
Physical Max 14265
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
2017-12-15 16:04 Server
Small Query Memory Objects (default) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 0
Current Max 0
Future Max 0
2017-12-15 16:04 Server
Remote Query Memory Objects (default) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 7132
Current Max 7132
2017-12-15 16:04 Server
Optimization Queue (internal) Value
---------------------------------------- ----------
Overall Memory 124682240
Target Memory 43270144
Last Notification 2
Timeout 6
Early Termination Factor 5
2017-12-15 16:04 Server
Small Gateway (internal) Value
---------------------------------------- ----------
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
2017-12-15 16:04 Server
Medium Gateway (internal) Value
---------------------------------------- ----------
Configured Units 4
Available Units 4
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
2017-12-15 16:04 Server
Big Gateway (internal) Value
---------------------------------------- ----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
2017-12-15 16:04 Server
Optimization Queue (default) Value
---------------------------------------- ----------
Overall Memory 124682240
Target Memory 3891200
Last Notification 0
Timeout 6
Early Termination Factor 5
2017-12-15 16:04 Server
Small Gateway (default) Value
---------------------------------------- ----------
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
2017-12-15 16:04 Server
Medium Gateway (default) Value
---------------------------------------- ----------
Configured Units 4
Available Units 4
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
2017-12-15 16:04 Server
Big Gateway (default) Value
---------------------------------------- ----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
2017-12-15 16:04 Server
Memory Pool Manager KB
---------------------------------------- ----------
Reserved Current 0
Reserved Limit 310464
2017-12-15 16:04 Server
Memory Pool (internal) KB
---------------------------------------- ----------
Allocations 149536
Predicted 149536
Private Target 0
Private Limit 0
Total Target 144312
Total Limit 461776
OOM Count 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_CACHE (internal) KB
---------------------------------------- ----------
Allocations 8728
Rate 0
Target Allocations 5904
Future Allocations 0
Overall 121760
Last Notification 2
2017-12-15 16:04 Server
MEMORYBROKER_FOR_STEAL (internal) KB
---------------------------------------- ----------
Allocations 62416
Rate -56
Target Allocations 42256
Future Allocations 0
Overall 121760
Last Notification 2
2017-12-15 16:04 Server
MEMORYBROKER_FOR_RESERVE (internal) KB
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_COMMITTED (internal) KB
---------------------------------------- ----------
Allocations 73944
Rate 0
Target Allocations 50056
Future Allocations 0
Overall 121760
Last Notification 2
2017-12-15 16:04 Server
MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_XTP (internal) KB
---------------------------------------- ----------
Allocations 4448
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 2
2017-12-15 16:04 Server
Memory Pool (default) KB
---------------------------------------- ----------
Allocations 1776
Predicted 30304
Private Target 0
Private Limit 0
Total Target 144312
Total Limit 461776
OOM Count 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_CACHE (default) KB
---------------------------------------- ----------
Allocations 1288
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_STEAL (default) KB
---------------------------------------- ----------
Allocations 488
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_RESERVE (default) KB
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 3800
Future Allocations 28528
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
MEMORYBROKER_FOR_XTP (default) KB
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 3800
Future Allocations 0
Overall 121760
Last Notification 0
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 Server
2017-12-15 16:04 spid56
2017-12-15 16:04 spid56
2017-12-15 16:04 spid54
2017-12-15 16:04 spid54
2017-12-15 16:04 spid53
2017-12-15 16:04 spid53
2017-12-15 16:04 spid38s
2017-12-15 16:04 spid38s
2017-12-15 16:04 spid21s
2017-12-15 16:04 spid21s
2017-12-15 16:04 spid19s
2017-12-15 16:04 spid19s
2017-12-15 16:04 spid54
2017-12-15 16:04 spid54
2017-12-15 16:04 spid53
2017-12-15 16:04 spid53
2017-12-15 16:04 spid56
2017-12-15 16:04 spid56
2017-12-15 17:00 spid29s
2017-12-15 17:00 spid29s
Process/System Counts Value
---------------------------------------- ----------
Available Physical Memory 243150848
Available Virtual Memory 140712946774016
Available Paging File 42139648
Working Set 200814592
Percent of Committed Memory in WS 100
Page Faults 461045
System physical memory high 0
System physical memory low 1
Process physical memory low 1
Process virtual memory low 0
2017-12-15 17:00 spid29s
Memory Manager KB
---------------------------------------- ----------
VM Reserved 23559516
VM Committed 148528
Locked Pages Allocated 0
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 148528
Current Committed 148528
Pages Allocated 74584
Pages Reserved 0
Pages Free 0
Pages In Use 148496
Page Alloc Potential -7392
NUMA Growth Phase 2
Last OOM Factor 1
Last OS Error 0
2017-12-15 17:00 spid29s
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 23559452
VM Committed 148488
Locked Pages Allocated 0
Pages Allocated 74584
Pages Free 0
Target Committed 148480
Current Committed 148488
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
2017-12-15 17:00 spid29s
Memory node Id = 1 KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 20
Locked Pages Allocated 0
Pages Allocated 0
Pages Free 0
Target Committed 24
Current Committed 24
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
2017-12-15 17:00 spid29s
Memory node Id = 64 KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 20
Locked Pages Allocated 0
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6544
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 13014908
VM Committed 33736
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 488
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1008
2017-12-15 17:00 spid29s
MEMORYCLERK_QUERYDISKSTORE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 256
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- ----------
VM Reserved 512
VM Committed 512
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6224
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1128
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- ----------
VM Reserved 6300288
VM Committed 6700
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11232
2017-12-15 17:00 Server
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 456
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
MEMORYCLERK_SNI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
2017-12-15 17:00 Server
2017-12-15 17:00 Server
2017-12-15 17:00 spid29s
MEMORYCLERK_SNI (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
MEMORYCLERK_SNI (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40
2017-12-15 17:00 spid29s
MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
MEMORYCLERK_BHF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
2017-12-15 17:00 spid29s
MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 8832
VM Committed 8832
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
2017-12-15 17:00 spid29s
MEMORYCLERK_XTP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4448
2017-12-15 17:00 spid29s
MEMORYCLERK_HOST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 27120
2017-12-15 17:00 spid29s
MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2432
2017-12-15 17:00 spid29s
MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 29552
2017-12-15 17:00 spid29s
MEMORYCLERK_SOSOS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
2017-12-15 17:00 spid29s
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 5696
VM Committed 5576
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
2017-12-15 17:00 spid29s
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 96
SM Committed 96
Pages Allocated 0
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 200
2017-12-15 17:00 spid29s
MEMORYCLERK_FSAGENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
MEMORYCLERK_FILETABLE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
MEMORYCLERK_XE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2224
2017-12-15 17:00 spid29s
MEMORYCLERK_SPATIAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
MEMORYCLERK_SQLLOGPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2144
2017-12-15 17:00 spid29s
MEMORYCLERK_LWC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2017-12-15 17:00 spid29s
MEMORYCLERK_FSCHUNKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
2017-12-15 17:00 spid29s
CACHESTORE_OBJCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_SQLCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1640
2017-12-15 17:00 spid29s
CACHESTORE_PHDR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_XPROC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_NOTIF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2017-12-15 17:00 spid29s
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2017-12-15 17:00 spid29s
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2017-12-15 17:00 spid29s
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2017-12-15 17:00 spid29s
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
2017-12-15 17:00 spid29s
CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 224
2017-12-15 17:00 spid29s
CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
December 18, 2017 at 9:23 am
What type of hardware are you running this on?
😎
As I mentioned earlier, meager specs for anything in production, further, are you using a dev edition for a production tasks?
December 21, 2017 at 4:32 am
HI ,
We are running this on VMWare ,
windows server 2012 R2 Standard .
We are using this server for monitoring the log shipping and keeping backup on cloud.
December 21, 2017 at 5:58 am
megha.chandak88 - Thursday, December 21, 2017 4:32 AMWe are using this server for monitoring the log shipping
OK, so your using this Developer instance to connect to your production Standard/Enterprise instances to monitor your backup processes?
So as per the Microsoft SQL Licensing guide, you are actually in breach of the guide, as the guide states
A production environment is defined as an environment that is accessed by end-users of an application (such as an Internet website) and that is used for more than gathering feedback or acceptance testing of that application. Other scenarios that constitute production environments include:
ï‚Ÿ Environments that connect to a production database.ï‚Ÿ Environments that support disaster-recovery or backup for a production environment.
ï‚Ÿ Environments that are used for production at least some of the time, such as a server that is rotated into production during peak periods of activity.
So you have breached the guide on the first and second points of the guide.
I suggest you go and upgrade to a fully licensed version of SQL before you get hit by a big fine from Microsoft for none compliance.
December 21, 2017 at 6:06 am
megha.chandak88 - Monday, December 18, 2017 8:57 AMRAM is 16GB
Max memory assign to SQL server is 1024*6 = 6144
As Eirikur already mentioned 16GB of RAM is very low for a SQL server, let alone limiting it to 6GB after that, go get more RAM, and give SQL the majority of it, how much RAM will depend on you profiling the performance when the errors happen and tweaking as needs be.
My guess from leaving 10GB to the OS is that the application is also installed on said server, if so move it to its own dedicated application box and leave SQL to run freely on its own machine.
December 26, 2017 at 11:15 am
Add RAM to the VM. That should be easy. I have no idea what Cloudberry needs, but I'd go to 32GB and preferably 64GB, for the VM with SQL Server getting 24GB+
You might be able to get some idea from Cloudberry of what they need.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply