MSSQLSERVER-MIB
File:
MSSQLSERVER-MIB.mib (26759 bytes)
Imported modules
Imported symbols
Defined Types
MssqlSrvEntry |
|
SEQUENCE |
|
|
|
|
mssqlSrvVendorName |
DisplayString |
|
|
mssqlSrvProductName |
DisplayString |
|
|
mssqlSrvVersion |
DisplayString |
|
|
mssqlSrvContact |
DisplayString |
|
|
mssqlSrvState |
INTEGER |
|
MssqlSrvInfoEntry |
|
SEQUENCE |
|
|
|
|
mssqlSrvInfoServerName |
DisplayString |
|
|
mssqlSrvInfoStartupTime |
DisplayString |
|
|
mssqlSrvInfoTrans |
Gauge |
|
|
mssqlSrvInfoPageReads |
Counter |
|
|
mssqlSrvInfoSinglePageWrites |
Counter |
|
|
mssqlSrvInfoBatchWrites |
Counter |
|
|
mssqlSrvInfoLazyWrites |
Counter |
|
|
mssqlSrvInfoLogWrites |
Counter |
|
|
mssqlSrvInfoOutstandingReads |
Counter |
|
|
mssqlSrvInfoOutstandingWrites |
Counter |
|
|
mssqlSrvInfoCacheHitRatio |
Gauge |
|
|
mssqlSrvInfoFreeBuffers |
Gauge |
|
|
mssqlSrvInfoNetworkReads |
Counter |
|
|
mssqlSrvInfoNetworkWrites |
Counter |
|
|
mssqlSrvInfoRAPhysicalReads |
Counter |
|
|
mssqlSrvInfoUserConnections |
Gauge |
|
|
mssqlSrvInfoTotalLocks |
Gauge |
|
|
mssqlSrvInfoTotalBlockingLocks |
Gauge |
|
|
mssqlSrvInfoUsersBlocked |
Gauge |
|
MssqlSrvConfigParamEntry |
|
SEQUENCE |
|
|
|
|
mssqlSrvConfigParamName |
DisplayString |
|
|
mssqlSrvConfigParamMax |
INTEGER |
|
|
mssqlSrvConfigParamMin |
INTEGER |
|
|
mssqlSrvConfigParamConfigValue |
INTEGER |
|
|
mssqlSrvConfigParamRunValue |
INTEGER |
|
MssqlSrvDeviceEntry |
|
SEQUENCE |
|
|
|
|
mssqlSrvDeviceLogicalName |
DisplayString |
|
|
mssqlSrvDevicePhysicalName |
DisplayString |
|
|
mssqlSrvDeviceDescription |
DisplayString |
|
MssqlDbEntry |
|
SEQUENCE |
|
|
|
|
mssqlDbId |
INTEGER |
|
|
mssqlDbName |
DisplayString |
|
|
mssqlDbState |
INTEGER |
|
MssqlDbInfoEntry |
|
SEQUENCE |
|
|
|
|
mssqlDbInfoDbId |
INTEGER |
|
|
mssqlDbInfoDbName |
DisplayString |
|
|
mssqlDbInfoCreationDateTime |
DisplayString |
|
|
mssqlDbInfoOwner |
DisplayString |
|
|
mssqlDbInfoSize |
INTEGER |
|
|
mssqlDbInfoUnallocatedSpace |
INTEGER |
|
|
mssqlDbInfoReservedSpace |
INTEGER |
|
|
mssqlDbInfoDataSpace |
INTEGER |
|
|
mssqlDbInfoIndexSpace |
INTEGER |
|
|
mssqlDbInfoUnusedSpace |
INTEGER |
|
|
mssqlDbInfoLastTrLogDump |
DisplayString |
|
|
mssqlDbInfoLogSize |
INTEGER |
|
|
mssqlDbInfoLogSpaceUsed |
INTEGER |
|
MssqlDbOptionEntry |
|
SEQUENCE |
|
|
|
|
mssqlDbOptionDbId |
INTEGER |
|
|
mssqlDbOptionDbName |
DisplayString |
|
|
mssqlDbOptionSetName |
DisplayString |
|
MssqlDbDeviceEntry |
|
SEQUENCE |
|
|
|
|
mssqlDbDeviceDbId |
INTEGER |
|
|
mssqlDbDeviceDbName |
DisplayString |
|
|
mssqlDbDeviceFragmentName |
DisplayString |
|
|
mssqlDbDeviceFragmentSize |
INTEGER |
|
|
mssqlDbDeviceFragmentUsage |
DisplayString |
|
Defined Values
software |
1.3.6.1.4.1.311.1 |
OBJECT IDENTIFIER |
|
|
|
apps |
1.3.6.1.4.1.311.1.4 |
OBJECT IDENTIFIER |
|
|
|
mssqlSrvTable |
1.3.6.1.4.1.311.1.4.1.1.1 |
This table contains a single row for the SQL Server
installed on the system. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlSrvEntry |
|
mssqlSrvEntry |
1.3.6.1.4.1.311.1.4.1.1.1.1 |
mssqlSrvTable entries. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlSrvEntry |
|
|
mssqlSrvVersion |
1.3.6.1.4.1.311.1.4.1.1.1.1.3 |
The version of installed SQL Server. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlSrvState |
1.3.6.1.4.1.311.1.4.1.1.1.1.5 |
The 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. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
running(1), paused(2), stopped(3), starting(4), stopping(5), continuing(6), pausing(7) |
|
mssqlSrvInfoTable |
1.3.6.1.4.1.311.1.4.1.1.2 |
This table contains general information regarding
the active SQL Server process, including performance
counters. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlSrvInfoEntry |
|
mssqlSrvInfoEntry |
1.3.6.1.4.1.311.1.4.1.1.2.1 |
mssqlSrvInfoTable entries. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlSrvInfoEntry |
|
|
mssqlSrvInfoStartupTime |
1.3.6.1.4.1.311.1.4.1.1.2.1.2 |
The date and time at which the current running
SQL Server process was last started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlSrvInfoTrans |
1.3.6.1.4.1.311.1.4.1.1.2.1.3 |
The number of command batches completed since
SQL Server was last started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Gauge |
|
|
mssqlSrvInfoSinglePageWrites |
1.3.6.1.4.1.311.1.4.1.1.2.1.5 |
The number of single page writes completed
since the SQL Server was started (does not
include log writes, cache flushes (Lazy Writer),
or batch writes). |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoBatchWrites |
1.3.6.1.4.1.311.1.4.1.1.2.1.6 |
The number of pages written to disk using batch
I/O since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoLazyWrites |
1.3.6.1.4.1.311.1.4.1.1.2.1.7 |
The number of pages flushed to disk by the
Lazy Writer since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoLogWrites |
1.3.6.1.4.1.311.1.4.1.1.2.1.8 |
The number of log pages physically written
to disk since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoCacheHitRatio |
1.3.6.1.4.1.311.1.4.1.1.2.1.11 |
The percentage of time that a requested data
page was found in the data cache (instead of
being read from disk). |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Gauge |
|
|
mssqlSrvInfoFreeBuffers |
1.3.6.1.4.1.311.1.4.1.1.2.1.12 |
The number of data cache buffers currently
in the free pool. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Gauge |
|
|
mssqlSrvInfoNetworkReads |
1.3.6.1.4.1.311.1.4.1.1.2.1.13 |
The number of tabular data stream (TDS) packets read
from the network since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoNetworkWrites |
1.3.6.1.4.1.311.1.4.1.1.2.1.14 |
The number of tabular data stream (TDS) packets written
to the network since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoRAPhysicalReads |
1.3.6.1.4.1.311.1.4.1.1.2.1.15 |
Physical reads (each consisting of 8 - 2K pages) issued by
Read Ahead Manager since SQL Server was started. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Counter |
|
|
mssqlSrvInfoTotalLocks |
1.3.6.1.4.1.311.1.4.1.1.2.1.17 |
A count of all locks being used by SQL Server. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Gauge |
|
|
mssqlSrvInfoUsersBlocked |
1.3.6.1.4.1.311.1.4.1.1.2.1.19 |
The number of users blocked by other users. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
Gauge |
|
|
mssqlSrvConfigParamEntry |
1.3.6.1.4.1.311.1.4.1.1.3.1 |
mssqlSrvConfigParamTable entries. The SQL Server configuration
parameter name is used as the index value. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlSrvConfigParamEntry |
|
|
mssqlSrvConfigParamMax |
1.3.6.1.4.1.311.1.4.1.1.3.1.2 |
The maximum configurable value for the associated
SQL Server configuration parameter. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlSrvConfigParamMin |
1.3.6.1.4.1.311.1.4.1.1.3.1.3 |
The minimum configurable value for the associated
SQL Server configuration parameter. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlSrvConfigParamConfigValue |
1.3.6.1.4.1.311.1.4.1.1.3.1.4 |
The current configured value for the associated
SQL Server configuration parameter. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlSrvConfigParamRunValue |
1.3.6.1.4.1.311.1.4.1.1.3.1.5 |
The current run value for the associated
SQL Server configuration parameter. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlSrvDeviceTable |
1.3.6.1.4.1.311.1.4.1.1.4 |
This table contains entries for each SQL Server
device on the system. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlSrvDeviceEntry |
|
mssqlSrvDeviceEntry |
1.3.6.1.4.1.311.1.4.1.1.4.1 |
mssqlSrvDeviceTable entries. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlSrvDeviceEntry |
|
|
mssqlSrvDeviceDescription |
1.3.6.1.4.1.311.1.4.1.1.4.1.3 |
Detailed description of the device including the type of
device, size, and the media type. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbTable |
1.3.6.1.4.1.311.1.4.1.1.5 |
This 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). |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlDbEntry |
|
mssqlDbEntry |
1.3.6.1.4.1.311.1.4.1.1.5.1 |
mssqlDbTable entries. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlDbEntry |
|
|
mssqlDbId |
1.3.6.1.4.1.311.1.4.1.1.5.1.1 |
The dbid of the database. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbName |
1.3.6.1.4.1.311.1.4.1.1.5.1.2 |
The name of the database. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbState |
1.3.6.1.4.1.311.1.4.1.1.5.1.3 |
The 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). |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
active(1), singleUser(2), dboonly(3), readOnly(4), offline(5), suspect(6), loading(7), publishing(8) |
|
mssqlDbInfoTable |
1.3.6.1.4.1.311.1.4.1.1.6 |
This 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). |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlDbInfoEntry |
|
mssqlDbInfoEntry |
1.3.6.1.4.1.311.1.4.1.1.6.1 |
mssqlDbInfoTable entries. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlDbInfoEntry |
|
|
mssqlDbInfoDbId |
1.3.6.1.4.1.311.1.4.1.1.6.1.1 |
The dbid of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlDbInfoDbName |
1.3.6.1.4.1.311.1.4.1.1.6.1.2 |
The name of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbInfoOwner |
1.3.6.1.4.1.311.1.4.1.1.6.1.4 |
The owner of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbInfoSize |
1.3.6.1.4.1.311.1.4.1.1.6.1.5 |
The size in KB of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoUnallocatedSpace |
1.3.6.1.4.1.311.1.4.1.1.6.1.6 |
The unallocated space in KB of the database associated
with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoReservedSpace |
1.3.6.1.4.1.311.1.4.1.1.6.1.7 |
The reserved space in KB of the database associated with
this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoDataSpace |
1.3.6.1.4.1.311.1.4.1.1.6.1.8 |
The used data space in KB of the database associated
with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoIndexSpace |
1.3.6.1.4.1.311.1.4.1.1.6.1.9 |
The used index space in KB of the database associated
with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoUnusedSpace |
1.3.6.1.4.1.311.1.4.1.1.6.1.10 |
The unused space in KB of the database associated
with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoLastTrLogDump |
1.3.6.1.4.1.311.1.4.1.1.6.1.11 |
The date and time that the latest transaction log dump
for this database was taken. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbInfoLogSize |
1.3.6.1.4.1.311.1.4.1.1.6.1.12 |
The size in KB of the transaction log for the database
associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbInfoLogSpaceUsed |
1.3.6.1.4.1.311.1.4.1.1.6.1.13 |
The percentage of transaction log space for the
database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbOptionTable |
1.3.6.1.4.1.311.1.4.1.1.7 |
This table contains the list of possible database
options and indicates which are set for a given dastabase. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlDbOptionEntry |
|
mssqlDbOptionEntry |
1.3.6.1.4.1.311.1.4.1.1.7.1 |
mssqlDbOptionTable entries. The dbid of the database
is used as the index value associated with this row. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlDbOptionEntry |
|
|
mssqlDbOptionDbId |
1.3.6.1.4.1.311.1.4.1.1.7.1.1 |
The dbid of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|
mssqlDbOptionDbName |
1.3.6.1.4.1.311.1.4.1.1.7.1.2 |
The name of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbOptionSetName |
1.3.6.1.4.1.311.1.4.1.1.7.1.3 |
The name of the database option that is set for
the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbDeviceTable |
1.3.6.1.4.1.311.1.4.1.1.8 |
This table contains entries for each device fragment
on which a particular SQL Server database has been
created or altered. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
SEQUENCE OF |
|
|
|
|
MssqlDbDeviceEntry |
|
mssqlDbDeviceEntry |
1.3.6.1.4.1.311.1.4.1.1.8.1 |
mssqlDbDeviceTable entries. The dbid of the database
is used as index value associated with this row. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
MssqlDbDeviceEntry |
|
|
mssqlDbDeviceDbId |
1.3.6.1.4.1.311.1.4.1.1.8.1.1 |
The dbid of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
|
|
mssqlDbDeviceDbName |
1.3.6.1.4.1.311.1.4.1.1.8.1.2 |
The name of the database associated with this row. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbDeviceFragmentName |
1.3.6.1.4.1.311.1.4.1.1.8.1.3 |
The name of a device fragment on which the database
has been created or altered. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
DisplayString |
|
|
mssqlDbDeviceFragmentSize |
1.3.6.1.4.1.311.1.4.1.1.8.1.4 |
The size in KB of the device fragment on which the
database has been created or altered. |
Status: mandatory |
Access: read-only |
OBJECT-TYPE |
|
|
|
|
INTEGER |
1..2147483647 |
|