http://www.sqlservercentral.com/blogs/james-sql-footprint/2013/02/21/get-perfmon-data-with-powershell/ Printed 2017/05/29 12:05AM
Get Perfmon data with PowershellSometimes you just want to have a look at the system performance, or you feel tired with log on the server, open the perfmon and configure the performance counter, perhaps you want to run a simple command to get the performance data from remote server, here we have a convenient way check the system performance counter on remote server:
Powershell Command : Get-Counter
However, read the data from Get-Counter is not a easy way, so I wrapped it up with several functions and put them into a powershell module : osperfmon.psm1
you can download it from
Here is the steps to run it
1.Setup the module.
- Download the osperfmon.psm1, Copy it to local drive
- Open powershell window, and import the module
- List the available function
Get-Command -Module osperfmon
2. Get Function detail.
You can get the function help with "Get-Help -detailed", for instance
Get-Help Get-CPUPerf -Detailed
Here is the sample for each function:
Each function has several parameter, like -SortBy, -Top. you can customize it with your demand.
your suggestion and advice are welcomed. thanks