Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Sql service entered stopped state in a cluster

Author  Topic 

dbadotell
Starting Member

3 Posts

Posted - 2015-04-21 : 12:28:17
Sql service entered a stopped state on a cluster service and there are no error messages what caused it. This is the only thing we see in the event log

The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s).

This a sql server 2008 r2 with SP2.

And this is what we see in the sql server error log once the server comes up.

2015-04-20 21:59:33.94 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-04-20 21:59:33.94 Server Detected 24 CPUs. This is an informational message; no user action is required.
2015-04-20 21:59:33.94 Server Cannot use Large Page Extensions: lock memory privilege was not granted.
2015-04-20 21:59:34.47 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.
2015-04-20 21:59:34.47 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2015-04-20 21:59:34.49 Server Node configuration: node 0: CPU mask: 0x0000000000fff000:0 Active CPU mask: 0x0000000000fff000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2015-04-20 21:59:34.49 Server Node configuration: node 1: CPU mask: 0x0000000000000fff:0 Active CPU mask: 0x0000000000000fff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2015-04-20 21:59:34.52 spid9s Starting up database 'master'.
2015-04-20 21:59:34.79 spid9s 81 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2015-04-20 21:59:34.80 spid9s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2015-04-20 21:59:34.80 spid9s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2015-04-20 21:59:34.83 spid9s Resource governor reconfiguration succeeded.
2015-04-20 21:59:34.83 spid9s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2015-04-20 21:59:34.83 spid9s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2015-04-20 21:59:34.84 spid9s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2015-04-20 21:59:34.86 spid9s SQL Trace ID 1 was started by login "sa".
2015-04-20 21:59:34.86 spid9s Starting up database 'mssqlsystemresource'.
2015-04-20 21:59:34.88 spid9s The resource database build version is 10.50.4000. This is an informational message only. No user action is required.
2015-04-20 21:59:35.03 spid9s Server name is 'XXX'. This is an informational message only. No user action is required.
2015-04-20 21:59:35.03 spid9s The NETBIOS name of the local node that is running the server is 'XXX'. This is an informational message only. No user action is required.
2015-04-20 21:59:35.03 spid13s Starting up database 'model'.
2015-04-20 21:59:35.18 spid15s A new instance of the full-text filter daemon host process has been successfully started.
2015-04-20 21:59:35.19 Server A self-generated certificate was successfully loaded for encryption.


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-04-21 : 12:34:13
We need to see the previous error log, not the current one. By the way, you need to enabled lock pages in memory, though you'll need to understand why you should and why you shouldn't.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -