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 |
|
WalkerStewart
Starting Member
3 Posts |
 Posted - 2008-08-07 : 03:42:11
|
| Hi,I have a number of clients that are using an application running on Windows 2000 and XP Pro with no problems. One client recently installed an application server which is used by up to 25 users, each one remoting to the application hosted on the 2003 server. A MS SQL 2000 database sp3 is located on a separate 4 processor server.This configuration is being timed out.I have run profiler and a sp_blocker_pss80 and have have identified that the Timeout occurs after users issue 'Select * from ...' on two tables one large, the other enormous. sp_blocker_pss80 reports the block which most times is resolved with no timeout, but once a Timeout occurs all of the users are gradually, over 20 mins, Timed out and the application fails. When this happens they are unable to use the database from the app server.I also have a test PC running XP Pro sp3. On it I have the same version of the application. If this program is used it will release the timeout after which all users on the apps server can then access the database and the application runs.The app server is running MDAC ver 2.82.3959.0 while the XP PC is running MDAC 2.81.1117.0. The DBNMPNTW.DLL is version 2000.086.3959 srv03_sp2.rtm on the app server and 2000.085.1117 xpsp_sp2.rtm onthe test pc.At the point where the time out occurs there are blocks but no active transactions.Could someone point me to either the likely cause of the timeout (is it related to the environment?), or an action that will resolve the timeout? (I've defragmented the indexes and updated the stats but the timeout still occurs.)Many thanks in advance.John |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 23:41:22
|
| You should solve blocking first, that will cause other processes timeout. |
 |
|
|
WalkerStewart
Starting Member
3 Posts |
Posted - 2008-08-11 : 03:44:19
|
| The blockig seems only to timeout on the WI 2003 server. There is no timeout for the application running on the XP PC. |
|
|
|
|
|
|
Timeout using MS 2003 server and remoting