sql server - MSSQLSERVER Stuck in 'Starting' -
i'm running sharepoint installation on 3 vms , sqlvm can no longer start mssqlserver service. gets stuck @ 'starting' , uses 100% of processor core seems nothing. error log follows:
2017-04-12 11:28:50.86 server microsoft sql server 2014 - 12.0.4213.0 (x64) jun 9 2015 12:06:16 copyright (c) microsoft corporation standard edition (64-bit) on windows nt 6.3 <x64> (build 9600: ) (hypervisor) 2017-04-12 11:28:50.86 server utc adjustment: 1:00 2017-04-12 11:28:50.86 server (c) microsoft corporation. 2017-04-12 11:28:50.86 server rights reserved. 2017-04-12 11:28:50.86 server server process id 4660. 2017-04-12 11:28:50.86 server system manufacturer: 'microsoft corporation', system model: 'virtual machine'. 2017-04-12 11:28:50.86 server authentication mode mixed. 2017-04-12 11:28:50.86 server logging sql server messages in file 'e:\mssql12.mssqlserver\mssql\log\errorlog'. 2017-04-12 11:28:50.86 server service account 'lunet\elsqlservice-svc'. informational message; no user action required. 2017-04-12 11:28:50.86 server registry startup parameters: -d e:\mssql12.mssqlserver\mssql\data\master.mdf -e e:\mssql12.mssqlserver\mssql\log\errorlog -l e:\mssql12.mssqlserver\mssql\data\mastlog.ldf 2017-04-12 11:28:50.86 server command line startup parameters: -s "mssqlserver" 2017-04-12 11:28:51.33 server sql server detected 1 sockets 4 cores per socket , 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on sql server licensing. informational message; no user action required. 2017-04-12 11:28:51.33 server sql server starting @ normal priority base (=7). informational message only. no user action required. 2017-04-12 11:28:51.33 server detected 32765 mb of ram. informational message; no user action required. 2017-04-12 11:28:51.33 server using conventional memory in memory manager. 2017-04-12 11:28:51.47 server default collation: latin1_general_ci_as (us_english 1033) 2017-04-12 11:28:51.53 server maximum number of dedicated administrator connections instance '1' 2017-04-12 11:28:51.53 server instance of sql server last reported using process id of 1612 @ 12/04/2017 10:39:20 (local) 12/04/2017 09:39:20 (utc). informational message only; no user action required. 2017-04-12 11:28:51.53 server node configuration: node 0: cpu mask: 0x000000000000000f:0 active cpu mask: 0x000000000000000f:0. message provides description of numa configuration computer. informational message only. no user action required. 2017-04-12 11:28:51.59 server using dynamic lock allocation. initial allocation of 2500 lock blocks , 5000 lock owner blocks per node. informational message only. no user action required. 2017-04-12 11:28:51.63 spid7s starting database 'master'. 2017-04-12 11:28:51.64 spid7s 1 transactions rolled in database 'master' (1:0). informational message only. no user action required. 2017-04-12 11:28:51.64 spid7s recovery writing checkpoint in database 'master' (1). informational message only. no user action required. 2017-04-12 11:28:51.65 server clr version v4.0.30319 loaded. 2017-04-12 11:28:51.74 server common language runtime (clr) functionality initialized using clr version v4.0.30319 c:\windows\microsoft.net\framework64\v4.0.30319\. 2017-04-12 11:28:51.74 server software usage metrics enabled. 2017-04-12 11:28:51.77 spid7s sql server audit starting audits. informational message. no user action required. 2017-04-12 11:28:51.77 spid7s sql server audit has started audits. informational message. no user action required.
after falling through rabbit hole trying solve issue highly recommend running windows sysinternals process monitor
similar issue. highlighted repeated access corrupt file source of problem.
Comments
Post a Comment