Learn how to a build a cloud-first strategyRegister Now


SQL Server Reboots unexpectedly

Posted on 2006-05-31
Medium Priority
Last Modified: 2006-11-18
Don't know if this is a SQL or VB question. I have written a VB6 program which uses ADO 2.7 to produce a report. When the report is run the server reboots(Win Server 2003). The point in the report at which it reboots varies. It seems to be somewhere between 500 and 800 records. The report is executed from a workstation. An XP Pro SP1 workstation always completes the report without crashing the server. The other workstation which is a Win XP pro SP2 causes the server to reboot most of the time(9 out of 10 times). The report is unremarkable. I have much more complex reports running successfully on both of these workstations. I am thinking I should create a profile to see what is happening but I do not have the experitise to write one directed at this problem.
Can anyone offer a direction to go in an effort to solve this problem.

Question by:mpdillon
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16802243
What version of SQL Server, what service pack?
Any relevant entries in the Windows NT Eventlog?
Any relevant entries in the SQL Server ERRORLOG file?
LVL 30

Accepted Solution

nmcdermaid earned 2000 total points
ID: 16803215
A reboot out of the blue often indicates some kind of overheating issue.

Author Comment

ID: 16971074
Turned out that this was the issue. This query caused both processors to exceed 90% and there was an error in the event log about power. HP replaced the backplane and Powersupply.

Featured Post

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.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

810 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