MSAS2008Memory - WMI sample in VBScript

The foundations for Manageability in Windows 2019/2012/2008/ and Windows 10/8/7/Vista/XP are 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.

On this site, you can find many WMI samples.

The MSAS2008Memory WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

MSAS2008Memory

Example(s)

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * From Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Memory")

For Each objItem in colItems
	WScript.Echo "AggCacheKB:" & objItem.AggCacheKB
	WScript.Echo "AggregationMapFiles:" & objItem.AggregationMapFiles
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "CleanerBalancePersec:" & objItem.CleanerBalancePersec
	WScript.Echo "CleanerCurrentPrice:" & objItem.CleanerCurrentPrice
	WScript.Echo "CleanerMemoryKB:" & objItem.CleanerMemoryKB
	WScript.Echo "CleanerMemorynonshrinkableKB:" & objItem.CleanerMemorynonshrinkableKB
	WScript.Echo "CleanerMemoryshrinkableKB:" & objItem.CleanerMemoryshrinkableKB
	WScript.Echo "CleanerMemoryshrunkKBPersec:" & objItem.CleanerMemoryshrunkKBPersec
	WScript.Echo "Description:" & objItem.Description
	WScript.Echo "DimensionIndexHashFiles:" & objItem.DimensionIndexHashFiles
	WScript.Echo "DimensionPropertyFiles:" & objItem.DimensionPropertyFiles
	WScript.Echo "DimensionStringFiles:" & objItem.DimensionStringFiles
	WScript.Echo "FactAggregationFiles:" & objItem.FactAggregationFiles
	WScript.Echo "FactDataFiles:" & objItem.FactDataFiles
	WScript.Echo "FactStringFiles:" & objItem.FactStringFiles
	WScript.Echo "FilestoreClockPagesExaminedPersec:" & objItem.FilestoreClockPagesExaminedPersec
	WScript.Echo "FilestoreClockPagesHaveRefPersec:" & objItem.FilestoreClockPagesHaveRefPersec
	WScript.Echo "FilestoreClockPagesValidPersec:" & objItem.FilestoreClockPagesValidPersec
	WScript.Echo "FilestoreIOErrors:" & objItem.FilestoreIOErrors
	WScript.Echo "FilestoreIOErrorsPersec:" & objItem.FilestoreIOErrorsPersec
	WScript.Echo "FilestoreKB:" & objItem.FilestoreKB
	WScript.Echo "FilestoreKBReadsPersec:" & objItem.FilestoreKBReadsPersec
	WScript.Echo "FilestoreKBWritePersec:" & objItem.FilestoreKBWritePersec
	WScript.Echo "FilestoreMemoryPinnedKB:" & objItem.FilestoreMemoryPinnedKB
	WScript.Echo "FilestorePageFaultsPersec:" & objItem.FilestorePageFaultsPersec
	WScript.Echo "FilestoreReadsPersec:" & objItem.FilestoreReadsPersec
	WScript.Echo "FilestoreWritesPersec:" & objItem.FilestoreWritesPersec
	WScript.Echo "Frequency_Object:" & objItem.Frequency_Object
	WScript.Echo "Frequency_PerfTime:" & objItem.Frequency_PerfTime
	WScript.Echo "Frequency_Sys100NS:" & objItem.Frequency_Sys100NS
	WScript.Echo "InmemoryAggregationMapFileKB:" & objItem.InmemoryAggregationMapFileKB
	WScript.Echo "InmemoryAggregationMapFileKBPersec:" & objItem.InmemoryAggregationMapFileKBPersec
	WScript.Echo "InmemoryDimensionIndexHashFileKB:" & objItem.InmemoryDimensionIndexHashFileKB
	WScript.Echo "InmemoryDimensionIndexHashFileKBPersec:" & objItem.InmemoryDimensionIndexHashFileKBPersec
	WScript.Echo "InmemoryDimensionPropertyFileKB:" & objItem.InmemoryDimensionPropertyFileKB
	WScript.Echo "InmemoryDimensionPropertyFileKBPersec:" & objItem.InmemoryDimensionPropertyFileKBPersec
	WScript.Echo "InmemoryDimensionStringFileKB:" & objItem.InmemoryDimensionStringFileKB
	WScript.Echo "InmemoryDimensionStringFileKBPersec:" & objItem.InmemoryDimensionStringFileKBPersec
	WScript.Echo "InmemoryFactAggregationFileKB:" & objItem.InmemoryFactAggregationFileKB
	WScript.Echo "InmemoryFactAggregationFileKBPersec:" & objItem.InmemoryFactAggregationFileKBPersec
	WScript.Echo "InmemoryFactDataFileKB:" & objItem.InmemoryFactDataFileKB
	WScript.Echo "InmemoryFactDataFileKBPersec:" & objItem.InmemoryFactDataFileKBPersec
	WScript.Echo "InmemoryFactStringFileKB:" & objItem.InmemoryFactStringFileKB
	WScript.Echo "InmemoryFactStringFileKBPersec:" & objItem.InmemoryFactStringFileKBPersec
	WScript.Echo "InmemoryMapFileKB:" & objItem.InmemoryMapFileKB
	WScript.Echo "InmemoryMapFileKBPersec:" & objItem.InmemoryMapFileKBPersec
	WScript.Echo "InmemoryOtherFileKB:" & objItem.InmemoryOtherFileKB
	WScript.Echo "InmemoryOtherFileKBPersec:" & objItem.InmemoryOtherFileKBPersec
	WScript.Echo "MapFiles:" & objItem.MapFiles
	WScript.Echo "MemoryLimitHighKB:" & objItem.MemoryLimitHighKB
	WScript.Echo "MemoryLimitLowKB:" & objItem.MemoryLimitLowKB
	WScript.Echo "MemoryUsageKB:" & objItem.MemoryUsageKB
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "OtherFiles:" & objItem.OtherFiles
	WScript.Echo "PagePool1AllocKB:" & objItem.PagePool1AllocKB
	WScript.Echo "PagePool1LookasideKB:" & objItem.PagePool1LookasideKB
	WScript.Echo "PagePool64AllocKB:" & objItem.PagePool64AllocKB
	WScript.Echo "PagePool64LookasideKB:" & objItem.PagePool64LookasideKB
	WScript.Echo "PagePool8AllocKB:" & objItem.PagePool8AllocKB
	WScript.Echo "PagePool8LookasideKB:" & objItem.PagePool8LookasideKB
	WScript.Echo "PotentialInmemoryAggregationMapFileKB:" & objItem.PotentialInmemoryAggregationMapFileKB
	WScript.Echo "PotentialInmemoryDimensionIndexHashFileKB:" & objItem.PotentialInmemoryDimensionIndexHashFileKB
	WScript.Echo "PotentialInmemoryDimensionPropertyFileKB:" & objItem.PotentialInmemoryDimensionPropertyFileKB
	WScript.Echo "PotentialInmemoryDimensionStringFileKB:" & objItem.PotentialInmemoryDimensionStringFileKB
	WScript.Echo "PotentialInmemoryFactAggregationFileKB:" & objItem.PotentialInmemoryFactAggregationFileKB
	WScript.Echo "PotentialInmemoryFactDataFileKB:" & objItem.PotentialInmemoryFactDataFileKB
	WScript.Echo "PotentialInmemoryFactStringFileKB:" & objItem.PotentialInmemoryFactStringFileKB
	WScript.Echo "PotentialInmemoryMapFileKB:" & objItem.PotentialInmemoryMapFileKB
	WScript.Echo "PotentialInmemoryOtherFileKB:" & objItem.PotentialInmemoryOtherFileKB
	WScript.Echo "QuotaBlocked:" & objItem.QuotaBlocked
	WScript.Echo "QuotaKB:" & objItem.QuotaKB
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next