Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to flush unused connections in SQL Server7.0

Status
Not open for further replies.

darkradar

Programmer
Jul 20, 2002
78
US
Hi

I want to know How to flush the unused connections
in the SQL Server7.0
In SQL Server clients connect to the server and dump
the data. Once the data dump is over they will be
disconnected automatially. But if any case internet
connection is broken while transfering data to the server,
connection is still existing in the Server. After a certain
amount of time there will be alot of connections inthe
server. Its decreasing the performance of the server.
Till now I am restarting the SQL Manager after every
4 hours. But its not a wise idea to restart server.
Is there any way to flush these unused connections after every 30 mins.???
Any help will be appreciated.

Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top