Win32_PerfRawData_MSSQLServerOLAPService powershell sample code

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_PerfRawData_MSSQLServerOLAPService WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

Sample Code

$strComputer = "."

$objWMi = get-wmiobject -computername localhost -Namespace root\CIMV2 -Query "Select * from Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Cache"

foreach ($obj in $objWmi)
{
	write-host "Caption:" $obj.Caption
	write-host "Currententries:" $obj.Currententries
	write-host "CurrentKB:" $obj.CurrentKB
	write-host "Description:" $obj.Description
	write-host "Directhitratio:" $obj.Directhitratio
	write-host "Directhitratio_Base:" $obj.Directhitratio_Base
	write-host "DirecthitsPersec:" $obj.DirecthitsPersec
	write-host "EvictionsPersec:" $obj.EvictionsPersec
	write-host "Frequency_Object:" $obj.Frequency_Object
	write-host "Frequency_PerfTime:" $obj.Frequency_PerfTime
	write-host "Frequency_Sys100NS:" $obj.Frequency_Sys100NS
	write-host "InsertsPersec:" $obj.InsertsPersec
	write-host "KBaddedPersec:" $obj.KBaddedPersec
	write-host "LookupsPersec:" $obj.LookupsPersec
	write-host "MissesPersec:" $obj.MissesPersec
	write-host "Name:" $obj.Name
	write-host "Timestamp_Object:" $obj.Timestamp_Object
	write-host "Timestamp_PerfTime:" $obj.Timestamp_PerfTime
	write-host "Timestamp_Sys100NS:" $obj.Timestamp_Sys100NS
	write-host "Totaldirecthits:" $obj.Totaldirecthits
	write-host "Totalevictions:" $obj.Totalevictions
	write-host "Totalfilterediteratorcachehits:" $obj.Totalfilterediteratorcachehits
	write-host "Totalfilterediteratorcachemisses:" $obj.Totalfilterediteratorcachemisses
	write-host "Totalinserts:" $obj.Totalinserts
	write-host "Totallookups:" $obj.Totallookups
	write-host "Totalmisses:" $obj.Totalmisses
	write-host
	write-host "########"
	write-host
}