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 |
|
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 |
|
MssqlDbDeviceEntry |
|
SEQUENCE |
|
|
|
|
mssqlDbDeviceDbId |
INTEGER |
|
|
mssqlDbDeviceDbName |
DisplayString |
|
|
mssqlDbDeviceFragmentName |
DisplayString |
|
|
mssqlDbDeviceFragmentSize |
INTEGER |
|
|
mssqlDbDeviceFragmentUsage |
DisplayString |
|
mssqlSrvEntry |
1.3.6.1.4.1.311.1.4.1.1.1.1 |
mssqlSrvTable entries. |
OBJECT-TYPE |
|
|
|
|
MssqlSrvEntry |
|
|
mssqlSrvInfoEntry |
1.3.6.1.4.1.311.1.4.1.1.2.1 |
mssqlSrvInfoTable entries. |
OBJECT-TYPE |
|
|
|
|
MssqlSrvInfoEntry |
|
|
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 |
|
|
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 |
|
|
mssqlSrvDeviceEntry |
1.3.6.1.4.1.311.1.4.1.1.4.1 |
mssqlSrvDeviceTable entries. |
OBJECT-TYPE |
|
|
|
|
MssqlSrvDeviceEntry |
|
|
mssqlDbEntry |
1.3.6.1.4.1.311.1.4.1.1.5.1 |
mssqlDbTable entries. |
OBJECT-TYPE |
|
|
|
|
MssqlDbEntry |
|
|
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) |
|
mssqlDbInfoEntry |
1.3.6.1.4.1.311.1.4.1.1.6.1 |
mssqlDbInfoTable entries. |
OBJECT-TYPE |
|
|
|
|
MssqlDbInfoEntry |
|
|
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 |
|
|
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 |
|
|