Database - analytics console

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_id

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