Re: SQl server processors and threads



Hi

Look at WMI API's on MSDN.

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

IM: mike@xxxxxxxxxxxx

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

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

"Verve" <mailarps@xxxxxxxxx> wrote in message
news:1125399280.046841.99590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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.
>


.



Relevant Pages

  • Re: executing querys from a batch file
    ... Mike Epprecht, Microsoft SQL Server MVP ... Blog: http://www.msmvps.com/epprecht/ ... >>>Can I execute a query to sql server from a bat file? ...
    (comp.databases.ms-sqlserver)
  • Re: executing querys from a batch file
    ... Mike Epprecht, Microsoft SQL Server MVP ... Blog: http://www.msmvps.com/epprecht/ ... >>>Can I execute a query to sql server from a bat file? ...
    (comp.databases.ms-sqlserver)
  • Re: Thanks Re: Query Analyser Owner, table access
    ... Tibor Karaszi, SQL Server MVP ... http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ ... USE SolutionsNet ...
    (microsoft.public.sqlserver.tools)
  • Re: Question about SQL Server 2005
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> MVP Program: http://www.microsoft.com/mvp ... >> Blog: http://www.msmvps.com/epprecht/ ...
    (microsoft.public.sqlserver.setup)
  • Re: Assigning priority to users or logins
    ... There's no such option in SQL Server, nor can you set priority for a connection. ... Tibor Karaszi, SQL Server MVP ... > would have the last access to resources. ...
    (microsoft.public.sqlserver.server)