Skip to content

DLM Dashboard

DLM Dashboard (previously called SQL Lighthouse) is a tool that monitors your database schemas in order to alert you about unexpected changes – often called database drift. Once alerted, users can choose to take remedial action. This might be to rollback the change, apply it to another database or script the change into version control. To find out more about what DLM Dashboard does and how it works, please visit our “website”: http://www.red-gate.com/products/dlm/dlm-dashboard/.

If you have any questions or need help with Redgate’s free tool DLM Dashboard, please visit our “support forums”: http://www.red-gate.com/MessageBoard/viewforum.php?f=176.

DLM Dashboard

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Suggest a new feature or enhancement...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

164 results found

  1. HISTORY. Simple way to compare past 14 days to current day and see what changed the most?

    I cant seem to see more than a couple hours EVERY CRISIS like what we just had and found to be the SAPHOS Client, but everyone was claiming it was SQL, what changed last week compared to today/?? I cant provide that.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. It would be great if the hostname who made the change was included, incase people use the same login name

    It would be great if the hostname who made the change was included, incase people use the same login name. We have developers who all use the same login e.g. developer so seeing who made the change is not possible, as it says login name developer but can it also include hostname e.g. pauls-laptop

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Ability to post review using command line utility

    Ability to post review using command line utility or web-service call.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Complete SQL of chages

    Hi

    Is there a way to get the whole SQL corresponding to all changes, in one file?

    Thanks

    Regards

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. When reviewing changes, instead of showing the entire sproc only show the line or lines that changed

    When reviewing a drift in sprocs running hundreds of lines of code, it is hard to find the line that changed because the UI presents the full file with no links or shortcuts to the changes. Since the full SQL statement is available as a download, the UI should only show the changed lines and maybe +3 lines above or below for context.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Ability to configure email notifications based on the pipeline

    So we have specific groups that work on certain projects/pipelines. The ability to configure email notification groups based on the pipeline there're working on would be awesome i.e. group A working on pipeline A only gets pipeline A drift notifications. Group B working on pipeline B only gets pipeline B drift notifications

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Add additional authentication methods for email server configuration

    I'm unable to configure email alerts right now because of how our certificate and DNS are configured, which results in name mismatches--if I use the correct name that resolves to an internal address, I get a certificate name mismatch. If I use the name on the certificate, I end up connecting to the wrong IP address. Thus, the only way I can configure alerts is to disable the secure connection, which I don't want to do. It would be nice to have some other options here so I could work around the certificate name problem.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. How to filter out GRANT EXECUTE

    I have installed a filter that excludes all User and Role changes. However, a SQL GRANT EXECUTE TO user statement appears as an Update. The type is Unknown. Is it possible to filter these out as well?

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Wasted Screen Real Estate

    On all tabs, particularly the Home tab, there is way too much wasted screen real estate. On my 1920*1080 resolution monitor, I can see a whopping 2.5 rows (pipelines) at once. That's ridiculous.

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Stored Session Login

    I currently have to login to the DLM Dashboard every time I reopen the browser. I don't have to do this with SQL Monitor. I want the DLM Dashboard login to persist in a similiar fashion to SQL Monitor

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. DLM Dashboard Memory Leak

    Hi RedGate,

    I tried out DLM Dashboard today. I set it up to monitor a handful of servers (16 DBs in total) around 4 hours ago. It was installed on a VM with only 4GB of RAM, but the requirements at http://documentation.red-gate.com/display/DDB1/Requirements?_ga=1.195114735.2137023563.1395078488 did not list a RAM requirement, so I wasn't expecting it to be an issue.

    Just now I was forced to restart the DLM SQL Server Monitoring Service because it was consuming almost all of the system's available RAM, and in the time that I have been writing this it has already climbed back up to over 2.5GB.

    …

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Allow "Download Raw" alongside "Download SQL"

    When reviewing changes, you can click "Download SQL", which prompts a file download for a .sql file. The server response forces a file download prompt by sending the .sql file with "Content-Type: application/octet-stream".

    Sometimes I want to download the SQL but I don't really need it to be a file; just inline in the browser is fine because I just want to copy a few lines to the clipboard or something. The file download just turns into a lot of needless clicks. It would be nice if the "Download SQL" link were "Download SQL File | Raw".

    Clicking File…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Better filter documentation

    Please expand the filter documentation to have an example for each type of filter available.

    Also, allow me to filter out those changes that are listed as " The object may have been rolled back." We drop indexes and then rebuild indexes as part of daily data loads. I don't need to see this in the list.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. Support Availability Groups

    Allow DLM Dashboard to seamlessly support databases that are in Availability Groups.

    Currently, you have to create the objects on one server, then fail the AG over to the other servers, and recreate the objects there. Otherwise, when the AG is failed over, DLM has problems.

    Ideally, this process would be seamless, behind-the-scenes (or maybe with a prompt to the user configuring the DB for use with DLM Dashboard to indicate that the DB is part of an AG, and therefore the process will also run against the other servers).

    (Logged off the back of a support ticket 55607)

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Compare environments in real time (ex. dev vs test vs uat)

    Show differences between prod/test/dev/uat environments and track these changes.

    45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. An ability to ignore column and index order

    It would be nice to have an option to ignore column order and index order

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. Bulk acknowledge same change made to multiple databases

    I would like to be able to bulk acknowledge the same changes made to multiple databases in a pipeline.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. Filter by APP_NAME

    Add a filter option for jobs by APP_NAME

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. Ability to specifiy the name of the database Ddashboard deploys to SQL server

    When Dashboard is setup the default database name is Redgate, this doesn't always fit in with our database name standards. The ability to choose the name would be useful.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  20. Don't show default collation for a column when collation isn't specified in the script that's been run

    Currently when we see a new table, the NVARCHAR columns also specify the collation that they are using. If the collation was not specified and the default is being used, I would like to not see the collation in the diff shown in the dashboard.

    This is likely an issue in more places than just new tables, likely other spots with (N)VARCHAR columns.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
1 2 3 5 7 8 9
  • Don't see your idea?