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

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -