How many processors

[fleet]

Hi,
Is it possible to know how many physical processors are in a server?
if it is hyper thread or dual core?

how can we solve this?

thanks

Eldad

[Hemoco]

When you open the query builder go to "report builder", open "tables"
You can now add the table "tblprocessor" to your report

You can now select the field that you want to see.
There is one record for each processor.

Pressing the "show report output" will show you the output.
This page gives more information about the processor class : http://msdn.microsoft.com/en-us/library/aa394373(VS.85).aspx

[fleet]

Mate were not not all SQL experts.

Can you either write proper documentation or explain step by step how to do these SQL things?

Cheers mate,

The mates from down under

[Hemoco]

You should be able to find this in table "tblPROCESSOR"