• 2017-12-29 14:08:48.83 Server  SQL Server detected 2 sockets with 24 cores per socket and 48 logical processors per socket, 96 total logical processors; using 96 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2017-12-29 14:08:48.83 Server  SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2017-12-29 14:08:48.83 Server  Detected 391874 MB of RAM. This is an informational message; no user action is required.
    2017-12-29 14:08:48.83 Server  Using locked pages in the memory manager.
    2017-12-29 14:08:48.83 Server  Large Page Allocated: 32MB
    2017-12-29 14:08:48.83 Server  Large Page Allocated: 32MB
    2017-12-29 14:08:49.19 Server  Machine supports memory error recovery. SQL memory protection is enabled to recover from memory corruption.
    2017-12-29 14:08:49.97 Server  Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
    2017-12-29 14:08:49.97 Server  Automatic soft-NUMA was enabled because SQL Server has detected hardware NUMA nodes with greater than 8 physical cores.
    2017-12-29 14:08:49.99 Server  Buffer pool extension is already disabled. No action is necessary.
    2017-12-29 14:08:50.02 Server  InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
    2017-12-29 14:08:50.02 Server  Implied authentication manager initialization failed. Implied authentication will be disabled.
    2017-12-29 14:08:50.03 Server  The maximum number of dedicated administrator connections for this instance is '1'
    2017-12-29 14:08:50.03 Server  This instance of SQL Server last reported using a process ID of 4716 at 12/29/2017 2:08:15 PM (local) 12/29/2017 8:08:15 PM (UTC). This is an informational message only; no user action is required.
    2017-12-29 14:08:50.03 Server  Node configuration: node 0: CPU mask: 0x0000000000555555:0 Active CPU mask: 0x0000000000555555: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-12-29 14:08:50.03 Server  Node configuration: node 1: CPU mask: 0x0000555555000000:0 Active CPU mask: 0x0000555555000000: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-12-29 14:08:50.03 Server  Node configuration: node 2: CPU mask: 0x0000000000aaaaaa:0 Active CPU mask: 0x0000000000aaaaaa: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-12-29 14:08:50.03 Server  Node configuration: node 3: CPU mask: 0x0000aaaaaa000000:0 Active CPU mask: 0x0000aaaaaa000000: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-12-29 14:08:50.03 Server  Node configuration: node 4: CPU mask: 0x0000000000555555:1 Active CPU mask: 0x0000000000555555:1. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2017-12-29 14:08:50.03 Server  Node configuration: node 5: CPU mask: 0x0000555555000000:1 Active CPU mask: 0x0000555555000000:1. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2017-12-29 14:08:50.03 Server  Node configuration: node 6: CPU mask: 0x0000000000aaaaaa:1 Active CPU mask: 0x0000000000aaaaaa:1. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2017-12-29 14:08:50.03 Server  Node configuration: node 7: CPU mask: 0x0000aaaaaa000000:1 Active CPU mask: 0x0000aaaaaa000000:1. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2017-12-29 14:08:50.04 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-12-29 14:08:50.04 Server  Lock partitioning is enabled. This is an informational message only. No user action is required.