Is it possible to find CPU count information and CORE count information in the Spotlight Repository database for a monitored SQL server?
Which Statistic_name (or ID) and Statistic_class (or ID) do they belong to in the table [SpotlightStatisticsRepository].[dbo].[spotlight_perfdata] ?
You can get this data from the ProcessorDetails Windows collection by executing the following stored procedure in the SSR database
@start_date = N'1 jan 2012',
@end_date = N'1 jan 2013',
@domain_name_list = 'DSHOST:3843',
@monitoredobject_list = 'host1,host2,host3',
@table_name = 'ProcessorDetails',
@column_list = 'numcpus'
Where DSHOST is the host that the Diagnostic Server is installed on, and host1, host2, host3 are the names of the hosts they want the data for.
The numcpus actually returns the number of cores in each host and the number of rows for each host is the number of physical CPUs.