InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:15:43 GMT20http://www.sqlservercentral.com/Forums/Topic732091-5-1.aspx[quote][b]agnes.mosumo (6/10/2009)[/b][hr]application hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.[/quote]I recommend making it so that doesn't happen any more. Most people don't like itermittently hung applications.Wed, 10 Jun 2009 09:45:52 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspxHmmm. 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, etcThere's a lot of investigation that you need to do first to pinpoint where the problem is coming from.Wed, 10 Jun 2009 08:11:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspxBare, 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.Wed, 10 Jun 2009 06:06:15 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspxYes 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 onWed, 10 Jun 2009 05:22:25 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspxIs 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 [b]SQL 2005[/b] forum; it seems like it should have been in the [b]SQL 2000[/b] forum.Wed, 10 Jun 2009 05:08:26 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspx[quote][b]agnes.mosumo (6/10/2009)[/b][hr]application hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.[/quote]Do you really expect us to help you with this little information ???Wed, 10 Jun 2009 03:15:41 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic732091-5-1.aspxapplication hangs on sql 2000 database which is running on windows 2003 server; this happens intermittetly.Wed, 10 Jun 2009 02:33:15 GMTagnes.mosumo