SQL Server Performance Forum – Threads Archive

current user connection

how come performance monitor shows less current connections than current activity->&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess info

Did you refresh the current activity? what does the sp_who/sp_who2 says? Bambola.

I think that this is a duplicate… Perfmon won’t show internal SQL Server connections (spids < 50) Cheers
Twan

O!thank you
but if i plan to change max worker threads i do have to take internal connections into acount?

I don’t think so. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Well usually there is around 200 connectins to my server in the morning
and around 800 in the aftennoon i plan to change max worker treads from 255
to 500
what do i monitor to see if performance improved?

Do you see any kind of errors or performance issues on your server? The number of worker threads is not dependent on the no. of connecttions. SQL Server internally pools connections to worker threads. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

My goal is to improver performance http://www.mssqlcity.com/Tips/tipSrvSet.htm this article specificly says:
If the maximum number of the user connections to your SQL Server box is equal to 500, you can set the ‘max worker threads’ options to 500, this can improve SQL Server performance because thread pooling will not be used

Hi there, as always it is a fine balance between allocating resources and sufficient RAM. If you have tons of free RAM then try increasing max worker threads, monitor cpu, paging and cache usage to see what impact this has on your SQL installation Cheers
Twan

I’ve just checked that site, and some of the suggestions they have I’ve had bad experiences with (such as priority boost), so as always beware when making these kinds of changes… Cheers
Twan

Thank you.
I will monitor before and after change so if any problems i will change it back

Changing advanced options for system configuration should be tested thoroughly, if not you’ll see a downtime on SQL Server…. test and trial. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>