Home > Archive > Microsoft SQL Server forum > August 2005 > SQl server processors and threads









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQl server processors and threads
Verve

2005-08-30, 7:24 am

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.

Mike Epprecht \(SQL MVP\)

2005-08-30, 8:24 pm

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/

"Verve" <mailarps@gmail.com> wrote in message
news:1125399280.046841.99590@g44g2000cwa.googlegroups.com...
> 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.
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com