Skip to main content
How can we help?
< All Topics
Print

Table usage dashboard

The Table usage dashboard contains information about how tables are used:

The dashboard shows the number of read- and write operations per table in each database. This information is very valuable when creating indexes to determine the usage pattern for the table. E.g. if a table has 5 % read operations and 95 % write operations, it might not be sensible to create an index to support the read operations, since all the write operations would be slowed down due to maintaining the index.

Since all read- and write operations on each table is available, also historically, the dashboard can also be used to find tables that are never used.

Note, read- and write operations on this dashboard are not the same as e.g. logical reads, physical reads, etc. One read operation is e.g. a user lookup or a table scan, whereas a write operation is an update-, delete- or insert operation.

Corresponding views in the Performance Store database:
dbo.v_hist_table_usage

Other relevant views in the Performance Store database:
dbo.v_indexes
dbo.v_missing_indexes

Table of Contents