DLM Dashboard Install Question

jfennell

Does setting up DLM Dashboard monitoring on a database make any changes to the database being monitored, or does it just install triggers on the DDL statements in the database server? I'd like to use it for monitoring one of my production databases, but changes to the database itself need to go through different procedures than if it just adds a new database and triggers at the server level.

Thanks in advance,

~ Jim Fennell

Sergio R

Hi Jim,

Installing DLM Dashboard will setup a DDL trigger and 3 stored procedures setup on the master database and will create a new database on the instance, however, it will not change the schema of any user databases setup for monitoring.

When adding a database to be monitored you need to specify an account able to connect to it but which doesn't need any change permissions on it:

Database account
When you add a database, you provide credentials for an account that DLM Dashboard uses to connect to the database. If you choose Windows authentication, DLM Dashboard will connect to the database with the account that the DLM Dashboard services run under.
This account needs:
the VIEW DEFINITION permission on all objects in monitored databases
the SELECT permission for the system view sys.sql_expression_dependencies
if you have encrypted objects, sysadmin and VIEW SERVER STATE permissions

Further details can be found here:
http://documentation.red-gate.com/displ ... quirements

and here:
http://documentation.red-gate.com/displ ... oard+works

Thank you,