☞Fora list of the database server statistic OIDs, see “Server statistics”
onpage 27.
♦Databaseoptions
☞Fora list of the database option OIDs, see “Database options” on
page36.
♦Databaseproperties
☞Fora list of the database property OIDs, see “Database properties”
onpage 33.
♦Databasestatistics
☞Fora list of the database statistic OIDs, see “Database statistics” on
page31.
Theway you retrieve these values will depend on your SNMP management
software.
Examples Thetable below provides a description and sample value that could be
returnedfor the following OIDs.
OID Explanation Samplevalue
1.3.6.1.4.1.897.2.1.1.1.1 Server statistic ActiveReq on
database1
1
1.3.6.1.4.1.897.2.1.2.1.3 Serverproperty C2 on database 3 NO
1.3.6.1.4.1.897.2.2.1.4.1 Databasestatistic CacheRead on
database1
11397
1.3.6.1.4.1.897.2.2.2.7.4 Database property CaseSensi-
tivePasswordson database 4
OFF
1.3.6.1.4.1.897.2.2.3.5.2 Database option ANSI_-
INTEGER_OVERFLOW on
database2
OFF
1.3.6.1.4.1.897.2.3.1 Agentversion 9.0.1(1841)
1.3.6.1.4.1.897.2.3.2.1 Connectionstring for database 1 UID=DBA;PWD=SQL;
ENG=server1; DBN=sales;
DBF=sales.db
16