Win32_PerfFormattedData_NETDataProviderforSqlServer 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_PerfFormattedData_NETDataProviderforSqlServer 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_PerfFormattedData_NETDataProviderforSqlServer_NETDataProviderforSqlServer"

foreach ($obj in $objWmi)
{
	write-host "Caption:" $obj.Caption
	write-host "Description:" $obj.Description
	write-host "Frequency_Object:" $obj.Frequency_Object
	write-host "Frequency_PerfTime:" $obj.Frequency_PerfTime
	write-host "Frequency_Sys100NS:" $obj.Frequency_Sys100NS
	write-host "HardConnectsPerSecond:" $obj.HardConnectsPerSecond
	write-host "HardDisconnectsPerSecond:" $obj.HardDisconnectsPerSecond
	write-host "Name:" $obj.Name
	write-host "NumberOfActiveConnectionPoolGroups:" $obj.NumberOfActiveConnectionPoolGroups
	write-host "NumberOfActiveConnectionPools:" $obj.NumberOfActiveConnectionPools
	write-host "NumberOfActiveConnections:" $obj.NumberOfActiveConnections
	write-host "NumberOfFreeConnections:" $obj.NumberOfFreeConnections
	write-host "NumberOfInactiveConnectionPoolGroups:" $obj.NumberOfInactiveConnectionPoolGroups
	write-host "NumberOfInactiveConnectionPools:" $obj.NumberOfInactiveConnectionPools
	write-host "NumberOfNonPooledConnections:" $obj.NumberOfNonPooledConnections
	write-host "NumberOfPooledConnections:" $obj.NumberOfPooledConnections
	write-host "NumberOfReclaimedConnections:" $obj.NumberOfReclaimedConnections
	write-host "NumberOfStasisConnections:" $obj.NumberOfStasisConnections
	write-host "SoftConnectsPerSecond:" $obj.SoftConnectsPerSecond
	write-host "SoftDisconnectsPerSecond:" $obj.SoftDisconnectsPerSecond
	write-host "Timestamp_Object:" $obj.Timestamp_Object
	write-host "Timestamp_PerfTime:" $obj.Timestamp_PerfTime
	write-host "Timestamp_Sys100NS:" $obj.Timestamp_Sys100NS
	write-host
	write-host "########"
	write-host
}