下表列出了每个 Microsoft SQL Server 报告所需的 OMi MP for Microsoft SQL Server 策略和特性。
备注: 请参阅 OMi MP 文档中有关应部署策略的方式以及可能需要的其他部署步骤的信息。
对于 OMi MP for Microsoft SQL Server,数据源名称与数据类名称相同。
报告名称 | 特性名称 | 特性中的策略模板 | HP Performance Agent |
---|---|---|---|
数据源名称 | |||
MSSQL Database and Virtual Device Space Usage Top N | Microsoft SQL Server Space |
MSSQLServer_ 3242 MSSQLServer_ 3240 |
DBSPI_MSS_ REPORT |
MSSQL Performance Summary | Microsoft SQL Server Processes and Statistics |
MSSQLServer_ 3001 MSSQLServer_ 3025 |
DBSPI_MSS_ GRAPH |
Microsoft SQL Server Locks | MSSQLServer_ 3013 | ||
Microsoft SQL Server Transactions | MSSQLServer_ 3009 | ||
Microsoft SQL Server Input and Output Utilization | MSSQLServer_ 3008 | ||
MSSQL Table Space Usage Top N | Microsoft SQL Server Space | MSSQLServer_ 3241 | DBSPI_MSS_ REPORT |
MSSQL Database Input and Output Statistics | Microsoft SQL Server Input and Output Utilization |
MSSQLServer_ 3007 MSSQLServer_ 3008 |
DBSPI_MSS_ GRAPH |
MSSQL Database Locks Summary | Microsoft SQL Server Locks |
MSSQLServer_ 3071 MSSQLServer_ 3013 MSSQLServer_ 3070 MSSQLServer_ 3072 MSSQLServer_ 3075 |
DBSPI_MSS_ GRAPH |
MSSQL Database Performance Summary | Microsoft SQL Server Error | MSSQLServer_ 3023 MSSQLServer_ 3024 | DBSPI_MSS_ GRAPH |
Microsoft SQL Server Data Access Methods |
MSSQLServer_ 3053 MSSQLServer_ 3054 MSSQLServer_ 3051 MSSQLServer_ 3052 |
DBSPI_MSS_ GRAPH | |
MSSQL Database Space Usage Details | Microsoft SQL Server Space | MSSQLServer_ 3240 | DBSPI_MSS_ REPORT |
MSSQL Database Table Space Usage Details | Microsoft SQL Server Space | MSSQLServer_ 3241 | DBSPI_MSS_ REPORT |
MSSQL Instance Availability Details | Microsoft SQL Server Availability | MSSQLServer_ 3243 | DBSPI_MSS_ REPORT |
MSSQL Server Transaction Summary | Microsoft SQL Server Transactions |
MSSQLServer_ 3064 MSSQLServer_ 3066 MSSQLServer_ 3067 |
DBSPI_MSS_ GRAPH |
MSSQL Users Connection Summary | Microsoft SQL Server Processes and Statistics |
MSSQLServer_ 3032 MSSQLServer_ 3026 |
DBSPI_MSS_ GRAPH |
MSSQL Virtual Device Space Usage Details | Microsoft SQL Server Space | MSSQLServer_ 3242 | DBSPI_MSS_ REPORT |
备注: M031_NumUsersCnt 不可用于 SQL 列表。