MSSQLSERVER-MIB
77 objects
No module-level DESCRIPTION found.
Imported Objects
| RFC-1212 | OBJECT-TYPE |
| RFC-1213 MISSING | DisplayString |
| RFC1155-SMI | enterprises |
| OID | Name | Access | Status | Description |
|---|---|---|---|---|
| 1.3.6.1.4.1.311 | Nodemicrosoft | |||
| 1.3.6.1.4.1.311.1 | Nodesoftware | |||
| 1.3.6.1.4.1.311.1.4 | Nodeapps | |||
| 1.3.6.1.4.1.311.1.4.1 | NodemssqlServer | |||
| 1.3.6.1.4.1.311.1.4.1.1 | NodemssqlServerObjects | |||
| 1.3.6.1.4.1.311.1.4.1.1.1 | TablemssqlSrvTable | not-accessible | mandatory | This table contains a single row for the SQL Server installed on the system. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1 | RowmssqlSrvEntry | not-accessible | mandatory | mssqlSrvTable entries. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.1 | ColumnmssqlSrvVendorName | read-only | mandatory | The name of the database server vendor. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.2 | ColumnmssqlSrvProductName | read-only | mandatory | The product name of the database server. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.3 | ColumnmssqlSrvVersion | read-only | mandatory | The version of installed SQL Server. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.4 | ColumnmssqlSrvContact | read-only | mandatory | Contact person for this SQL Server installation. |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.5 | ColumnmssqlSrvState | read-only | mandatory | 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(… |
| 1.3.6.1.4.1.311.1.4.1.1.2 | TablemssqlSrvInfoTable | not-accessible | mandatory | This table contains general information regarding the active SQL Server process, including performance counters. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1 | RowmssqlSrvInfoEntry | not-accessible | mandatory | mssqlSrvInfoTable entries. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.1 | ColumnmssqlSrvInfoServerName | read-only | mandatory | The name of the local SQL Server. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.2 | ColumnmssqlSrvInfoStartupTime | read-only | mandatory | The date and time at which the current running SQL Server process was last started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.3 | ColumnmssqlSrvInfoTrans | read-only | mandatory | The number of command batches completed since SQL Server was last started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.4 | ColumnmssqlSrvInfoPageReads | read-only | mandatory | The number of physical page reads completed since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.5 | ColumnmssqlSrvInfoSinglePageWrites | read-only | mandatory | 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). |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.6 | ColumnmssqlSrvInfoBatchWrites | read-only | mandatory | The number of pages written to disk using batch I/O since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.7 | ColumnmssqlSrvInfoLazyWrites | read-only | mandatory | The number of pages flushed to disk by the Lazy Writer since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.8 | ColumnmssqlSrvInfoLogWrites | read-only | mandatory | The number of log pages physically written to disk since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.9 | ColumnmssqlSrvInfoOutstandingReads | read-only | mandatory | The number of physical reads pending. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.10 | ColumnmssqlSrvInfoOutstandingWrites | read-only | mandatory | The number of physical writes pending. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.11 | ColumnmssqlSrvInfoCacheHitRatio | read-only | mandatory | The percentage of time that a requested data page was found in the data cache (instead of being read from disk). |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.12 | ColumnmssqlSrvInfoFreeBuffers | read-only | mandatory | The number of data cache buffers currently in the free pool. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.13 | ColumnmssqlSrvInfoNetworkReads | read-only | mandatory | The number of tabular data stream (TDS) packets read from the network since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.14 | ColumnmssqlSrvInfoNetworkWrites | read-only | mandatory | The number of tabular data stream (TDS) packets written to the network since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.15 | ColumnmssqlSrvInfoRAPhysicalReads | read-only | mandatory | Physical reads (each consisting of 8 - 2K pages) issued by Read Ahead Manager since SQL Server was started. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.16 | ColumnmssqlSrvInfoUserConnections | read-only | mandatory | The number of open user connections. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.17 | ColumnmssqlSrvInfoTotalLocks | read-only | mandatory | A count of all locks being used by SQL Server. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.18 | ColumnmssqlSrvInfoTotalBlockingLocks | read-only | mandatory | A count of all locks blocking other processes. |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.19 | ColumnmssqlSrvInfoUsersBlocked | read-only | mandatory | The number of users blocked by other users. |
| 1.3.6.1.4.1.311.1.4.1.1.3 | TablemssqlSrvConfigParamTable | not-accessible | mandatory | This table contains entries for the SQL Server configuration parameters. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1 | RowmssqlSrvConfigParamEntry | not-accessible | mandatory | mssqlSrvConfigParamTable entries. The SQL Server configuration parameter name is used as the index value. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.1 | ColumnmssqlSrvConfigParamName | read-only | mandatory | Name of SQL Server configuration parameter. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.2 | ColumnmssqlSrvConfigParamMax | read-only | mandatory | The maximum configurable value for the associated SQL Server configuration parameter. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.3 | ColumnmssqlSrvConfigParamMin | read-only | mandatory | The minimum configurable value for the associated SQL Server configuration parameter. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.4 | ColumnmssqlSrvConfigParamConfigValue | read-only | mandatory | The current configured value for the associated SQL Server configuration parameter. |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.5 | ColumnmssqlSrvConfigParamRunValue | read-only | mandatory | The current run value for the associated SQL Server configuration parameter. |
| 1.3.6.1.4.1.311.1.4.1.1.4 | TablemssqlSrvDeviceTable | not-accessible | mandatory | This table contains entries for each SQL Server device on the system. |
| 1.3.6.1.4.1.311.1.4.1.1.4.1 | RowmssqlSrvDeviceEntry | not-accessible | mandatory | mssqlSrvDeviceTable entries. |
| 1.3.6.1.4.1.311.1.4.1.1.4.1.1 | ColumnmssqlSrvDeviceLogicalName | read-only | mandatory | The logical name of the defined database or dump device. |
| 1.3.6.1.4.1.311.1.4.1.1.4.1.2 | ColumnmssqlSrvDevicePhysicalName | read-only | mandatory | The physical name including the file system path and file name. |
| 1.3.6.1.4.1.311.1.4.1.1.4.1.3 | ColumnmssqlSrvDeviceDescription | read-only | mandatory | Detailed description of the device including the type of device, size, and the media type. |
| 1.3.6.1.4.1.311.1.4.1.1.5 | TablemssqlDbTable | not-accessible | mandatory | 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). |
| 1.3.6.1.4.1.311.1.4.1.1.5.1 | RowmssqlDbEntry | not-accessible | mandatory | mssqlDbTable entries. |
| 1.3.6.1.4.1.311.1.4.1.1.5.1.1 | ColumnmssqlDbId | read-only | mandatory | The dbid of the database. |
| 1.3.6.1.4.1.311.1.4.1.1.5.1.2 | ColumnmssqlDbName | read-only | mandatory | The name of the database. |
| 1.3.6.1.4.1.311.1.4.1.1.5.1.3 | ColumnmssqlDbState | read-only | mandatory | 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 P… |
| 1.3.6.1.4.1.311.1.4.1.1.6 | TablemssqlDbInfoTable | not-accessible | mandatory | 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… |
| 1.3.6.1.4.1.311.1.4.1.1.6.1 | RowmssqlDbInfoEntry | not-accessible | mandatory | mssqlDbInfoTable entries. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.1 | ColumnmssqlDbInfoDbId | read-only | mandatory | The dbid of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.2 | ColumnmssqlDbInfoDbName | read-only | mandatory | The name of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.3 | ColumnmssqlDbInfoCreationDateTime | read-only | mandatory | The date and time that the database associated with this row was created. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.4 | ColumnmssqlDbInfoOwner | read-only | mandatory | The owner of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.5 | ColumnmssqlDbInfoSize | read-only | mandatory | The size in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.6 | ColumnmssqlDbInfoUnallocatedSpace | read-only | mandatory | The unallocated space in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.7 | ColumnmssqlDbInfoReservedSpace | read-only | mandatory | The reserved space in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.8 | ColumnmssqlDbInfoDataSpace | read-only | mandatory | The used data space in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.9 | ColumnmssqlDbInfoIndexSpace | read-only | mandatory | The used index space in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.10 | ColumnmssqlDbInfoUnusedSpace | read-only | mandatory | The unused space in KB of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.11 | ColumnmssqlDbInfoLastTrLogDump | read-only | mandatory | The date and time that the latest transaction log dump for this database was taken. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.12 | ColumnmssqlDbInfoLogSize | read-only | mandatory | The size in KB of the transaction log for the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.6.1.13 | ColumnmssqlDbInfoLogSpaceUsed | read-only | mandatory | The percentage of transaction log space for the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.7 | TablemssqlDbOptionTable | not-accessible | mandatory | This table contains the list of possible database options and indicates which are set for a given dastabase. |
| 1.3.6.1.4.1.311.1.4.1.1.7.1 | RowmssqlDbOptionEntry | not-accessible | mandatory | mssqlDbOptionTable entries. The dbid of the database is used as the index value associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.7.1.1 | ColumnmssqlDbOptionDbId | read-only | mandatory | The dbid of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.7.1.2 | ColumnmssqlDbOptionDbName | read-only | mandatory | The name of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.7.1.3 | ColumnmssqlDbOptionSetName | read-only | mandatory | The name of the database option that is set for the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.8 | TablemssqlDbDeviceTable | not-accessible | mandatory | This table contains entries for each device fragment on which a particular SQL Server database has been created or altered. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1 | RowmssqlDbDeviceEntry | not-accessible | mandatory | mssqlDbDeviceTable entries. The dbid of the database is used as index value associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1.1 | ColumnmssqlDbDeviceDbId | read-only | mandatory | The dbid of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1.2 | ColumnmssqlDbDeviceDbName | read-only | mandatory | The name of the database associated with this row. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1.3 | ColumnmssqlDbDeviceFragmentName | read-only | mandatory | The name of a device fragment on which the database has been created or altered. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1.4 | ColumnmssqlDbDeviceFragmentSize | read-only | mandatory | The size in KB of the device fragment on which the database has been created or altered. |
| 1.3.6.1.4.1.311.1.4.1.1.8.1.5 | ColumnmssqlDbDeviceFragmentUsage | read-only | mandatory | Indicates if the device fragment contains data, log, or data and log. |