Feature Introduction

“Performance statistics” can count the execution performance of SQL and various statistical data of index from various perspectives to help users find problematic SQL and potential performance bottlenecks for targeted optimization. For example, you can find potential problematic SQL from the execution time, execution count, and returned rows of SQL. It can analyze whether the creation and use of indexes are reasonable from the aspects of table scan, least used index, and index size, and provide missing index analysis and creation suggestions.

1. SQL Performance Statistics

The statistical indicator is counted After Executing SQL

7 statistical perspectives supported
- Average execution time
- Execution Times
- Returned rows
- Average CPU time
- Logical read
- Logical write
- Physical read
Customized Statistical Condition
The statistical results can be downloaded in the form of Excel file

II. Slow SQL in Execution

Make statistics on the SQL in Execution and screen the slow SQL which is believed to be concerned by the user

Customized Statistical Condition
The statistical results can be downloaded in the form of Excel file

III. Index performance analysis

5 statistical analysis perspectives supported
- Table scan
- Index update
- Index size
- Absent index
- Index usage
Provide missing index analysis and creation suggestions
The statistical results can be downloaded in the form of Excel file

Introduction of Performance Statistics & Analysis

Products

开始与售前顾问沟通

可直接拨打电话 400-098-8505转1