Number of worker threads

As far as i know, there are 255 default worker threads. how is it possible t
o
know the number of threads that are currently consumed.The 255 is the max by default but that does not mean you are actually using
that many. Have a look at DBCC SQLPERF(UMSSTATS) to see what each scheduler
is using at that time.
Andrew J. Kelly SQL MVP
"Ramesh" <Ramesh@.discussions.microsoft.com> wrote in message
news:C06B0D03-7993-459D-BE4D-71729A7C2A6D@.microsoft.com...
> As far as i know, there are 255 default worker threads. how is it possible
> to
> know the number of threads that are currently consumed.|||Hi,
Use the OS Performance monitor (Perfmon):-
1. Choose the Performace object "PROCESS"
2. From the counter list select "Thread count"
3. Select the Instance "SQLServr
4. Click 'ADD'
5. See the current running thread value for SQL SERVER IN the status bar of
Perfmon.
Thanks
Hari
SQL Server MVP
"Ramesh" <Ramesh@.discussions.microsoft.com> wrote in message
news:C06B0D03-7993-459D-BE4D-71729A7C2A6D@.microsoft.com...
> As far as i know, there are 255 default worker threads. how is it possible
> to
> know the number of threads that are currently consumed.