Current sql server connections | SQL Server Performance Forums

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

]]>