Solved

6 second connection delay

Posted on 2008-10-24
2
301 Views
Last Modified: 2012-08-13
I've recently updated my system to XP service pack 3. I am now getting a problem when using Sql server 2000, which is running on a seperate machine.  Everytime I try to open a connection, whether through query analyzer, enterpirse or VB6 - I am getting a 6-8 second delay for the connection to open.  Very annoying.

Help please!
0
Comment
Question by:fenety
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
Comment Utility
Sounds like a DNS timeout issue.  Check the name of the database server by PINGing it after a fresh reboot (i.e. before accessing this server at all).  See if it takes a long time to resolve the name, too.

If it's something else, then a network analyzer would find it rather quickly.  Get Wireshark (www.wireshark.org) and take a network capture while you are experiencing the delay.  Post the PCAP file if you cannot see what might be wrong, and we can review it together.
0
 
LVL 3

Author Closing Comment

by:fenety
Comment Utility
resolved
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now