Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » perl sample

Win32_PerfRawData_NETDataProviderforSqlServer 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_NETDataProviderforSqlServer 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_NETDataProviderforSqlServer_NETDataProviderforSqlServer", "WQL");

foreach my $objItem (in $colItems) {
	print "Caption: $objItem->{Caption}\n";
	print "Description: $objItem->{Description}\n";
	print "Frequency_Object: $objItem->{Frequency_Object}\n";
	print "Frequency_PerfTime: $objItem->{Frequency_PerfTime}\n";
	print "Frequency_Sys100NS: $objItem->{Frequency_Sys100NS}\n";
	print "HardConnectsPerSecond: $objItem->{HardConnectsPerSecond}\n";
	print "HardDisconnectsPerSecond: $objItem->{HardDisconnectsPerSecond}\n";
	print "Name: $objItem->{Name}\n";
	print "NumberOfActiveConnectionPoolGroups: $objItem->{NumberOfActiveConnectionPoolGroups}\n";
	print "NumberOfActiveConnectionPools: $objItem->{NumberOfActiveConnectionPools}\n";
	print "NumberOfActiveConnections: $objItem->{NumberOfActiveConnections}\n";
	print "NumberOfFreeConnections: $objItem->{NumberOfFreeConnections}\n";
	print "NumberOfInactiveConnectionPoolGroups: $objItem->{NumberOfInactiveConnectionPoolGroups}\n";
	print "NumberOfInactiveConnectionPools: $objItem->{NumberOfInactiveConnectionPools}\n";
	print "NumberOfNonPooledConnections: $objItem->{NumberOfNonPooledConnections}\n";
	print "NumberOfPooledConnections: $objItem->{NumberOfPooledConnections}\n";
	print "NumberOfReclaimedConnections: $objItem->{NumberOfReclaimedConnections}\n";
	print "NumberOfStasisConnections: $objItem->{NumberOfStasisConnections}\n";
	print "SoftConnectsPerSecond: $objItem->{SoftConnectsPerSecond}\n";
	print "SoftDisconnectsPerSecond: $objItem->{SoftDisconnectsPerSecond}\n";
	print "Timestamp_Object: $objItem->{Timestamp_Object}\n";
	print "Timestamp_PerfTime: $objItem->{Timestamp_PerfTime}\n";
	print "Timestamp_Sys100NS: $objItem->{Timestamp_Sys100NS}\n";
	print "\n";
	print "########\n";
	print "\n";
}