Post reply

Instance get hanged

  • May 19, 2009 at 12:19 pm

    #209540

    HI all,

    If an instance get hanged how can i troubleshoot it without restarting the sql server ,,,how can i fix it.can any one tell me plz..

  • May 19, 2009 at 1:29 pm

    #997224

    Have you checked the physical server to identify what resources (IO, Memory, CPU, etc.) are being consumed?

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • May 20, 2009 at 1:11 pm

    #997845

    If you can log into the physical server, open task manager to gauge what is consuming the resources. If it's SQL and you cannot get in, check the server event logs to see if anything is being raised there. If not, and you have to stop and start the SQL services, you can only hope something is being logged in the SQL server logs. If not, then it may be time to start a profiler session to trap what's going on.

    -- You can't be late until you show up.

  • May 23, 2009 at 12:27 pm

    #999355

    Hi Terry,

    Thanks for your suggestion..

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply