Skip to content

Instantly share code, notes, and snippets.

Created January 13, 2017 14:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/934d6b545db60c11a3c9659924d87a19 to your computer and use it in GitHub Desktop.
Save anonymous/934d6b545db60c11a3c9659924d87a19 to your computer and use it in GitHub Desktop.
# cat /var/opt/mssql/log/errorlog
??2017-01-13 13:36:02.78 Server Microsoft SQL Server vNext (CTP1.1) - 14.0.100.187 (X64)
Dec 10 2016 02:51:11
Copyright (C) 2016 Microsoft Corporation. All rights reserved.
on Linux (Red Hat Enterprise Linux Server 7.0 (Maipo))
2017-01-13 13:36:02.78 Server UTC adjustment: 0:00
2017-01-13 13:36:02.79 Server (c) Microsoft Corporation.
2017-01-13 13:36:02.79 Server All rights reserved.
2017-01-13 13:36:02.79 Server Server process ID is 4116.
2017-01-13 13:36:02.79 Server Logging SQL Server messages in file 'C:\var\opt\mssql\log\errorlog'.
2017-01-13 13:36:02.79 Server Registry startup parameters:
-d C:\var\opt\mssql\data\master.mdf
-l C:\var\opt\mssql\data\mastlog.ldf
-e C:\var\opt\mssql\log\errorlog
2017-01-13 13:36:02.81 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.
2017-01-13 13:36:02.81 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-01-13 13:36:02.81 Server Detected 6260 MB of RAM. This is an informational message; no user action is required.
2017-01-13 13:36:02.81 Server Using conventional memory in the memory manager.
2017-01-13 13:36:02.89 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2017-01-13 13:36:02.99 Server Buffer pool extension is already disabled. No action is necessary.
2017-01-13 13:36:03.09 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
2017-01-13 13:36:03.09 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
2017-01-13 13:36:03.14 Server The maximum number of dedicated administrator connections for this instance is '1'
2017-01-13 13:36:03.14 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.
2017-01-13 13:36:03.15 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.
2017-01-13 13:36:03.15 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.
2017-01-13 13:36:03.16 Server Query Store settings initialized with enabled = 1,
2017-01-13 13:36:03.17 Server In-Memory OLTP initialized on lowend machine.
2017-01-13 13:36:03.21 Server Software Usage Metrics is disabled.
2017-01-13 13:36:03.41 spid5s Buffer pool extension is already disabled. No action is necessary.
2017-01-13 13:36:03.41 spid5s Resource governor reconfiguration succeeded.
2017-01-13 13:36:03.41 spid5s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2017-01-13 13:36:03.42 spid5s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2017-01-13 13:36:03.47 spid5s SQL Trace ID 1 was started by login "sa".
2017-01-13 13:36:03.50 spid5s Server name is 'tgdmead2-sqlser'. This is an informational message only. No user action is required.
2017-01-13 13:36:03.51 spid5s Starting up database 'msdb'.
2017-01-13 13:36:03.51 spid6s Starting up database 'mssqlsystemresource'.
2017-01-13 13:36:03.52 spid6s The resource database build version is 14.00.100. This is an informational message only. No user action is required.
2017-01-13 13:36:03.54 spid6s Starting up database 'model'.
2017-01-13 13:36:03.69 spid17s A self-generated certificate was successfully loaded for encryption.
2017-01-13 13:36:03.69 spid6s Polybase feature disabled.
2017-01-13 13:36:03.69 spid6s Clearing tempdb database.
2017-01-13 13:36:03.70 spid17s Server is listening on [ 0.0.0.0 <ipv4> 1433].
2017-01-13 13:36:03.70 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2017-01-13 13:36:03.70 Server Dedicated admin connection support was established for listening locally on port 1434.
2017-01-13 13:36:03.70 spid17s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2017-01-13 13:36:04.01 spid6s Starting up database 'tempdb'.
2017-01-13 13:36:04.25 spid6s The tempdb database has 1 data file(s).
2017-01-13 13:36:04.25 spid20s The Service Broker endpoint is in disabled or stopped state.
2017-01-13 13:36:04.25 spid20s The Database Mirroring endpoint is in disabled or stopped state.
2017-01-13 13:36:04.26 spid20s Service Broker manager has started.
2017-01-13 13:36:04.28 spid5s Recovery is complete. This is an informational message only. No user action is required.
2017-01-13 13:41:09.85 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2017-01-13 13:41:09.88 spid51 Using 'xplog70.dll' version '2016.140.100' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2017-01-13 14:27:31.99 spid52 Using 'dbghelp.dll' version '4.0.5'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment