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 |
|
kellogg
Starting Member
3 Posts |
 Posted - 2006-10-31 : 05:00:40
|
| HiI am working on a win2003 machine and i'm to connect to a remote sql server using a connection string in my asp pages with the other server's ip.The connection is working, however, establishing the connection takes about 10 seconds(!!) everytime.Have you have encountered something like that?please help me asap...thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-31 : 05:01:36
|
| Is the sql server machine very busy?Peter LarssonHelsingborg, Sweden |
 |
|
|
kellogg
Starting Member
3 Posts |
Posted - 2006-10-31 : 05:05:39
|
| no.. |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-10-31 : 07:06:50
|
| is there any backups occuring , check in your current activity window in the management folder in EM, also check in task manager to see if your CPU usage and available RAM is not maxed out.Your max connections for the server may also be exceeded ! |
|
|
|
kellogg
Starting Member
3 Posts |
Posted - 2006-10-31 : 09:28:04
|
| that sql server is working perfectly fine when we access it from scripts from the same server. The connection is way too slow only when connecting to it from another server by ip address.... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 10:01:14
|
when is it slow?when you open the connection or when you execute the query?is you network latency acceptable?what queries are you running? are they in transactions? Is it SS2k or SS2k5?If it's SS2k it could be because the SQL server DTC (distributed transaction manager) is kicking in to hadle the transaction.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
major problem