Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

application hangs Expand / Collapse
Author
Message
Posted Wednesday, June 10, 2009 2:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, June 10, 2009 3:15 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
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
Posted Wednesday, June 10, 2009 5:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:40 AM
Points: 6,600, Visits: 8,901
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
Posted Wednesday, June 10, 2009 5:22 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 11:52 PM
Points: 617, Visits: 1,275
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
Posted Wednesday, June 10, 2009 6:06 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:10 AM
Points: 15,726, Visits: 28,131
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
Posted Wednesday, June 10, 2009 8:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 43,002, Visits: 36,158
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
Posted Wednesday, June 10, 2009 9:45 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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 »

Add to briefcase

Permissions Expand / Collapse