Commerce Server General - Number of processes to the profile database

Author

Number of processes to the profile database

arik

2007-04-17, 7:17 am

Hi

We have cs2002 server with several sites which are using the same profile
resource (one profile database for all sites).

We see in the SQL that the profile Database has many proccesses which are
sleeping (hundreds of processes).

Does each site open its own pool of connections to the database or is it
only the profile global resource who open the connection pool ?

Is this amount of sleeping connection does not influence the preofrmance of
the sql ?

Thanks

arik