Since I've changed parts of our application to query the database through JSON web services instead of a persistent database connection, I tend to run into the 'Connection limit exceeded' problem more frequently.
Does SA create a new connection for every http-request? And if so, when does it get released?
asked 14 Feb '13, 04:07
Yes, each time you send a HTTP request to the database the server needs to connect to the required database. Your server will have a connection limit defined according to the licensed number of users and/or configuration that you have set for the server.
The connection to the database exists for the duration of the HTTP request. I.e. the connection is established when the HTTP request is received and the connection is dropped/released when the response has been sent back to the client. Note that there may be a small delay (under a second) to actually release the connection after the last byte of the response has been sent.