SQL use of processes.

9 Jun 2006 9:01 AM

Simon

Had a look on the site but haven`t really found an answer so hope someone can
point me in the right direction.

Should the calling application kill a SQL process once it has finished. If
not what are the implications in terms of the memory available to the server.

Thanks

Si

9 Jun 2006 9:53 AM

ML

Please elaborate on "kill a SQL process".

If you're referring to a connection used by the application to execute a
process on the server then you only need to close the connection after the
process finishes. With connection pooling the connections are not released
immediately, but eventually they are removed from the pool.

The key here is to open a connection as late as possible and release it as
early as possible.

If this does not answer your question, maybe you could explain what you
actually need a bit more.

ML

---
http://milambda.blogspot.com/

9 Jun 2006 10:00 AM

Simon

Thanks thats as I thought.

We hav a supplier that has created an Application for us, but before I
accept it I need them to look at the way they are connecting to our servers.
In testing with 10 users we had 2000 open processes and the server decided it
didn`t like this and ground to a halt.

Cheers again.

Si

Show quote

"ML" wrote:

> Please elaborate on "kill a SQL process".
>
> If you're referring to a connection used by the application to execute a
> process on the server then you only need to close the connection after the
> process finishes. With connection pooling the connections are not released
> immediately, but eventually they are removed from the pool.
>
> The key here is to open a connection as late as possible and release it as
> early as possible.
>
> If this does not answer your question, maybe you could explain what you
> actually need a bit more.
>
>
> ML
>
> ---
> http://milambda.blogspot.com/

9 Jun 2006 10:05 AM

Omnibuzz

You will have to dispose the connection object at the client end.
It might also be cause of the connection pooling settings.
You may want to go through this discussion topic.

http://www.mcse.ms/message719117.html

--
-Omnibuzz (The SQL GC)

http://omnibuzz-sql.blogspot.com/

Show quote

"Simon" wrote:

> Had a look on the site but haven`t really found an answer so hope someone can
> point me in the right direction.
>
> Should the calling application kill a SQL process once it has finished. If
> not what are the implications in terms of the memory available to the server.
>
> Thanks
>
> Si
>