All MIBs › INFORMANT-SQLSERVER-V2 › ss2amWorktablesCreatedPerSec
ss2amWorktablesCreatedPerSec
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2amWorktablesCreatedPerSec
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.2.1.41
Node type: OBJECT-TYPE
Type: Gauge32
Access: read-only
Description:
Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.2.1.41 snmpwalk -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2amWorktablesCreatedPerSec
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.2.1.41.1 snmpget -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2amWorktablesCreatedPerSec.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.2 | ss2AccessMethodsTable | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.2.1 | ss2AccessMethodsEntry | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.2.1.41 | ss2amWorktablesCreatedPerSec | INFORMANT-SQLSERVER-V2 |