May 15, 2018 at 9:55 pm
I wondered:
- what is spids20s
- I used the link suggested but I don't seem to have access (to own notebook! ) to follow the steps recommended.
Any comments or suggestions much appreciated !
Maybe I need a host machine with more memory ? I have 4GB memory.
2018-05-16 13:10:55.06 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:12:00.97 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:13:06.96 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:14:13.03 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:15:18.77 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:16:24.65 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
May 15, 2018 at 10:45 pm
allan.ford17 - Tuesday, May 15, 2018 9:55 PMI wondered:
- what is spids20s
- I used the link suggested but I don't seem to have access (to own notebook! ) to follow the steps recommended.Any comments or suggestions much appreciated !
Maybe I need a host machine with more memory ? I have 4GB memory.2018-05-16 13:10:55.06 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:12:00.97 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:13:06.96 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:14:13.03 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:15:18.77 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:16:24.65 spid10s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
I managed to increase memory usage allowance .. i changed from 25% to 70% for default pool. I did a notebook restart .. I seem to have this database back and available after these steps.
lots of messages in log file .. assume these are normal type of messages .. ?
2018-05-16 13:53:47.42 Server Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)
Aug 22 2017 17:04:49
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 16299: )
2018-05-16 13:53:47.42 Server UTC adjustment: 9:30
2018-05-16 13:53:47.42 Server (c) Microsoft Corporation.
2018-05-16 13:53:47.42 Server All rights reserved.
2018-05-16 13:53:47.46 Server Server process ID is 4684.
2018-05-16 13:53:47.46 Server System Manufacturer: 'ASUSTeK COMPUTER INC.', System Model: 'X550EP'.
2018-05-16 13:53:47.59 Server Authentication mode is MIXED.
2018-05-16 13:53:47.59 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER01\MSSQL\Log\ERRORLOG'.
2018-05-16 13:53:47.59 Server The service account is 'NT Service\MSSQL$MSSQLSERVER01'. This is an informational message; no user action is required.
2018-05-16 13:53:47.59 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER01\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER01\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER01\MSSQL\DATA\mastlog.ldf
2018-05-16 13:53:47.59 Server Command Line Startup Parameters:
-s "MSSQLSERVER01"
2018-05-16 13:53:48.21 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2018-05-16 13:53:48.21 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2018-05-16 13:53:48.21 Server Detected 3524 MB of RAM. This is an informational message; no user action is required.
2018-05-16 13:53:48.21 Server Using conventional memory in the memory manager.
2018-05-16 13:53:48.53 Server Default collation: Latin1_General_CI_AS (us_english 1033)
2018-05-16 13:53:48.73 Server Buffer pool extension is already disabled. No action is necessary.
2018-05-16 13:54:07.89 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
2018-05-16 13:54:07.89 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
2018-05-16 13:54:29.66 Server The maximum number of dedicated administrator connections for this instance is '1'
2018-05-16 13:54:29.84 Server This instance of SQL Server last reported using a process ID of 9228 at 16/05/2018 1:51:40 PM (local) 16/05/2018 4:21:40 AM (UTC). This is an informational message only; no user action is required.
2018-05-16 13:54:31.38 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2018-05-16 13:54:32.77 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2018-05-16 13:54:36.63 Server In-Memory OLTP initialized on lowend machine.
2018-05-16 13:54:47.81 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2018-05-16 13:54:49.62 Server Query Store settings initialized with enabled = 1,
2018-05-16 13:54:50.08 Server Software Usage Metrics is disabled.
2018-05-16 13:54:51.85 Server CLR version v4.0.30319 loaded.
2018-05-16 13:54:54.37 spid5s Starting up database 'master'.
2018-05-16 13:54:55.46 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2018-05-16 13:54:56.14 spid5s 155 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2018-05-16 13:54:57.12 spid5s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2018-05-16 13:54:57.12 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2018-05-16 13:54:57.13 spid5s Recovery completed for database master (database ID 1) in 2 second(s) (analysis 164 ms, redo 45 ms, undo 773 ms.) This is an informational message only. No user action is required.
2018-05-16 13:55:00.88 spid5s Resource governor reconfiguration succeeded.
2018-05-16 13:55:00.88 spid5s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2018-05-16 13:55:00.95 spid5s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2018-05-16 13:55:02.93 spid5s SQL Trace ID 1 was started by login "sa".
2018-05-16 13:55:03.01 spid5s Server name is 'ASUS_NOTEBOOK\MSSQLSERVER01'. This is an informational message only. No user action is required.
2018-05-16 13:55:03.16 spid20s Starting up database 'msdb'.
2018-05-16 13:55:03.16 spid21s Starting up database 'AdventureWorks2017'.
2018-05-16 13:55:03.16 spid13s Starting up database 'mssqlsystemresource'.
2018-05-16 13:55:03.16 spid22s Starting up database 'foraldb'.
2018-05-16 13:55:03.27 spid23s Starting up database 'WideWorldImporters'.
2018-05-16 13:55:03.84 spid13s The resource database build version is 14.00.1000. This is an informational message only. No user action is required.
2018-05-16 13:55:04.71 spid23s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'WideWorldImporters'. XTP Engine version is 2.11.
2018-05-16 13:55:05.30 spid22s Parallel redo is started for database 'foraldb' with worker pool size [2].
2018-05-16 13:55:05.87 spid22s 4 transactions rolled forward in database 'foraldb' (6:0). This is an informational message only. No user action is required.
2018-05-16 13:55:05.89 spid20s 10 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2018-05-16 13:55:05.99 spid17s A self-generated certificate was successfully loaded for encryption.
2018-05-16 13:55:05.99 spid17s Server is listening on [ 'any' <ipv6> 58560].
2018-05-16 13:55:05.99 spid17s Server is listening on [ 'any' <ipv4> 58560].
2018-05-16 13:55:05.99 spid17s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER01 ].
2018-05-16 13:55:05.99 spid17s Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$MSSQLSERVER01\sql\query ].
2018-05-16 13:55:06.00 Server Server is listening on [ ::1 <ipv6> 57547].
2018-05-16 13:55:06.00 Server Server is listening on [ 127.0.0.1 <ipv4> 57547].
2018-05-16 13:55:06.00 Server Dedicated admin connection support was established for listening locally on port 57547.
2018-05-16 13:55:06.14 spid17s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2018-05-16 13:55:06.14 Server SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
2018-05-16 13:55:06.15 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/asus_notebook:MSSQLSERVER01 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
2018-05-16 13:55:06.15 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/asus_notebook:58560 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
2018-05-16 13:55:07.59 spid21s Parallel redo is started for database 'AdventureWorks2017' with worker pool size [2].
2018-05-16 13:55:07.74 spid5s 0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2018-05-16 13:55:07.74 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2018-05-16 13:55:07.75 spid5s Recovery completed for database msdb (database ID 4) in 3 second(s) (analysis 27 ms, redo 138 ms, undo 1412 ms.) This is an informational message only. No user action is required.
2018-05-16 13:55:07.96 spid5s 0 transactions rolled back in database 'foraldb' (6:0). This is an informational message only. No user action is required.
2018-05-16 13:55:07.96 spid5s Recovery completed for database foraldb (database ID 6) in 3 second(s) (analysis 328 ms, redo 246 ms, undo 1190 ms.) This is an informational message only. No user action is required.
2018-05-16 13:55:07.97 spid5s Parallel redo is shutdown for database 'foraldb' with worker pool size [2].
2018-05-16 13:55:08.01 spid21s 2 transactions rolled forward in database 'AdventureWorks2017' (5:0). This is an informational message only. No user action is required.
2018-05-16 13:55:08.41 spid13s Starting up database 'model'.
2018-05-16 13:55:08.51 spid5s 0 transactions rolled back in database 'AdventureWorks2017' (5:0). This is an informational message only. No user action is required.
2018-05-16 13:55:08.52 spid5s Parallel redo is shutdown for database 'AdventureWorks2017' with worker pool size [2].
2018-05-16 13:55:08.93 spid23s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'WideWorldImporters'. XTP Engine version is 2.11.
2018-05-16 13:55:09.06 spid23s [INFO] HkHostRestoreDb(): Database ID: [7]. Starting redo controller thread on a dedicated scheduler.
2018-05-16 13:55:10.07 spid13s Polybase feature disabled.
2018-05-16 13:55:10.07 spid13s Clearing tempdb database.
2018-05-16 13:55:14.67 spid24s [INFO] Database ID: [7] SetHkTrimLsn: Bootpage HkTrimLSN updated from Old HkTrim LSN: {'00000272:000061F0:0002'}, New HkTrim LSN: {'00000272:000061F0:0002'}.
2018-05-16 13:55:15.41 spid24s [INFO] Database ID: [7]. Deleting unrecoverable checkpoint table row (id: 6).
2018-05-16 13:55:16.54 spid13s Starting up database 'tempdb'.
2018-05-16 13:55:22.15 spid13s The tempdb database has 4 data file(s).
2018-05-16 13:55:22.38 spid25s The Service Broker endpoint is in disabled or stopped state.
2018-05-16 13:55:22.38 spid25s The Database Mirroring endpoint is in disabled or stopped state.
2018-05-16 13:55:23.70 spid25s Service Broker manager has started.
2018-05-16 13:55:41.98 spid24s [INFO] HkCkptLoadInternalEx(): Database ID: [7]. Root file: {02DA6B46-37A5-4FDB-B6F3-71715F906F9F}, watermark: 40, RecoveryLsn: 00000272:000061F0:0002, RecoveryCheckpointId: 7, RecoveryCheckpointTimestamp: 0x10
2018-05-16 13:55:53.90 spid24s [INFO] HkRecoverFromLogOpenRange(): Database ID: [7]. Log recovery scan from 00000272:000061F0:0002 to 00000274:00003000:0001.
2018-05-16 13:55:57.76 spid24s [INFO] HkRedoCloseLastOpenRangeSegment(): Database ID: [7]. Log recovery open segment scan from 00000272:000061F0:0002 to 00000274:00002F98:0001.
2018-05-16 13:55:57.77 spid31s [INFO] redoOpenRangeSegment(): Database ID: [7]. Log recovery open segment scan completed at 00000274:00002F98:0001.
2018-05-16 13:55:57.77 spid31s [INFO] HkPrintUndoRowStats(): Database ID: [7]. Undo Rows Stats. [UndoRowsSeen] = 0, [UndoRowsMatched] = 0, [InsertRowsMatched] = 0, [InsertRowsSeen] = 0, [UndoRowsAborted] = 0
2018-05-16 13:55:58.57 spid5s Recovery completed for database WideWorldImporters (database ID 7) in 50 second(s) (analysis 131 ms, redo 0 ms, undo 82 ms.) This is an informational message only. No user action is required.
2018-05-16 13:56:01.26 spid24s [INFO] ctrlPreProcessUpgradeRecord(): Database ID: [7]. XTP upgrade: Controller found HK_LOP_UPGRADE (2.10 -> 2.11) log record at LSN 00000272:00006200:0002. HK_LOP_TX_SEGMENT LSN: 00000000:00000000:0000.
2018-05-16 13:56:01.26 spid24s [INFO] ctrlPreProcessUpgradeSegment(): Database ID: [7]. XTP upgrade: Controller is waiting for completion of processing of 0 outstanding segment(s) before processing the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:01.26 spid24s [INFO] ctrlPreProcessUpgradeSegment(): Database ID: [7]. XTP upgrade: Controller is waiting for completion of processing of 0 outstanding checkpoints before processing the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:01.26 spid24s [INFO] ctrlPreProcessUpgradeSegment(): Database ID: [7]. XTP upgrade: Controller is waiting for completion of outstanding merges before processing the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:01.26 spid24s [INFO] ctrlPreProcessUpgradeSegment(): Database ID: [7]. XTP upgrade: Controller finished waiting for completion of outstanding checkpoint activities before processing the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:01.26 spid24s [INFO] Database ID: [7]. Controller is waiting for completion of processing of the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:01.26 spid24s [INFO] Database ID: [7]. Controller finished waiting for completion of processing of the upgrade segment (2.10 -> 2.11) at LSN 00000272:00006370:0002.
2018-05-16 13:56:02.51 spid5s Recovery is complete. This is an informational message only. No user action is required.
2018-05-16 13:58:08.84 spid37s Warning: The join order has been enforced because a local join hint is used.
2018-05-16 13:59:06.46 spid9s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 13:59:36.44 spid51 Using 'dbghelp.dll' version '4.0.5'
2018-05-16 14:00:03.76 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2018-05-16 14:00:06.70 spid51 Using 'xplog70.dll' version '2017.140.1000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2018-05-16 14:00:12.29 spid9s Disallowing page allocations for database 'WideWorldImporters' due to insufficient memory in the resource pool 'default'. See 'http://go.microsoft.com/fwlink/?LinkId=510837' for more information.
2018-05-16 14:03:13.10 spid23s Warning: The join order has been enforced because a local join hint is used.
2018-05-16 14:09:24.04 spid53 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2018-05-16 14:09:24.10 spid53 Using 'xpsqlbot.dll' version '2017.140.1000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2018-05-16 14:09:24.95 spid56 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2018-05-16 14:09:25.59 spid56 Using 'xpstar.dll' version '2017.140.1000' to execute extended stored procedure 'xp_regread'. This is an informational message only; no user action is required.
May 18, 2018 at 9:04 am
spid= connection id, usually < 50 are system connection.
About your memory error, it is mentioned in de MS docs Resolve page allocation failures due to insufficient memory when sufficient memory is available
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply