application hangs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » application hangs

application hangs

Rate Topic

Display Mode

Topic Options

Author

Message

agnes.mosumo

Posted Wednesday, June 10, 2009 2:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 31, 2009 8:23 AM
Points: 1, Visits: 9

application hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.

Post #732091

MarkusB

Posted Wednesday, June 10, 2009 3:15 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218, Visits: 3,874

agnes.mosumo (6/10/2009)

application hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.

Do you really expect us to help you with this little information ???

Markus Bohse

Post #732099

WayneS

Posted Wednesday, June 10, 2009 5:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 6,367, Visits: 8,227

Is this the application that is connecting to the sql 2000 database that is hanging, or is this that sql 2000 is hanging when the application connects to it?

We are going to need more information, as well as error messages (which might me in logs) in order to be able to help you.

You also might want to google the error messages you are receiving.

BTW, you posted this in the SQL 2005 forum; it seems like it should have been in the SQL 2000 forum.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #732136

joeroshan

Posted Wednesday, June 10, 2009 5:22 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:45 AM
Points: 572, Visits: 1,157

Yes try to give more info if possible.

By the way if you need something to start with, Use activity monitor for blocking, use system monitor and sql profiler to know whats going on

-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups

Post #732140

Grant Fritchey

Posted Wednesday, June 10, 2009 6:06 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 13,371, Visits: 25,144

Bare, bare, bare minimum, run sp_who2 to see if you have blocked processes. From there, you need to delve into all the skills of troubleshooting and investigation. Without at least the ability to collect data on what's occuring on your system you won't be able to post questions here, let alone fix your machine.

As others have said, spend time with performance monitor and setting up server-side traces through profiler in order to gather data.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #732162

GilaMonster

Posted Wednesday, June 10, 2009 8:11 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 37,650, Visits: 29,901

Hmmm. Could be literally anything from the app to the client machine' hardware to the network to the database and beyond. Really, there's absolutly no way of telling what's wrong with that little info. It's like calling a car mechanic and saying "My car won't start, what's the problem?"

Start by investigating if there's a commonality between the hangs. Is it always the when the same piece of the app is being run. Is it always the same time of the day?
Does the application hang on all client machines? Only on one?
etc, etc

There's a lot of investigation that you need to do first to pinpoint where the problem is coming from.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #732320

GSquared

Posted Wednesday, June 10, 2009 9:45 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

agnes.mosumo (6/10/2009)

application hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.

I recommend making it so that doesn't happen any more. Most people don't like itermittently hung applications.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #732411

« Prev Topic | Next Topic »

Permissions