We are running SQL Server 2012 SP1 on Windows Server 2012. The issue we have is that after some time the server automatically reboots.
Checking the logs did not show any errors. When looking into the SQL Server log we find these logsDate
24-5-2014 13:42:47
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.24-5-2014 10:01:18
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 14401 seconds. Working set (KB): 23684, committed (KB): 99988, memory utilization: 23%.24-5-2014 08:01:16
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 7200 seconds. Working set (KB): 29868, committed (KB): 99972, memory utilization: 29%.24-5-2014 07:01:48
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 3632 seconds. Working set (KB): 34376, committed (KB): 100004, memory utilization: 34%.
Searching the internet did not help very much. Most written about this is about server 2003.
The problem occurs frequently depending on the usage.
What steps do I need to take to fix this?
Best Answer
The first message regarding the shutdown means that someone or something has initiated a shutdown of the machine. Take a look at the Windows system logs in Event Viewer for more information. You should look at log events leading up to and just after the shutdown time to look for messages indicated why Windows shutdown.
Is this a relatively newly installed server? If so, have you activated Windows? If not and you've passed the activation grace period this is one potential reason for Windows Server automatically rebooting.