SQL Server Performance Forum – Threads Archive
Current sql server connectionshI how come curent activity shows much more connections than from performance monitor: sql server:general stats: user connections?
should i increase max worker threads if just sometimice 1 day a week
the max user connection goes to 1000?
There are some connections that are internal to SQLServer and not user connections (any below spid 50 on SQL2k) Cheers
Follow your thread athttp://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1766. I am locking this thread. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard