How can I check if my DB has enough memory to handle the extra connections for a Max pool size of 200?
That's the short question. Here's the explanation as to why:
I have a sql server 2012 database. I am getting the error:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool
All of the connections are closed immediately, I use con.close or Using Con.
I checked and there were 220 people using the site. And I ran an sp_who after the problem was reported (and had gone away) and there were only 54 items. Not exactly sure how running that tells me anything, but the forum post said to run it.
So I'm thinking maybe I need to up the Max Pool Size=200; in my connection string. However, it says to make sure your DB has enough memory to handle the extra connections.
How would I know that? How can I check if my DB has enough memory to handle the extra connections?