Process Info

I have an application that accesses the database using a generic account. I
am seeing a lot of instances of my generic account appearing on the Current
activity >>Process info tab . The status says "sleeping" on all of them.
There any way i could determine which one i the application is still using or
is it safe to kill these processes. In other words i am looking for a good
housekeeping procedure.
Thanks........
mmc,
Unless the performance of your server is suffering (especially memory
starvation), I would leave them alone. If it becomes a problem you
should consult the developers of the application to free their
connections when they are not needed.
Killing connections is not recommended as part of a housekeeping
routine. It smells of bad application design, however I do kill
connections when I need to do a database restore.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mmc wrote:
> I have an application that accesses the database using a generic account. I
> am seeing a lot of instances of my generic account appearing on the Current
> activity >>Process info tab . The status says "sleeping" on all of them.
> There any way i could determine which one i the application is still using or
> is it safe to kill these processes. In other words i am looking for a good
> housekeeping procedure.
> Thanks........