• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

SQl server restarts itself

SQL server reboots itself on different days @ different times.  looking for best ways to check what is going on.  SQL logs shows tlog backup that takes about 2 sec as the last activity each time
0
Nana Hemaa
Asked:
Nana Hemaa
  • 3
  • 2
2 Solutions
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Just to confirm -- the whole server reboots, yes?  (It isn't just the SQL Service that is restarting?)

Is the SQL tlog backup occurring immediately (within seconds) before the server restart?

Does the Windows Application or System Event logs tell you anything just before or just after the SQL restart occurs?  If you are getting a BSoD (Blue Screen of Death), you should have a STOP message appearing in the System event log... or if someone or something is issuing a reboot -- it should also log in the System event log.
0
 
Nana HemaaAuthor Commented:
there is nothing unusual in the application and system event logs .no BSOD .  There is nothing unusual in SQL logs other than  a tlog backup just before the restart.  We have been running this litespeed tlog backup for years and it takes only 2 sec...  Not sure where to start troubleshooting on SQl side since SQL is not throwing any errors.  Any inputs?
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Is there at least a message in the System Event log when it comes up to indicate that the previous shutdown was unexpected?
If there isn't anything in the logs from the application, or from the operating system; lets fall back one more level.  Is this a Virtual Machine?  Or is it a physical server running on server class hardware?  If a VM, is there anything logged by the hypervisor?  If server class physical hardware, anything logged by a DRAC or LILO card or equivalent?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Nana HemaaAuthor Commented:
It is a physical server--old server though.  We are in the process of migrating to a new server.  I am running the profiler to identify if any queries are putting pressure on the server--...to begin the troubleshooting process
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
If something is causing the server to reboot such that it doesn't record an event in SQL or the OS, I'd have a low confidence that it's something happening within SQL, and I'd be looking hard at possibly failing hardware.  
Confirm that the system event log is at least recording a 'the previous shutdown was unexpected' message when the server comes back up?
Is it server class hardware?  Is there any chance there is a server hardware module which might be recording hardware anomalies?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How about the resources? A lack of available resources may have this behavior in Windows machines.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now