All MIBs › INFORMANT-SQLSERVER-V2 › ss2wsMemoryGrantQueueWaits
ss2wsMemoryGrantQueueWaits
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2wsMemoryGrantQueueWaits
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.38.1.5
Node type: OBJECT-TYPE
Type: Gauge32
Access: read-only
Description:
Statistics for processes waiting for memory grant to become available.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.38.1.5 snmpwalk -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2wsMemoryGrantQueueWaits
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.38.1.5.1 snmpget -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2wsMemoryGrantQueueWaits.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> ss2wsMemoryGrantQueueWaits.1
OID Breakdown
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | BIANCA-BRICK-PPP-MIB |
| 1.3.6 | dod | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1 | internet | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4 | private | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4.1 | enterprises | ANIROOT-MIB |
| 1.3.6.1.4.1.9600 | wtcs | WTCS |
| 1.3.6.1.4.1.9600.1 | informant | WTCS |
| 1.3.6.1.4.1.9600.1.13 | sqlServerV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2 | sqlServerEngineV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.38 | ss2WaitStatisticsTable | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.38.1 | ss2WaitStatisticsEntry | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.38.1.5 | ss2wsMemoryGrantQueueWaits | INFORMANT-SQLSERVER-V2 |