SQL Powershell Script To Check the Memory Utilization

• Raushan Srivastava

  Old Hand

  Points: 391

  More actions

  October 26, 2013 at 5:50 pm

  #284352

  Comments posted to this topic are about the item SQL Powershell Script To Check the Memory Utilization

• renzo.sotgia 35567

  SSC Enthusiast

  Points: 111

  More actions

  October 28, 2013 at 4:30 am

  #1661890

  hi, getting error

  Get-WmiObject : Cannot bind argument to parameter 'Class' because it is null.

  At C:\Query\Check the Memory Utilization.ps1:4 char:21

  + $Size=(get-wmiobject <<<< -ComputerName $args[0] Win32_PhysicalMem

  ory| Measure-Object -Property Capacity -Sum).Sum/1gb

  + CategoryInfo : InvalidData: (:) [Get-WmiObject], ParameterBindi

  ngValidationException

  + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,M

  icrosoft.PowerShell.Commands.GetWmiObjectCommand

  Total RAM : GB

  The term 'get-counter' is not recognized as the name of a cmdlet, function, scr

  ipt file, or operable program. Check the spelling of the name, or if a path was

  included, verify that the path is correct and try again.

  At C:\Query\Check the Memory Utilization.ps1:9 char:12

  + get-counter <<<< -COMP $args[0] -Counter "\Memory\Available MBytes" -Sample

  Interval 1 -MaxSamples 30 | select -ExpandProperty countersamples | Select-Ob

  ject timestamp, @{Name="AvailableMemory(MB)";Expression={"{0,9:#,#.000}" -f [ma

  th]::round($_.CookedValue, 3) }},@{Name="UsedMemory(MB)";Expression={"{0,9:#,#.

  000}" -f [math]::round($value- $_.CookedValue, 3) }}, @{Name="MemoryUtilization

  (%)";Expression={"{0,9:#,#.000}" -f [math]::round(($value-$_.CookedValue)*100/$

  value, 3) }}

  + CategoryInfo : ObjectNotFound: (get-counter:String) [], Command

  NotFoundException

  + FullyQualifiedErrorId : CommandNotFoundException

• Lee Linares

  SSCrazy

  Points: 2730

  More actions

  October 28, 2013 at 8:34 am

  #1661995

  I also get the same error.

  Lee

• SQL_ME_RICH

  SSChampion

  Points: 11200

  More actions

  January 16, 2014 at 1:54 pm

  #1680855

  You have to specify your HOSTNAME, or you will get that error.

  However - even when I do specify mine, I still get the 'The term 'get-counter' is not recognized as the name of a cmdlet, function, script file, or operable program', but it does give me a total RAM reading.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  April 27, 2016 at 2:06 pm

  #1875081

  Another good script Raushan.