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
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