I am trying to get info about a performance counter, % Processor Time using T-sql.
I am in my local SQL server which is connected to a few different remote severs. Each window server has a sql server installed.
The linked servers are already created and working fine.
Is there any way to retrieve this information from my local server? any dmv?
I know that I can get some information from sys.dm_os_sys_memory, but what I need is Memory: % processor time