What is Instance_name in sysperfinfo table of SQL Server
Instance_name column of [Master].[dbo].[sysperfinfo] table will return values in numeric for the counters specified for a particular Object Name.
Output will be something like 001,002... n [or] 1,2,3 .... n
That is actually representing the number of CPU of the system.
Suppose you have 16 CPU in the environment
It can be findout from
Select * from sys.dm_os_sys_info
Output of the above query will give the server information including virtual memory information and CPU count.
CPU Count = Number of Instances in sysperfinfo table for [instance_name] column.
Hope the above helps
Thanks
