Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Determine the # of processors for TSQL??

Author  Topic 

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2007-04-12 : 12:48:07
I'm looking for a command that I could use to determine the # of processors a SQL Server has from TSQL.

The only thing I've found is what Enterprise manager does when you pull up the properties.

exec master..xp_msver N'ProcessorCount', N'ProcessorType'


Would that be the best way to get the info or is there a better way?

Thanks.

jayp369
Starting Member

26 Posts

Posted - 2007-04-12 : 13:00:39
you have the right command

Jay
Go to Top of Page
   

- Advertisement -