SQl server processors and threads

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: 2 instances / Boost priority
    ... were competing with SQL and you wished for SQL to get priority... ... Unless you are seeing some sort of problem, I would not boost the priority.. ... Wayne Snyder, MCDBA, SQL Server MVP ... "Thomas Wrobel" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Runiing an EXE from an Agent Job
    ... Yes I am looking for a way to lower the priority. ... What I'm really looking for here is whether SQL Server is somehow protecting ... If this is not the case then I am looking for advice from people that have ... What Can I do to keep my EXE from causing problems? ...
    (microsoft.public.sqlserver.server)
  • Re: Assigning priority to users or logins
    ... Vyas, MVP (SQL Server) ... There's no such option in SQL Server, nor can you set priority for a ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Yukon: Process Priorities
    ... I don't know about Yukon, but you can achieve this in SQL 2000 as well. ... Ken Henderson's book "The Guru's Guide to SQL Server 2000 Stored ... I would like to assign a low priority to a long batch ...
    (microsoft.public.sqlserver.programming)
  • Programmierer gesucht, Raum Bodensee und Hinterland
    ... SQL Server etc. weiterführt. ... Näherer Informationen auf Anfrage ... Gruß Peter ... Prev by Date: ...
    (microsoft.public.de.sqlserver)