SQL Server Reboots unexpectedly

Posted on 2006-05-31
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 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    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

    A reboot out of the blue often indicates some kind of overheating issue.

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how the fundamental information of how to create a table.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now