Monitor CPU Usage of All Running Processes – Part II

‘Objective: To Find the CPU usage of each process that are running on a remote machine

‘Created by : MAK

‘Created Date: Nov 2, 2005

‘Syntax: cscript Listremoteprocess2.vbs machinename

‘Example: cscript Listremoteprocess2.vbs MyMachine

Set objArgs = WScript.Arguments

strComputer =objArgs(0)

Set objWMIService = GetObject(“winmgmts:\\” & strComputer & “\root\cimv2”)

Set colProcesses =

objWMIService.ExecQuery(“Select * from Win32_PerfFormattedData_PerfProc_Process”,,48)

‘   wscript.echo “Computer Name” & “,” & “Process Name” & “,”& “CPU Usage”

For Each objItem in colProcesses

if objItem.Name <> “Idle”  and objItem.Name <> “_Total” then

   wscript.echo strcomputer & “,

   ” & objItem.Name & “,

   “& objItem.PercentProcessorTime

end if

Next

REM Objective: To execute the Listremoteprocess2.vbsfor every server listed in servers.txt

REM Created by: MAK

REM Created by” Nov 2, 2005

REM Usage: Listaprocessremote.bat Allservers.csv

dir %1

if %errorlevel% == 0 goto process

goto delfile

:delfile

del %1

goto process

:process

for /f “tokens=1 delims=&” %%i in (c:\Monitorprocess\Servers.txt)

do cscript/nologo c:\Monitorprocess\Listremoteprocess2.vbs %%i >>%1

goto end

:end

Listaprocessremote.bat myserverprocess.csv

Or

c:\monitorprocess\Listaprocessremote.bat c:\monitorprocess\myserverprocess.csv

ATDBQA, sysdown, 0

ATDBQA, ClusSvc, 0

ATDBQA, cpqnimgt, 0

ATDBQA, cqmgserv, 0

ATDBQA, cqmgstor, 0

ATDBQA, cqmghost, 0

ATDBQA, cpqwmgmt, 0

ATDBQA, ResrcMon, 0

ATDBQA, naPrdMgr, 0

ATDBQA, wmiprvse, 0

ATDBQA, svchost, 0

ATDBQA, msdtc, 0

ATDBQA, sqlservr, 0

ATDBQA, sqlagent, 0

ATDBQA, DWRCS, 0

ATDBQA, locator, 0

ATDBQA, server, 0

ATDBQA, logon.scr, 0

create database MonitorProcesses

go

use MonitorProcesses

go

Create table Processes (

id int identity (1,1) not null,

ServerName varchar(128),

ProcessName varchar(256),

CPU_Usage int not null,

Time datetime constraint currentdate default getdate())

go

Create view Processes_view as

select ServerName,ProcessName, CPU_Usage from Processes

go

use master

go

sp_addlogin ‘procuser’,’B07250BE’,’MonitorProcesses’

go

use MonitorProcesses

go

sp_adduser ‘procuser’

go

sp_addrolemember ‘db_datareader’,’procuser’

go

sp_addrolemember ‘db_datawriter’,’procuser’

go

use MonitorProcesses

go

BULK INSERT MonitorProcesses.dbo.Processes_view

   FROM ‘c:\Monitorprocess\myserverprocess.csv’

   WITH

      (

         FIELDTERMINATOR = ‘,’,

         ROWTERMINATOR = ‘\n’

      )

select * from Processes

select * from Processes where processname like ‘%SQLServr’

Select * from Processes where servername =’ATDBQA’

The result would look similar to that shown below.

Conclusion

This article has illustrated how to monitor the CPU usage of different running processes on different machines, how to collect the information in a database table and automate the import process by scheduling.

» See All Articles by Columnist MAK