Our sharepoint database is running on SQL Server 2008 R2. Recently I found the connection from Sharepoint 2010 to database named "Search_Service_Application_xxx_PropertyStore_xxx" have been keep grown and now the total session count are greater 10000. The old connection never be disconnected automatically...
Does anyone know how to limit max number of connections from Sharepoint 2010?
Thanks!!!