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 |
|
Muhad
Starting Member
1 Post |
 Posted - 2005-12-13 : 06:40:20
|
I am using SQL Server 2000 with current service pack. I am accessing this database from remote sites using ADO. SOMETIMES the connections don't get through and other times the connection gets through very quickly. Other than possible Internet problems it seems that the SQL Server database responds slowly. Is this possible? If so, is there a way to tune up the SQL Server response time? Also how does one determine what kind of computer power is needed?Another question is that when trying to access this database through TWO routers, no connection can be made. Any ideas would be appreciated?Also should the connection string use the DOMAIN name or IP ADDRESS?Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-13 : 08:18:00
|
| The connection should be domain name if possible. It sounds like you have network issues since your access is sporadic and you can't access through two routers. Do you have a network person you can work with on this? YOu're going to need to make sure you have the proper ports open on all sides and the right access enabled between the various segments of the network. What are you seeing in performance monitor and profiler for the SQL Server performance? Have you even looked at these yet to see if you have network errors, are losing packets, what your memory and CPU look like in performance monitor? With Profiler, you can see the performance of the SQL Statements themselves. There are articles on both this site and www.sql-server-performance.com for performance tuning that will walk you through an audit and get you started on tuning the system. Check them out and see how far you can get. We can help you as you go along.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-13 : 10:15:56
|
quote:
Originally posted by Muhad
I am using SQL Server 2000 with current service pack. I am accessing this database from remote sites using ADO. SOMETIMES the connections don't get through and other times the connection gets through very quickly. Other than possible Internet problems it seems that the SQL Server database responds slowly. Is this possible? If so, is there a way to tune up the SQL Server response time? Also how does one determine what kind of computer power is needed?Another question is that when trying to access this database through TWO routers, no connection can be made. Any ideas would be appreciated?Also should the connection string use the DOMAIN name or IP ADDRESS?Thanks.
funny though, i have a similar remote connection, but in this case, with client utility and new remote server registrationI use both domain and IPthough its meant to be a domain, a lot of times it times out, so i create both an IP and domain name connectionsqldb.domain.com and IPafrika |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-13 : 12:16:52
|
That shouldn't speed things up.  If you have a network team, you really should work with them on resolving the issue instead of just putting a local fix in place. Sounds like you might have DNS issues or possibly WINS if you're still using it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-14 : 05:49:37
|
| Dont think so sirthough you are right about the domain name resolution |
|
|
|
|
|
|
|
|
Connection problem