Friday, March 9, 2012

processes problem

I have a client using my application written in Delphi with SQL Server. My
log indicates Maximum number of DBPROCESSes already
allocated and I can see that I have 250 sleeping processes in their
SQL Server process information screen. My application is set to
connect 1 times to the database and maintains these connection
persistently while it is running which is basically all the time, so I
cannot explain how it has 250 processes.
Thank you for your help!
VirgilWhat version of SQL Server are you using. SELECT @.@.VERSION
--
HTH
Ryan Waight, MCDBA, MCSE
"Virgil Trasca" <vtrasca@.totalsoft.ro> wrote in message
news:ug0JTnRfDHA.3324@.TK2MSFTNGP11.phx.gbl...
> I have a client using my application written in Delphi with SQL Server. My
> log indicates Maximum number of DBPROCESSes already
> allocated and I can see that I have 250 sleeping processes in their
> SQL Server process information screen. My application is set to
> connect 1 times to the database and maintains these connection
> persistently while it is running which is basically all the time, so I
> cannot explain how it has 250 processes.
> Thank you for your help!
> Virgil
>

No comments:

Post a Comment