sql server properties - processors

• Nsh

  SSCommitted

  Points: 1639

  More actions

  September 14, 2006 at 5:33 pm

  #75060

  Hi,

  Using EM - right click local server - properties and then processor tab lists the no. of processors available.

  But through query analyzer - how to get the processor tab information

  Thanks.

   

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  September 14, 2006 at 9:05 pm

  #660571

  You can use master.dbo.xp_msver extended stored procedure to gather cpu count as well as a lot of other details.