← DLM Dashboard

Suggest a new feature or enhancement...

DLM Dashboard: History

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Configure how many events are retained in main DDL_Events table

The installation script should allow the DBA to configure how many events (rows) are stored/retained in the DDL_Events table. As-is, the install script checks for row-count over 512, and if so, deletes the last 420 rows. This should be configurable by the DBA, especially if he/she wants to be able to examine the "raw" event data written to the table instead of / in addition to using the Dashboard GUI.

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…)
Nate Johnson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ji commented  ·   ·  Flag as inappropriate

    This has been raised in more issues. I believe there are considerations mentioned by Redgate to expand on this in due course

  • Nate Johnson commented  ·   ·  Flag as inappropriate

    For example, this could be done with optional-parameters on the stored-procedure RG_SQLLighthouse_WriteEvent, or a central look-up table in RedGate DB where the values could be set/updated at any time by the fastidious DBA.