Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-02 : 07:19:08
|
| Vinu M writes "We have an application using PB7.0 and SQL Server 2000 as backend. There are approximately 15 users using at the same time. From last 1 week, am facing a problem like the application is hanging if the user starts using and kept idle for some time (like 5 mins ). For eg, if one guy opens item master and retrieved one item and he kept like that with out any change - Just Querry. After some time other users cannot save eventhough the reffered tables are different. I tried to check the LOCKing in the enterprise manager-> Management -> Current Activity. But it will not opens and return an erros says "time out". Can anybody help me how can i solve this . I didnt do any modifications in the DATABASE or the program to have a strange behavior like this. Thanks in Advance and sorry if i explained a lot ... am in a very bad situation " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-02 : 09:36:23
|
| Put this into master and run it from query analyser. It will show blocking and commands.http://www.nigelrivett.net/sp_nrinfo.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Application is hanging ( Client )