MSSQLSERVER-MIB
Detailed view of the defined objects, syntax rules, and hierarchical paths.
78
Objects
Active
Status
3
Dependencies
Imported Objects
Objects
78 total| Object Name |
|---|
microsoft OBJECT IDENTIFIER .1.3.6.1.4.1.311 |
RFC1155-SMI Unknown .1.3.6.1.4.1.311 |
software OBJECT IDENTIFIER .1.3.6.1.4.1.311.1 |
apps OBJECT IDENTIFIER .1.3.6.1.4.1.311.1.4 |
mssqlServer OBJECT IDENTIFIER .1.3.6.1.4.1.311.1.4.1 |
mssqlServerObjects OBJECT IDENTIFIER .1.3.6.1.4.1.311.1.4.1.1 |
mssqlSrvTableThis table contains a single row for the SQL Server
installed on the system. SEQUENCE OF MssqlSrvEntry .1.3.6.1.4.1.311.1.4.1.1.1 |
mssqlSrvEntrymssqlSrvTable entries. MssqlSrvEntry .1.3.6.1.4.1.311.1.4.1.1.1.1 |
mssqlSrvVendorNameThe name of the database server vendor.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.1.1.1 |
mssqlSrvProductNameThe product name of the database server.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.1.1.2 |
mssqlSrvVersionThe version of installed SQL Server.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.1.1.3 |
mssqlSrvContactContact person for this SQL Server installation.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.1.1.4 |
mssqlSrvStateThe state of SQL Server. Unknown(1) means we are
unable to determine the state of the server, Running(2)
means the server is available and can be used, Paused(3)
means the server is running, but new connections cannot
currently be established, and Stopped(4) means the server
is not running and unavailable.ro Enumeration .1.3.6.1.4.1.311.1.4.1.1.1.1.5 |
mssqlSrvInfoTableThis table contains general information regarding
the active SQL Server process, including performance
counters. SEQUENCE OF MssqlSrvInfoEntry .1.3.6.1.4.1.311.1.4.1.1.2 |
mssqlSrvInfoEntrymssqlSrvInfoTable entries. MssqlSrvInfoEntry .1.3.6.1.4.1.311.1.4.1.1.2.1 |
mssqlSrvInfoServerNameThe name of the local SQL Server.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.2.1.1 |
mssqlSrvInfoStartupTimeThe date and time at which the current running
SQL Server process was last started.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.2.1.2 |
mssqlSrvInfoTransThe number of command batches completed since
SQL Server was last started.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.3 |
mssqlSrvInfoPageReadsThe number of physical page reads completed
since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.4 |
mssqlSrvInfoSinglePageWritesThe number of single page writes completed
since the SQL Server was started (does not
include log writes, cache flushes (Lazy Writer),
or batch writes).ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.5 |
mssqlSrvInfoBatchWritesThe number of pages written to disk using batch
I/O since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.6 |
mssqlSrvInfoLazyWritesThe number of pages flushed to disk by the
Lazy Writer since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.7 |
mssqlSrvInfoLogWritesThe number of log pages physically written
to disk since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.8 |
mssqlSrvInfoOutstandingReadsThe number of physical reads pending.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.9 |
mssqlSrvInfoOutstandingWritesThe number of physical writes pending.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.10 |
mssqlSrvInfoCacheHitRatioThe percentage of time that a requested data
page was found in the data cache (instead of
being read from disk).ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.11 |
mssqlSrvInfoFreeBuffersThe number of data cache buffers currently
in the free pool.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.12 |
mssqlSrvInfoNetworkReadsThe number of tabular data stream (TDS) packets read
from the network since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.13 |
mssqlSrvInfoNetworkWritesThe number of tabular data stream (TDS) packets written
to the network since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.14 |
mssqlSrvInfoRAPhysicalReadsPhysical reads (each consisting of 8 - 2K pages) issued by
Read Ahead Manager since SQL Server was started.ro Counter .1.3.6.1.4.1.311.1.4.1.1.2.1.15 |
mssqlSrvInfoUserConnectionsThe number of open user connections.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.16 |
mssqlSrvInfoTotalLocksA count of all locks being used by SQL Server.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.17 |
mssqlSrvInfoTotalBlockingLocksA count of all locks blocking other processes.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.18 |
mssqlSrvInfoUsersBlockedThe number of users blocked by other users.ro Gauge .1.3.6.1.4.1.311.1.4.1.1.2.1.19 |
mssqlSrvConfigParamTableThis table contains entries for the SQL Server
configuration parameters. SEQUENCE OF MssqlSrvConfigParamEntry .1.3.6.1.4.1.311.1.4.1.1.3 |
mssqlSrvConfigParamEntrymssqlSrvConfigParamTable entries. The SQL Server configuration
parameter name is used as the index value. MssqlSrvConfigParamEntry .1.3.6.1.4.1.311.1.4.1.1.3.1 |
mssqlSrvConfigParamNameName of SQL Server configuration parameter.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.3.1.1 |
mssqlSrvConfigParamMaxThe maximum configurable value for the associated
SQL Server configuration parameter.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.3.1.2 |
mssqlSrvConfigParamMinThe minimum configurable value for the associated
SQL Server configuration parameter.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.3.1.3 |
mssqlSrvConfigParamConfigValueThe current configured value for the associated
SQL Server configuration parameter.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.3.1.4 |
mssqlSrvConfigParamRunValueThe current run value for the associated
SQL Server configuration parameter.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.3.1.5 |
mssqlSrvDeviceTableThis table contains entries for each SQL Server
device on the system. SEQUENCE OF MssqlSrvDeviceEntry .1.3.6.1.4.1.311.1.4.1.1.4 |
mssqlSrvDeviceEntrymssqlSrvDeviceTable entries. MssqlSrvDeviceEntry .1.3.6.1.4.1.311.1.4.1.1.4.1 |
mssqlSrvDeviceLogicalNameThe logical name of the defined database or dump device.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.4.1.1 |
mssqlSrvDevicePhysicalNameThe physical name including the file system path and file name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.4.1.2 |
mssqlSrvDeviceDescriptionDetailed description of the device including the type of
device, size, and the media type.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.4.1.3 |
mssqlDbTableThis table contains a list of SQL Server databases. The
table contains a single row for each database (whether
the database is actually accessible or not). SEQUENCE OF MssqlDbEntry .1.3.6.1.4.1.311.1.4.1.1.5 |
mssqlDbEntrymssqlDbTable entries. MssqlDbEntry .1.3.6.1.4.1.311.1.4.1.1.5.1 |
mssqlDbIdThe dbid of the database.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.5.1.1 |
mssqlDbNameThe name of the database.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.5.1.2 |
mssqlDbStateThe state of the database. Valid states are defined as follows:
Active(1), Single User(2), DBO Only(3), Read Only(4), Offline(5),
Suspect(6), Loading(7), and Publishing(8).ro Enumeration .1.3.6.1.4.1.311.1.4.1.1.5.1.3 |
mssqlDbInfoTableThis table contains detailed information about SQL Server
databases. In order for this table to be populated, the
database must be accessible (as determined by checking
mssqlDbState). SEQUENCE OF MssqlDbInfoEntry .1.3.6.1.4.1.311.1.4.1.1.6 |
mssqlDbInfoEntrymssqlDbInfoTable entries. MssqlDbInfoEntry .1.3.6.1.4.1.311.1.4.1.1.6.1 |
mssqlDbInfoDbIdThe dbid of the database associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.1 |
mssqlDbInfoDbNameThe name of the database associated with this row.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.6.1.2 |
mssqlDbInfoCreationDateTimeThe date and time that the database associated with
this row was created.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.6.1.3 |
mssqlDbInfoOwnerThe owner of the database associated with this row.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.6.1.4 |
mssqlDbInfoSizeThe size in KB of the database associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.5 |
mssqlDbInfoUnallocatedSpaceThe unallocated space in KB of the database associated
with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.6 |
mssqlDbInfoReservedSpaceThe reserved space in KB of the database associated with
this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.7 |
mssqlDbInfoDataSpaceThe used data space in KB of the database associated
with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.8 |
mssqlDbInfoIndexSpaceThe used index space in KB of the database associated
with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.9 |
mssqlDbInfoUnusedSpaceThe unused space in KB of the database associated
with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.10 |
mssqlDbInfoLastTrLogDumpThe date and time that the latest transaction log dump
for this database was taken.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.6.1.11 |
mssqlDbInfoLogSizeThe size in KB of the transaction log for the database
associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.12 |
mssqlDbInfoLogSpaceUsedThe percentage of transaction log space for the
database associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.6.1.13 |
mssqlDbOptionTableThis table contains the list of possible database
options and indicates which are set for a given dastabase. SEQUENCE OF MssqlDbOptionEntry .1.3.6.1.4.1.311.1.4.1.1.7 |
mssqlDbOptionEntrymssqlDbOptionTable entries. The dbid of the database
is used as the index value associated with this row. MssqlDbOptionEntry .1.3.6.1.4.1.311.1.4.1.1.7.1 |
mssqlDbOptionDbIdThe dbid of the database associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.7.1.1 |
mssqlDbOptionDbNameThe name of the database associated with this row.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.7.1.2 |
mssqlDbOptionSetNameThe name of the database option that is set for
the database associated with this row.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.7.1.3 |
mssqlDbDeviceTableThis table contains entries for each device fragment
on which a particular SQL Server database has been
created or altered. SEQUENCE OF MssqlDbDeviceEntry .1.3.6.1.4.1.311.1.4.1.1.8 |
mssqlDbDeviceEntrymssqlDbDeviceTable entries. The dbid of the database
is used as index value associated with this row. MssqlDbDeviceEntry .1.3.6.1.4.1.311.1.4.1.1.8.1 |
mssqlDbDeviceDbIdThe dbid of the database associated with this row.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.8.1.1 |
mssqlDbDeviceDbNameThe name of the database associated with this row.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.8.1.2 |
mssqlDbDeviceFragmentNameThe name of a device fragment on which the database
has been created or altered.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.8.1.3 |
mssqlDbDeviceFragmentSizeThe size in KB of the device fragment on which the
database has been created or altered.ro INTEGER .1.3.6.1.4.1.311.1.4.1.1.8.1.4 |
mssqlDbDeviceFragmentUsageIndicates if the device fragment contains data,
log, or data and log.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.311.1.4.1.1.8.1.5 |