I am using SQL Server 2008 Enterprise + C# + ADO.Net + .Net 3.5. I am using sp_who2 or sys.dm_exec_connections to find active connections numbers (let me know if my method to find active connection numbers are wrong). For some heavy database consumer application, I can find even active connection count > 1000.
I am wondering whether there are any upper bound limitations of active connection numbers of SQL Server?
thanks in advance, George
See Question&Answers more detail:os