Database connection pool size

The default number of poolable connection is set to 8. You can certainly lower this to 1 connection, but I would not advise this. If you have some slow/long running queries you will be backing up the communication with the database.

As for what license to purchase, I don’t think we can answer that for you. I would suggest contacting your Microsoft SQL Server sales rep and discussing your needs with them.