How to get CPU usage & Memory consumed by particular service in powershell script

Question

I want to find performance of single process, as example "MSSQLSERVER"

Which commands I should write to find out 2 things:

I have found command to get service, but not able to get CPU & RAM usage.

Thanks for advise mate, I know that way, actually I want to get performance of another service, SQLServer is taken as example here (mentioned in question) I want to achieve this using power shell only. — AK47
– AK47, Commented Jun 12, 2014 at 8:41

Mohammad Nadeem · Accepted Answer · 2014-06-11 08:05:12Z

3

Get-Process -Name sqlservr | Select-Object ProcessName, CPU, PM

answered Jun 11, 2014 at 8:05

Mohammad Nadeem

9,44214 gold badges60 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Loïc MICHEL · Accepted Answer · 2014-06-11 08:18:55Z

0

as @vonPryz has suggested you may be interrested to use the performance counters. Here is a starting point :

find all the counterset related to sql Get-Counter -ListSet "*" | ?{ $_.countersetname -match "sql"} | select -Unique countersetname
pick a set from the list above and run get-counter Get-Counter -ListSet "SQLServer:Workload Group Stats" |get-counter -SampleInterval 10 -MaxSamples 3}

answered Jun 11, 2014 at 8:18

Loïc MICHEL

26.3k10 gold badges79 silver badges111 bronze badges