Re: Too Many Processes?
From: Aaron Weiker (aaron_at_sqlprogrammer.org)
Date: 02/09/05
- Next message: John Kane: "Re: Freetext Search with Parameter"
- Previous message: Aaron Weiker: "Re: Orphans"
- In reply to: Jeff Haumesser: "Too Many Processes?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 08 Feb 2005 21:33:18 -0500
Jeff Haumesser wrote:
> I have a VB .NET Application accessing a SQL Server 2000. This application
> uses stored procedures extensively to access the data. My question concerns
> the processes on the server. I've been observing 15 - 30 sleeping processes
> running just after starting my application. Many of these are due to my
> stored procedures. Should I be seeing this just from opening my
> application? I've been closing my connections after executing any data
> access code, as well as closing my objects. Any suggestions or comments
> would be appreciated regarding this.
As long as you are correctly closing AND disposing of your objects when
you are done with them you will be fine. The default nature of
connection pooling will keep the connections open for a while until they
haven't been used for a while and then close the connection.
If you are just closing the objects when you are done with them you
"should" be ok, but it is usually a best practice to always Dispose when
an object implements IDisposable.
-- Aaron Weiker http://aaronweiker.com/ http://www.sqlprogrammer.org/
- Next message: John Kane: "Re: Freetext Search with Parameter"
- Previous message: Aaron Weiker: "Re: Orphans"
- In reply to: Jeff Haumesser: "Too Many Processes?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
