Win32_PerfRawData_MSSQLServerOLAPService perl 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

use Win32::OLE('in');

my $computer = ".";

my $objWMIService = Win32::OLE->GetObject("winmgmts:\\\\$computer\\root\\CIMV2") or die "WMI connection failed.\n";
my $colItems = $objWMIService->ExecQuery("SELECT * FROM Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Cache", "WQL");

foreach my $objItem (in $colItems) {
	print "Caption: $objItem->{Caption}\n";
	print "Currententries: $objItem->{Currententries}\n";
	print "CurrentKB: $objItem->{CurrentKB}\n";
	print "Description: $objItem->{Description}\n";
	print "Directhitratio: $objItem->{Directhitratio}\n";
	print "Directhitratio_Base: $objItem->{Directhitratio_Base}\n";
	print "DirecthitsPersec: $objItem->{DirecthitsPersec}\n";
	print "EvictionsPersec: $objItem->{EvictionsPersec}\n";
	print "Frequency_Object: $objItem->{Frequency_Object}\n";
	print "Frequency_PerfTime: $objItem->{Frequency_PerfTime}\n";
	print "Frequency_Sys100NS: $objItem->{Frequency_Sys100NS}\n";
	print "InsertsPersec: $objItem->{InsertsPersec}\n";
	print "KBaddedPersec: $objItem->{KBaddedPersec}\n";
	print "LookupsPersec: $objItem->{LookupsPersec}\n";
	print "MissesPersec: $objItem->{MissesPersec}\n";
	print "Name: $objItem->{Name}\n";
	print "Timestamp_Object: $objItem->{Timestamp_Object}\n";
	print "Timestamp_PerfTime: $objItem->{Timestamp_PerfTime}\n";
	print "Timestamp_Sys100NS: $objItem->{Timestamp_Sys100NS}\n";
	print "Totaldirecthits: $objItem->{Totaldirecthits}\n";
	print "Totalevictions: $objItem->{Totalevictions}\n";
	print "Totalfilterediteratorcachehits: $objItem->{Totalfilterediteratorcachehits}\n";
	print "Totalfilterediteratorcachemisses: $objItem->{Totalfilterediteratorcachemisses}\n";
	print "Totalinserts: $objItem->{Totalinserts}\n";
	print "Totallookups: $objItem->{Totallookups}\n";
	print "Totalmisses: $objItem->{Totalmisses}\n";
	print "\n";
	print "########\n";
	print "\n";
}