MSSQLSERVER-MIB

File: MSSQLSERVER-MIB.mib (26761 bytes)

Imported modules

RFC1155-SMI RFC-1212 RFC1213-MIB

Imported symbols

Counter Gauge enterprises
OBJECT-TYPE DisplayString

Defined Objects

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

Defined Objects

MssqlSrvEntry  
SEQUENCE    
  DisplayString as mssqlSrvVendorName  
  DisplayString as mssqlSrvProductName  
  DisplayString as mssqlSrvVersion  
  DisplayString as mssqlSrvContact  
  INTEGER as mssqlSrvState  

MssqlSrvInfoEntry  
SEQUENCE    
  DisplayString as mssqlSrvInfoServerName  
  DisplayString as mssqlSrvInfoStartupTime  
  Gauge as mssqlSrvInfoTrans  
  Counter as mssqlSrvInfoPageReads  
  Counter as mssqlSrvInfoSinglePageWrites  
  Counter as mssqlSrvInfoBatchWrites  
  Counter as mssqlSrvInfoLazyWrites  
  Counter as mssqlSrvInfoLogWrites  
  Counter as mssqlSrvInfoOutstandingReads  
  Counter as mssqlSrvInfoOutstandingWrites  
  Gauge as mssqlSrvInfoCacheHitRatio  
  Gauge as mssqlSrvInfoFreeBuffers  
  Counter as mssqlSrvInfoNetworkReads  
  Counter as mssqlSrvInfoNetworkWrites  
  Counter as mssqlSrvInfoRAPhysicalReads  
  Gauge as mssqlSrvInfoUserConnections  
  Gauge as mssqlSrvInfoTotalLocks  
  Gauge as mssqlSrvInfoTotalBlockingLocks  
  Gauge as mssqlSrvInfoUsersBlocked  

MssqlSrvConfigParamEntry  
SEQUENCE    
  DisplayString as mssqlSrvConfigParamName  
  INTEGER as mssqlSrvConfigParamMax  
  INTEGER as mssqlSrvConfigParamMin  
  INTEGER as mssqlSrvConfigParamConfigValue  
  INTEGER as mssqlSrvConfigParamRunValue  

MssqlSrvDeviceEntry  
SEQUENCE    
  DisplayString as mssqlSrvDeviceLogicalName  
  DisplayString as mssqlSrvDevicePhysicalName  
  DisplayString as mssqlSrvDeviceDescription  

MssqlDbEntry  
SEQUENCE    
  INTEGER as mssqlDbId  
  DisplayString as mssqlDbName  
  INTEGER as mssqlDbState  

MssqlDbInfoEntry  
SEQUENCE    
  INTEGER as mssqlDbInfoDbId  
  DisplayString as mssqlDbInfoDbName  
  DisplayString as mssqlDbInfoCreationDateTime  
  DisplayString as mssqlDbInfoOwner  
  INTEGER as mssqlDbInfoSize  
  INTEGER as mssqlDbInfoUnallocatedSpace  
  INTEGER as mssqlDbInfoReservedSpace  
  INTEGER as mssqlDbInfoDataSpace  
  INTEGER as mssqlDbInfoIndexSpace  
  INTEGER as mssqlDbInfoUnusedSpace  
  DisplayString as mssqlDbInfoLastTrLogDump  
  INTEGER as mssqlDbInfoLogSize  
  INTEGER as mssqlDbInfoLogSpaceUsed  

MssqlDbOptionEntry  
SEQUENCE    
  INTEGER as mssqlDbOptionDbId  
  DisplayString as mssqlDbOptionDbName  
  DisplayString as mssqlDbOptionSetName  

MssqlDbDeviceEntry  
SEQUENCE    
  INTEGER as mssqlDbDeviceDbId  
  DisplayString as mssqlDbDeviceDbName  
  DisplayString as mssqlDbDeviceFragmentName  
  INTEGER as mssqlDbDeviceFragmentSize  
  DisplayString as mssqlDbDeviceFragmentUsage