Hi:
If you do not have enough connections, it might be a good idea for you to start using MTS (Microsoft Transaction Server). It will help optimize the usage of your connections and any other objects you may have. Request for SQL server processing is put into a queue in all connnections or busy. This way you will be able to handle a much bigger traffic.

Hope that this will help!

Raphael Joseph
rjoseph@rjcinfo.com