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

Database manager

The Databases dashboard and in the dbo.v_databases view includes the following 3 columns: manager_initials, manager_name and manager_mail.

These columns are used to determine, who is the “go to” person for the databases. When doing changes to databases, performing maintenance etc. it can be difficult to know who to inform about such changes. Often the mapping between a database and a person is missing, or is not up-to-date information.

Automated estimation of database managers

Performance Store fills out the manager columns automatically, and try to find the best “estimated” manager for each database. This is based on who accesses the databases the most, and from that information determine what department uses the databases the most. The manager information will be the department manager for the department using the database the most.

Manually setting database managers

Database managers can be set manually by adding or updating rows in the dbo.database_responsible table. By setting the column value of the do_not_auto_set column to 1, the manager values will not be overwritten by the automated manager functionality.

Table of Contents