question re process id's

[Guju]

Hi,

Is it normal to have @100 process id's in process info folder?

I noticed that some process don't get deleted once they are finished.

Please advise.

Thanks,

[Danny]

Certainly isn't uncommon. By default SQL will start about 10 processes and
then add processes for normal user activity. However in my experience most
DBAs never use EM to look at processes and locks. They turn to the stored
procedures such as sp_who, sp_who2, sp_lock and so forth.
Danny

"Guju" <gu**@tpg.com.au> wrote in message
news:41********@news.iprimus.com.au...

Hi,

Is it normal to have @100 process id's in process info folder?

I noticed that some process don't get deleted once they are finished.

Please advise.

Thanks,

[Guju]

Danny,

Any reason why process don't die once they are done.

thanks,

"Danny" <is****@flash.net> wrote in message
news:Y0******************@newssvr33.news.prodigy.c om...

Certainly isn't uncommon. By default SQL will start about 10 processes and then add processes for normal user activity. However in my experience most DBAs never use EM to look at processes and locks. They turn to the stored
procedures such as sp_who, sp_who2, sp_lock and so forth.
Danny

"Guju" <gu**@tpg.com.au> wrote in message
news:41********@news.iprimus.com.au...

Hi,

Is it normal to have @100 process id's in process info folder?

I noticed that some process don't get deleted once they are finished.

Please advise.

Thanks,

[Danny]

My assumption is that you are seeing in a nonactive state. Try getting more
detail like running dbcc inputbuffer(spid) and checking to see if cpu and/or
io is increasing.
"Guju" <gu**@tpg.com.au> wrote in message
news:41**********@news.iprimus.com.au...

Danny,

Any reason why process don't die once they are done.

thanks,

"Danny" <is****@flash.net> wrote in message
news:Y0******************@newssvr33.news.prodigy.c om...

Certainly isn't uncommon. By default SQL will start about 10 processes

and

then add processes for normal user activity. However in my experience

most

DBAs never use EM to look at processes and locks. They turn to the
stored
procedures such as sp_who, sp_who2, sp_lock and so forth.
Danny

"Guju" <gu**@tpg.com.au> wrote in message
news:41********@news.iprimus.com.au...

> Hi,
>
> Is it normal to have @100 process id's in process info folder?
>
> I noticed that some process don't get deleted once they are finished.
>
> Please advise.
>
> Thanks,
>
>

[Erland Sommarskog]

[posted and mailed, please reply in news]

Guju (gu**@tpg.com.au) writes:

I noticed that some process don't get deleted once they are finished.

Need to define "finished". This depends on the application design. An
application may opt to make a connection, and stay connected until the
users disconnects.

Also, several client libraries employs connection pooling. This means that
even if the client code calls a disconnect routine, the client library
does not actually disconnect from SQL Server immediately, but clings to
the connection, in case the application would reconnect. This grace
period is typically around 60 seconds. In fact many web applications make
heavy use of this. They connect and disconnect for about every query
they make.

Of course, you may be seeing a real problem, but without further information
it is difficult to say more.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp