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.
|
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.
|
|
|
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
|
Name of a the schema used.
|
|
Table
|
Table name.
|
|
Index Name
|
Index name. |
|
Index_id
|
ID of the index:id is unique only within the object. |
|
Is_disabled
|
1 = Index is disabled.
0 = Index is not disabled.
|
|
Is_hypothetical
|
1 = Index is hypothetical and cannot be used directly as a data access path. Hypothetical indexes hold column-level statistics.
0 = Index is not hypothetical.
|
|
Has_filter
|
1 = Index has a filter and only contains rows that satisfy the filter definition.
0 = Index does not have a filter.
|
|
Fill_factor
|
> 0 = FILLFACTOR percentage used when the index was created or rebuilt.
0 = Default value
Always 0 for clustered columnstore indexes.
|
|
Total_Writes
|
Number of updates by user queries. This includes Insert, Delete, and Updates representing number of operations done not the actual rows affected. For example, if you delete 1000 rows in one statement, this count increments by 1
|
|
Total_Reads
|
Number of seeks by user queries + Number of scans by user queries that did not use 'seek' predicate + Number of bookmark lookups by user queries.
|
|
Difference
|
Total_Writes - Total_Reads
|
|
|
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
|
|
|
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
|