Published 16 June 2014
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.
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
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'.
- 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.