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

User activity dashboard

The User activity dashboard shows information about users and their activity in the databases. The dashboard can be used to determine if/when any activity was present in a database:

User activity in a database is registered when a user executes a query in the database with a duration of 5 seconds or more, or a user executes a query in a database with a duration of less than 5 seconds but the query fails.

Important: If a user executes a succesful query in a database with a duration of less than 5 seconds, it will not be registered as user activity in the database.

Exception are:

  • If Performance Store takes a sample of the server when the user statement has executed for e.g. 3 seconds, then it will still be registered as user activity.
  • If a user executes a statement (no matter the duration), and Extended Audit is enabled.


To exclude users to be registered as creating activity, e.g. to exclude a DBA, add the users to the dbo.user_activity_whitelist table.

Corresponding views in the Performance Store database:
dbo.v_user_activity

Other relevant views in the Performance Store database:
dbo.v_databases
dbo.v_unused_databases (Contains information about databases that are unused)
dbo.v_unused_databases_info (Contains information about when a database is about to be set offline)
dbo.v_offline_databases

Table of Contents