QUESTION POSED ON: 07 July 2004 I run an interactive SQL Server 2000 application. It works fine, but when
there was no customer activity (mouse click or keystroke) for 20 to 30 minutes, after that customer tries to continue data input, the applicaton freezes
for 30 seconds and works normally after that.
The OS is Windows XP. I use a VPN to connect to other SQL Servers over the
Web (partial replication). The problem disappears when VPN is off, but
persists when I just don't use replication. Is it possible that SQL
Server reactivates after the lull and is trying to find something over
the VPN?
>
No, your SQL Server is running. My first guess is that your application is disconnecting and the delay that you are seeing is in
the reconnect. You could also possibly have the application disconnecting along with the database configured for auto close.
Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
