Monitor CPU load of DB Server

Ignition
1

Is there a good way to monitor the CPU load of my database server? I just recently moved my DB to another server previously hosted on the same server has Ignition. I would like setup a tag to contain and monitor the CPU load. DB server is Windows Server 2019.

2

I think I got it. I will use a system.util.execute() function in a gateway script to invoke

wmic /node:<ip address> cpu get deviceid, name, numberofcores, maxclockspeed, status, loadpercentage

which will return info to be parsed and written to tags.

def cpuLoad():
	import subprocess
	proc = subprocess.Popen(['powershell.exe', "wmic /node:<ipaddr> cpu get loadpercentage"], stdout=subprocess.PIPE, stderr=subprocess.STDOUT)
	output = proc.stdout.read()
	print output	
cpuLoad()