How can we help you today? How can we help you today?

DLM Dashboard Install Question

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
jfennell
0

Comments

1 comment

Sort by
  • 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,
    Sergio R
    0

Add comment

Please sign in to leave a comment.