Skip to content

Barry Smallman

← Redgate Monitor

My feedback

1 result found

  1. Install SQL Monitor without needing to provision a (large) SQL Server database

    153 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…)
    34 comments  ·  Suggestions  ·  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
    Adam responded

    We’ve made some improvements in this area but will leave it open so you can continue to give us your suggestions

    An error occurred while saving the comment
    Barry Smallman commented  · 

    The data stored within the RedGateMonitor database is extremely detailed and the database can grow very large.
    What I would like to do is to copy the data stored in the database to a new database, and to aggregate the data, so that I can retain data for a far longer period of time.
    I would like to have the data aggregated into Daily, Weekly and Monthly tables.
    Once this has been done, I can then create SSRS reports that will be able to show trends over longer periods of time.

    Is there any guidance on how this can be achieved?

    Barry Smallman supported this idea  · 

Feedback and Knowledge Base

(thinking…)