Application is hung

Hello Friends,
A user is calling stating that their application is hung - sitting with an hour glass or with the browser not responding. Assume you know the server and the instance and that the server supports multiple instances.

You need to determine if the database could be contributing to the problem or could be the cause of the problem. Describe at a high level what process you would follow to rule the database out or in as the problem.

Any idea!

Thanks,
FrankHello Friends,
A user is calling stating that their application is hung

I'll leave that alone....|||Hello Friends,
A user is calling stating that their application is hung - sitting with an hour glass or with the browser not responding. Assume you know the server and the instance and that the server supports multiple instances.

You need to determine if the database could be contributing to the problem or could be the cause of the problem. Describe at a high level what process you would follow to rule the database out or in as the problem.

Any idea!

Thanks,
FrankAsk your instructor or TA which help desk you should call for that kind of problem on these servers?

-PatP|||I'll leave that alone....Now pay attention! They are claiming that their application is hung. That is a different kind of issue, not bragging!

-PatP|||Didn't your sweetie in high school used to call you her applicator?

..damn this is more corral stuff...

Any good question lately?

Oh, and btw, it's never the database...|||High level ... hmmm ... do a hard reset on the application server! If the problem goes away it's the application. If that fails, do a hard reset on the database server. If the problem goes away, the application caused the problem to appear on the database server. If the problem still exists, press the red button in the server room and switch over to the generators.

;)|||Now pay attention! They are claiming that their application is hung. That is a different kind of issue, not bragging!

-PatP
No brag ... just fact!

Application goes slow or not responding after few transaction

Dear all viewer ,

Thanks to everyone.

We are using -
MSSQL Server 2000 on windows 2000 advanced server.
PB 7.0 for client server front end tools.

Prior to few days our application works fine, rightnow it get slow or not responding after few (4/5) transaction. We don't know wht it is, If anyone has same experience so that is helpfull for us.

Thanks

R.MallMonitor your activity with SQL Profiler.|||Thanks for reply

How I can do it? Can you give me step by step methods?

R.Mall|||SELECT Profiler
FROM BooksOnline

or

SELECT Consultant
FROM YellowPages|||Thanks for right suggession, I will do it.

Thanks|||I wonder if he actually did that? :)

You can also find information about running Profiler from:

www.sql-server-performance.com
www.sqlteam.com
SQL Server 2000 Performance Tuning Technical Manual (Microsoft Press)