MSSQLSERVER-MIB

File: MSSQLSERVER-MIB.mib (26753 bytes)

Imported modules

RFC1155-SMI RFC-1212 RFC1213-MIB

Imported symbols

enterprises Gauge Counter
OBJECT-TYPE DisplayString

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

microsoft 1.3.6.1.4.1.311
OBJECT IDENTIFIER    

software 1.3.6.1.4.1.311.1
OBJECT IDENTIFIER    

apps 1.3.6.1.4.1.311.1.4
OBJECT IDENTIFIER    

mssqlServer 1.3.6.1.4.1.311.1.4.1
OBJECT IDENTIFIER    

mssqlServerObjects 1.3.6.1.4.1.311.1.4.1.1
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.
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlSrvEntry

mssqlSrvEntry 1.3.6.1.4.1.311.1.4.1.1.1.1
mssqlSrvTable entries.
OBJECT-TYPE    
  MssqlSrvEntry  

mssqlSrvVendorName 1.3.6.1.4.1.311.1.4.1.1.1.1.1
The name of the database server vendor.
OBJECT-TYPE    
  DisplayString  

mssqlSrvProductName 1.3.6.1.4.1.311.1.4.1.1.1.1.2
The product name of the database server.
OBJECT-TYPE    
  DisplayString  

mssqlSrvVersion 1.3.6.1.4.1.311.1.4.1.1.1.1.3
The version of installed SQL Server.
OBJECT-TYPE    
  DisplayString  

mssqlSrvContact 1.3.6.1.4.1.311.1.4.1.1.1.1.4
Contact person for this SQL Server installation.
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.
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.
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlSrvInfoEntry

mssqlSrvInfoEntry 1.3.6.1.4.1.311.1.4.1.1.2.1
mssqlSrvInfoTable entries.
OBJECT-TYPE    
  MssqlSrvInfoEntry  

mssqlSrvInfoServerName 1.3.6.1.4.1.311.1.4.1.1.2.1.1
The name of the local SQL Server.
OBJECT-TYPE    
  DisplayString  

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.
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.
OBJECT-TYPE    
  Gauge  

mssqlSrvInfoPageReads 1.3.6.1.4.1.311.1.4.1.1.2.1.4
The number of physical page reads completed since SQL Server was started.
OBJECT-TYPE    
  Counter  

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).
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.
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.
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.
OBJECT-TYPE    
  Counter  

mssqlSrvInfoOutstandingReads 1.3.6.1.4.1.311.1.4.1.1.2.1.9
The number of physical reads pending.
OBJECT-TYPE    
  Counter  

mssqlSrvInfoOutstandingWrites 1.3.6.1.4.1.311.1.4.1.1.2.1.10
The number of physical writes pending.
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).
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.
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.
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.
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.
OBJECT-TYPE    
  Counter  

mssqlSrvInfoUserConnections 1.3.6.1.4.1.311.1.4.1.1.2.1.16
The number of open user connections.
OBJECT-TYPE    
  Gauge  

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.
OBJECT-TYPE    
  Gauge  

mssqlSrvInfoTotalBlockingLocks 1.3.6.1.4.1.311.1.4.1.1.2.1.18
A count of all locks blocking other processes.
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.
OBJECT-TYPE    
  Gauge  

mssqlSrvConfigParamTable 1.3.6.1.4.1.311.1.4.1.1.3
This table contains entries for the SQL Server configuration parameters.
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlSrvConfigParamEntry

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.
STRING    
  MssqlSrvConfigParamEntry  

mssqlSrvConfigParamName 1.3.6.1.4.1.311.1.4.1.1.3.1.1
Name of SQL Server configuration parameter.
OBJECT-TYPE    
  DisplayString  

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.
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.
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.
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.
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.
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlSrvDeviceEntry

mssqlSrvDeviceEntry 1.3.6.1.4.1.311.1.4.1.1.4.1
mssqlSrvDeviceTable entries.
OBJECT-TYPE    
  MssqlSrvDeviceEntry  

mssqlSrvDeviceLogicalName 1.3.6.1.4.1.311.1.4.1.1.4.1.1
The logical name of the defined database or dump device.
OBJECT-TYPE    
  DisplayString  

mssqlSrvDevicePhysicalName 1.3.6.1.4.1.311.1.4.1.1.4.1.2
The physical name including the file system path and file name.
OBJECT-TYPE    
  DisplayString  

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.
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).
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlDbEntry

mssqlDbEntry 1.3.6.1.4.1.311.1.4.1.1.5.1
mssqlDbTable entries.
OBJECT-TYPE    
  MssqlDbEntry  

mssqlDbId 1.3.6.1.4.1.311.1.4.1.1.5.1.1
The dbid of the database.
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.
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).
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).
OBJECT-TYPE    
  SEQUENCE OF  
    MssqlDbInfoEntry

mssqlDbInfoEntry 1.3.6.1.4.1.311.1.4.1.1.6.1
mssqlDbInfoTable entries.
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.
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.
OBJECT-TYPE    
  DisplayString  

mssqlDbInfoCreationDateTime 1.3.6.1.4.1.311.1.4.1.1.6.1.3
The date and time that the database associated with this row was created.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
INTEGER    
  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.
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.
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.
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.
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.
INTEGER    
  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.
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.
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.
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.
OBJECT-TYPE    
  INTEGER 1..2147483647  

mssqlDbDeviceFragmentUsage 1.3.6.1.4.1.311.1.4.1.1.8.1.5
Indicates if the device fragment contains data, log, or data and log.
OBJECT-TYPE    
  DisplayString