I'm a new SQL PFE and just encountered my first SharePoint installation at a customer site. (The first of many, I'm sure.) I ran some health checks on the SQL Server and noticed 600-700 user connections from the SharePoint account. The SharePoint admins and developers are novice to junior-level, and unfamiliar with connection pooling. I've never worked with SharePoint before and don't know what it's normal behavior is or how connections should be managed by SharePoint.
They indicated the SharePoint system is relatively new and only getting a small amount of use compared to what is expected soon.
SQL Server is handling the load well right now, but if the number of connections grows proportionally to the load, this will become a performance constraint.
1. Is this a normal number of connections for SharePoint?
2. If not, where can the SharePoint staff and myself find a thorough explanation of the principles of SharePoint connection pooling?
View Complete Post