Here is a tip about automated monitoring of the high number of SQL Server connections.
Please read my latest MSSQL Tip: “Automated collection of SQL Server database connections for monitoring“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.