0

On my machine, I have two SQL instances (Instance A and Instance B). If i had only one SQL instance, I could get the resource usage like CPU for example by using the process name i.e

var cpu = new PerformanceCounter("Process", "% Processor Time", myProccessName, true);

However, in case of two SQL instances, although they have two different process ID, the process name for both of them is the same 'sqlserver'

Finding the process ID is easy, how can I use the PerformanceCounter to return the cpu/ram value based on the process ID?

Any other way I can use to get the CPU/RAM usage of all SQL instances installed on the same machine?

Thom A
  • 88,727
  • 11
  • 45
  • 75
San Nabaty
  • 3
  • 2
  • [Performance Counter by Process ID instead of name?](https://stackoverflow.com/q/9115436/7444103) – Jimi Dec 26 '22 at 20:39

0 Answers0