SQl server processors and threads

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Verve - 30 Aug 2005 11:54 GMT

Hi,
I have an application where I need to find out about the following
information regarding SQL server:

Processors enabled
i. Threads allocated
ii. Priority

Can somebody throw some light on this. How are the processors related
to the threads running and the priority is w.r.t. what?

Thanks,
Verve.

Reply to this Message

Mike Epprecht (SQL MVP) - 30 Aug 2005 19:54 GMT

Hi

Look at WMI API's on MSDN.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> Hi,
> I have an application where I need to find out about the following
[quoted text clipped - 9 lines]
> Thanks,
> Verve.

Reply to this Message