how to diagnose the root problem of a sql crash?

Posted on 2011-10-13
Last Modified: 2012-05-12
how will you go from a event viewer crash report like the below?
Question by:25112
    LVL 5

    Author Comment

    error :
    Faulting application name: sqlservr.exe, version: 2007.100.4064.0, time stamp: 0x4d6bf2d4
    Faulting module name: unknown, version:, time stamp: 0x00000000
    Exception code: 0xc0000005
    Fault offset: 0x0000000492ab0052
    Faulting process id: 0x10b4
    Faulting application start time: 0x01cc84025f483ca2
    Faulting application path: E:\Program Files\Microsoft SQL Server\MSSQL10.SIP002\MSSQL\Binn\sqlservr.exe
    Faulting module path: unknown
    Report Id: b951d0cf-f473-11e0-88bb-001517aeed8e

    Open in new window

    LVL 25

    Expert Comment

    Any more details?
    LVL 23

    Accepted Solution

    > Collect as much information as possible at the time of crash: isolate all events in the event viewer at the time of crash
    > Read the SQL Server error logs at the time of crash
    > Try to analyze the system dump if you had a blue screen

    Hope this helps...
    LVL 15

    Assisted Solution

    check your windows error log and sql server error log you will get clues from there.
    LVL 5

    Author Comment

    this is the only error in the application part of the event viewer.. it is on a cluster.. so as soon as it crashed, it failed over and that is the next event in the viewer..

    sql logs had nothing.. that is why it is puzzling..

    the above error has not clues by itself, right?
    LVL 25

    Assisted Solution

    Do all the server has same version, patch, service pack of sql server and os?
    When the server moved to secondary node in the cluster, does it failed back? And how long it was on the primary node from where it failed?
    Did something happend or something new was running during the time when it failed?
    Did you fail it back to its original node and was it able to rest there in peace?
    LVL 5

    Author Comment

    thanks for the clues.. we'll watch it more closely next time

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Database restore 8 47
    How to script out data export 36 57
    Quick and High level SQL Server 2012 Performance check 8 36
    sql sproc 2 23
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now