Database
Database - analytics console
The functionality is accessed through the menu Settings │ Program │ Administration panel.
The following is a description of the functionality of the form.
Table of contents
- Database on server
- Indexes Analysis
- Input/Output Analysis
|
1. Database on server
|
Refresh database
|
Update database list on server.
|
|
Analyse
|
The button performs the process of analyzing databases on the server and displays the results on the right side of the form.
|
|
 (Checkbox)
|
The selection of databases that we want to consider is carried out by clicking on the selection field. An orange tick indicates that the database is selected. If there is no tick, the database is not selected.
|
2. Indexes Analysis
|
|
The Database filter allows you to display the results of the analysis only for the desired databases on the server. By clicking on the arrow, a list of databases will appear, where by clicking on the selection field we can specify for which databases we want to display the data. 
|
|
Database
|
The name of the database on the server.
|
|
Scheme Name
|
PREDRAG DOPOLNI
|
|
Table
|
PREDRAG DOPOLNI
|
|
Index Name
|
PREDRAG DOPOLNI
|
|
Index_id
|
PREDRAG DOPOLNI
|
|
Is_dosabled
|
PREDRAG DOPOLNI
|
|
Is_hypothetical
|
PREDRAG DOPOLNI
|
|
Has_filter
|
PREDRAG DOPOLNI
|
|
Fill_factor
|
PREDRAG DOPOLNI
|
|
Total_Writes
|
PREDRAG DOPOLNI
|
|
Total_Reads
|
PREDRAG DOPOLNI
|
|
Difference
|
PREDRAG DOPOLNI
|
|
|
The Database filter allows you to display the results of the analysis only for the desired databases on the server. By clicking on the arrow, a list of databases will appear, where by clicking on the selection field we can specify for which databases we want to display the data. 
|
|
Database
|
The name of the database on the server.
|
|
Index_advantage
|
PREDRAG DOPOLNI
|
|
Last_user_seek
|
PREDRAG DOPOLNI
|
|
DatabaseSchemeTable
|
PREDRAG DOPOLNI
|
|
Missing_indexes_for_table
|
PREDRAG DOPOLNI
|
|
Similar_missing_indexes_for table
|
PREDRAG DOPOLNI
|
|
Equality_columns
|
PREDRAG DOPOLNI
|
|
Inequality_columns
|
PREDRAG DOPOLNI
|
|
User_seeks
|
PREDRAG DOPOLNI
|
|
Avg_total_user_cost
|
PREDRAG DOPOLNI
|
|
Avg_user_impact
|
PREDRAG DOPOLNI
|
|
ShortQueryText
|
PREDRAG DOPOLNI
|
|
TableName
|
PREDRAG DOPOLNI
|
|
TableRows
|
PREDRAG DOPOLNI
|
3. Input/Output Analysis
|
|
The Database filter allows you to display the results of the analysis only for the desired databases on the server. By clicking on the arrow, a list of databases will appear, where by clicking on the selection field we can specify for which databases we want to display the data. 
|
|
Database
|
The name of the database on the server.
|
|
Drive
|
PREDRAG DOPOLNI
|
|
VolumeMountPoint
|
PREDRAG DOPOLNI
|
|
ReadLatency_ms
|
PREDRAG DOPOLNI
|
|
WriteLatency_ms
|
PREDRAG DOPOLNI
|
|
OverallLatency_ms
|
PREDRAG DOPOLNI
|
|
Avg_Bytes_Read
|
PREDRAG DOPOLNI
|
|
Avg_Bytes_Write
|
PREDRAG DOPOLNI
|
|
Avg_Bytes_REadWrite
|
PREDRAG DOPOLNI
|
|
|
The Database filter allows you to display the results of the analysis only for the desired databases on the server. By clicking on the arrow, a list of databases will appear, where by clicking on the selection field we can specify for which databases we want to display the data. 
|
|
Database
|
The name of the database on the server.
|
|
FileName
|
PREDRAG DOPOLNI
|
|
FileType
|
PREDRAG DOPOLNI
|
|
FileSize_MB
|
PREDRAG DOPOLNI
|
|
Avg_Read_Latency_ms
|
PREDRAG DOPOLNI
|
|
Avg_Write_Latency_ms
|
PREDRAG DOPOLNI
|
|
Avg_IO_Latency_ms
|
PREDRAG DOPOLNI
|