SQL over ISDN

[Lavey]

Hi guys,
We are running 50 clients over ISDN routers using tcpip to a 2000 server running msql 2000.
We are experiencing massive bills generated from the server side of the system even though the call is only initiated from the client end. It looks as though these clients could be leaving the connections to the server open.
Can anybody explain why the sql server would initiate these calls ?

Thanks in advance for any input

____________________________________
Eat , Sleep , Live

 

[oublie]

It is possible that the 2000 server has been set up to authenticate users by calling them back. For example for support purposes I will dial in from home to log in the server has my number as a registered administrator so the server will call me back to allow me access to the systems using remotely possible. Worth checking this with you SYS Admins.

 

[itsp1965]

There are a few things to consider;
1. Are these users staying connected all day to this server.
2. What exactly are they doing ie running queries, entering data
3. If they are executing queries, whether directly or through an application, are these queries written efficiently

Why I ask is that we had a "power user" who wrote an application that connected to SQL server and although he claimed the reporting function that he created was efficient, it would take a up to 10hrs to run over our ISDN connection. After bringing in a sniffer it was indicated that this report was generating about 100MB worth of traffic
So you may want to analyze the type of traffic that is being generated on a daily basis in order to get a better view of what is causing the high costs you are incurring

 

[Lavey]

thanks itsp, we have checked out the traffic and it lloks like the client end are not killing the connection after the data is polled, we've got the builder in to check it out.. he believes it is an addin that he had wrote in mexico that is the culprit.

Thanks all for your input

____________________________________
Eat , Sleep , Live