• 网络与数据中心管理
  • 服务器与应用性能管理
  • IT服务管理
  • Windows AD域管理
  • 终端管理
  • IT安全
  • MSP
  • IT运维平台
 
 
应用性能管理(APM)
保证物理、虚拟、云环境的应用性能
 
 
简化终端设备管理
全面管控PC计算机、智能手机以及平板电脑,确保网络安全
 
 
IT运维外包服务工具
多租户模式,为您的客户提供更好的服务
IT运维管理平台
统一监控、集中运维
 

Monitor Costly Missing Indexes

Whenever a query is executed by the SQL server, it creates an index. These indexes will have varying degrees of impact on performance of the database. Hence it is vital to find out the list of missing indexes and monitor them to ensure smoother operation. SQLDBManager Plus captures the list of cost of missing indexes and displays the data in a tabular format. This data is sorted by:

  • Total Cost
  • Average User Impact
  • Table Name
  • Equality Usage
  • Inequality Usage
  • Include Columns

SQLDBManager Plus also allows the DBA to configure alarms for the Total Cost. Whenever the threshold value of Total Cost is breached, the DBA gets instant notification making it easier for the DBA to troubleshoot the problem quickly.

Related SQL Query Monitoring Features:

收缩