SQL Server Performance

A basic question

Discussion in 'Getting Started' started by vaddi, Feb 20, 2007.

  1. vaddi New Member

    Hello

    This might be a basic question.

    How can find out the number of CPU's used by the SQL Server.

    Thanks
  2. MohammedU New Member

    Check the run_value from the output of the following proc...

    exec sp_configure 'max degree of parallelism'


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. vaddi New Member

    Thank you Mohammed.

    But for all the servers , its showing me the Value '0' ( Zero).

    I want the total number of CPU's present in the Server .

    Do I need to enable anything .

    Thanks
  4. sql_er New Member

    I think that the following might help:

    In the Enterprise Manager, right click on the server instance - choose Properties - choose Processor tab.
  5. Luis Martin Moderator

    Or run Performance Monitor.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  6. vaddi New Member

    Thanks for the replies. I have done it accordingly and got the values.

    Thanks
  7. MohammedU New Member

    exec sp_configure 'max degree of parallelism' returns number of processors used by sql server but I forgot to mention when it returns zero sql uses all processors...

    To get all processors you can use the following too...

    exec xp_msver 'ProcessorCount'


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page