Instance get hanged

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Data Corruption » Instance get hanged

Instance get hanged

Rate Topic

Display Mode

Topic Options

Author

Message

sunny-1090539

Posted Tuesday, May 19, 2009 12:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 29, 2009 3:11 PM
Points: 3, Visits: 85

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..

Post #720087

RP_DBA

Posted Tuesday, May 19, 2009 1:29 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, September 30, 2009 11:37 AM
Points: 53, Visits: 174

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

Post #720121

tosscrosby-60625

Posted Wednesday, May 20, 2009 1:11 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 8:06 AM
Points: 1,888, Visits: 3,349

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.

Regards,

Terry

Post #720843

sunny-1090539

Posted Saturday, May 23, 2009 12:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 29, 2009 3:11 PM
Points: 3, Visits: 85

Hi Terry,
Thanks for your suggestion..

Post #722609

« Prev Topic | Next Topic »

Permissions