August 19, 2009 at 4:32 pm
Hello All,
Is there a max number of concurrent connections for a specific user. I can't seem to find an answer to that one, does anyone know?
I know user connections are at 32,767. But, can 'USER A' concurrently connect 32,767 times?
Any help is greatly appreciated.
Thanks!
August 19, 2009 at 4:39 pm
I know you can limit the total number of concurrent user connections to a max of 32767 but dont believe it can be limited for a specific user.
August 19, 2009 at 4:40 pm
An application runtime like Asp.net can connect concurrently more than 100, 000 depending on your user base.
Kind regards,
Gift Peddie
August 19, 2009 at 4:42 pm
Okay great, thank you both! This application is a simple PHP page that accepts data and inserts it into a DB table. Obviously, it uses the same user for each insert so I wondered if SQL Server wasn't allowing more than X connections from that user.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply