MSSQLSERVER-MIB

File: MSSQLSERVER-MIB.mib (26759 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.
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  

mssqlSrvVendorName 1.3.6.1.4.1.311.1.4.1.1.1.1.1
The name of the database server vendor.
Status: mandatory Access: read-only
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.
Status: mandatory Access: read-only
OBJECT-TYPE    
  DisplayString  

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  

mssqlSrvContact 1.3.6.1.4.1.311.1.4.1.1.1.1.4
Contact person for this SQL Server installation.
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  

mssqlSrvInfoServerName 1.3.6.1.4.1.311.1.4.1.1.2.1.1
The name of the local SQL Server.
Status: mandatory Access: read-only
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.
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  

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.
Status: mandatory Access: read-only
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).
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  

mssqlSrvInfoOutstandingReads 1.3.6.1.4.1.311.1.4.1.1.2.1.9
The number of physical reads pending.
Status: mandatory Access: read-only
OBJECT-TYPE    
  Counter  

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

mssqlSrvInfoUserConnections 1.3.6.1.4.1.311.1.4.1.1.2.1.16
The number of open user connections.
Status: mandatory Access: read-only
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.
Status: mandatory Access: read-only
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.
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  

mssqlSrvConfigParamTable 1.3.6.1.4.1.311.1.4.1.1.3
This table contains entries for the SQL Server configuration parameters.
Status: mandatory Access: not-accessible
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.
Status: mandatory Access: not-accessible
OBJECT-TYPE    
  MssqlSrvConfigParamEntry  

mssqlSrvConfigParamName 1.3.6.1.4.1.311.1.4.1.1.3.1.1
Name of SQL Server configuration parameter.
Status: mandatory Access: read-only
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.
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  

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.
Status: mandatory Access: read-only
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.
Status: mandatory Access: read-only
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.
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  

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

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.
Status: mandatory Access: read-only
OBJECT-TYPE    
  DisplayString  

Generation date: July 28, 2023, 16:18:13, Copyright © 2007 - 2022 - Circitor