Solved

SQL is slow over Point to Point T1

Posted on 2008-10-15
1
304 Views
Last Modified: 2012-06-27
Hi
We have a direct full Point to Point T1 connection to another location, everything seems fine File sharing, email over Exchange, I can ping the SQL servers at our other locations with low ping times 96ms or less but when trying to connect to any of our data bases it takes 10 mins or more to make the connection.
0
Comment
Question by:dougr37
1 Comment
 

Accepted Solution

by:
JimNicholson earned 500 total points
ID: 22720464
Had a similar problem a while back.  Setup a new HP server with SQL 2005, moved all the data over from the old server and data access was incredibly slow, file access and everything else was fine though.  Turned out it was the way we had the teamed NIC's configured, while one was configured to 100/Full the other was set at 100/Half, changing the half to full fixed all our problems.  Don't know what you setup is like, just throwiing this out there.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

860 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