application hangs

Question

application hangs

agnes.mosumo

SSC Journeyman

Points: 85
More actions
June 10, 2009 at 2:33 am

#73717

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

Viewing 7 posts - 1 through 6 (of 6 total)

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

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

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

[font="Verdana"]Markus Bohse[/font]

WayneS SSC Guru Points: 95461 More actions · Answer 2

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
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

joeroshan SSChampion Points: 10377 More actions · Answer 3

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[/url]

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 4

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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, MVP, M.Sc (Comp Sci)
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

GSquared SSC Guru Points: 260824 More actions · Answer 6

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