DLM Dashboard

Requirements

To use DLM Dashboard, you need:

  • SQL Server 2008, 2008R2, or 2012
    SQL Server 2014 and SQL Server 2016 are supported, apart from some new features. See Limitations below for details. 
  • The latest version of Chrome or Firefox, or IE11
  • Operating system: Windows 7 or Windows Server 2008R2 onwards
  • .NET Framework 4.5

You also need to run a setup script on servers you want to monitor. You'll be prompted to do this when you add a server to DLM Dashboard. For more information, see About the DLM Dashboard server objects.

Permissions

Server account

When you add a server, the user account needs these permissions:

Some of these objects are created by the server setup script.

  • on the server:

    • VIEW ANY DEFINITION
  • on all databases you want to monitor:

    • SELECT ON sys.sql_expression_dependencies

  • on master:
    • EXECUTE ON dbo.RG_SQLLighthouse_ReadEvents
  • on the database RedGate:
    • SELECT ON SQLLighthouse.DDL_Events

If you have encrypted objects, the account needs the sysadmin role.

Setting up the server

When you run the setup script on a SQL Server, you need to use an account with the sysadmin role.  The trigger itself is created to EXECUTE AS 'sa'.

Limitations

  • In SQL Server 2014 and later, while the DLM Dashboard DDL trigger is enabled, you can't create or drop memory optimized tables and native compiled stored procedures.
    To create or drop these objects, disable the DDL trigger beforehand, and re-enable the trigger afterwards.
  • In SQL Server 2014 and later, if you access a memory-optimized table in a transaction, that transaction can't make any schema changes (because of a SQL Server limitation).
  • Amazon RDS and Azure databases aren't supported.
  • Merge replication (see MSDN) isn't supported.

Didn't find what you were looking for?