Performance

The Performance panel enables us to check the databases on server list, which can be accessed on the index analysis server, and carry out index analysis and input/output analysis. Analyses enable us to diagnose issues in the case of slower performance of databases.
The Performance panel can be accessed by clicking the Database panel, which is located on the Administration panel form.
For this purpose, we have prepared a User Manual with the following use cases:
Refreshing the database list |
The Databases on Server list can change, which is why we refresh the list of databases on server that we are accessing before we start the analysis of database performance. |
Index Analysis |
Indexes analysis displays poorly-used indexes since the restart of the SQL server and the missing indexes, based on their acquisition, suggested by the SQL server.
|
Input/Output Analyses |
Input/output analyses display information about the level of drive delay since restarting the server, and calculate the average delay on read and write, and the common input/output for each individual file from the database. |