SQL Server Performance Forum – Threads Archive
Current sql server connections
hI 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
Twan
Follow your thread athttp://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1766. I am locking this thread. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
]]>