Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 'Switching Off' for no reason!!

Posted on 2012-03-13
6
Medium Priority
?
326 Views
Last Modified: 2012-03-23
Hi there all,

I have a customer with a problem on one of their SQL servers where it keeps swithing off for no reason.

They have three SQL servers - all IBM 3650 rackmount machines with 3 x RAID1 mirrors and running Windows Server 2003 R2 and SQL Server 2005 and it is only this one machine that shows this problem.

We have replaced the hardware using a spare machine that is kept on site for this purpose and the same thing happens, although it did appear to be better for a short period.

All that seems to happen is that the machiine switches off - nothing in the Windows event viewer apart from an 'unexpected shutdown' event - this usually happens sometime during the evening but does happen randomly during the day as well.

From what I can see the O/S and SQL have all updates as does the IBM BIOS.

Would appreciate any pointers as to where I can look next as this is now 2 different servers doing the same thing  but only with this one SQL application - the other 2 SQL servers are working quite happily. I cannot see any obvious hardware fault and the software company for this one application is saying there doesn't seem to be a problem with their side!

Any advice would be welcomed!

Many thanks.
0
Comment
Question by:Miserablegit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 37713564
yes,it is the problem from there side machine,
0
 

Author Comment

by:Miserablegit
ID: 37713582
Hi sqlservr, you think it is a hardware problem then?? I would normally agree but this is the second box doing the same thing and the other 2 SQL servers are running fine!
0
 
LVL 7

Expert Comment

by:Moomin83
ID: 37713796
Hi Miserablegit

Just a couple of questions.
Have you seen it power off? Does it look like the power cord gets pulled or does it give a BSOD?
If you have changed hardware? please specify which hardware was changed, components or complete box?
Last question, have you tried using a completely different power plug, different circuit, different cord etc.?

Regards

Robert
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:Miserablegit
ID: 37713802
Hello Robert,

Not seen it power off - just seen the result afterwards and the server just needs switching on!

We have changed the entire box - server, RAM and disks - total replacement and we have changed power cords and UPS devices it is running from as well - we have even changed the 2 power supplies as well which is why I am not totally convinced it is a hardware issue although on the face of it it does look like one!!!!

I am baffled!!
0
 
LVL 7

Expert Comment

by:Moomin83
ID: 37713838
Truly odd!

Have you checked the BIOS for settings related to temperature and safety shutdown settings when reaching a certain temperature? on the odd chance there is a cable caught in a fan causing it to overheat? Your best chance to solve it is to see how it shuts down. Even if you have to connect a dedicated screen to the server and disable the screen saver and monitor it with a camera if the server is located somewhere where it is not visible to you.

Regards

Robert
0
 
LVL 69

Accepted Solution

by:
Callandor earned 1500 total points
ID: 37714338
If two totally separate machines experience the same shutdown, I would investigate the power being provided to the machines - you may have intermittent power or sags in the voltage.  I use one of these http://www.acscout.com/servlet/StoreFront for monitoring temperature and voltage independently of machines - it creates a log that you can look at to see if there were any events.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question