How does DLM Dashboard work?
DLM Dashboard detects schema changes on SQL Server instances you want to monitor. If the schema has changed, DLM Dashboard updates the dashboard interface and alerts you.
DLM Dashboard takes a schema snapshot when a database has changed. It compares this snapshot to snapshots of the previous schema states, and records the differences so you can see the changes in the dashboard.
In order to know who made the changes and receive the change notifications quickly, DLM Dashboard uses a DDL trigger on the servers you are monitoring. This DDL trigger adds details of schema changes to a table in database RedGate, and notifies DLM Dashboard in real time.