How to query highest Log Send Queue Values

FrankSchneiderFrankSchneider Posts: 8
edited June 22, 2016 4:29PM in SQL Monitor Previous Versions
In our Production environment sometimes SQL Monitor trigger the Error - Replication is falling behind.
To find out the cause of lagging it would be helpful to query the database for the Log Send Queue Values. ( Timestamp of the highest values ) over a period of a week.
Unfortunately i am not able to write a query to get these values...

Any suggestions ?

Comments

  • Hi Frank,

    Thanks for contacting Redgate support.

    I believe the attached article will help in keeping an eye on the log queue https://blogs.msdn.microsoft.com/sapons ... itoring-i/.
    I'm not sure if there is anything specific in the SQL Monitor database that can be used to assist in this case.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • The idea was to query the SQL Monitor Database where the values are still persisted ;-).
  • Alex BAlex B Posts: 1,151 Diamond 4
    Hi Frank,

    We don't officially support querying the RedGateMonitor data repository. In this instance, the data you are looking for should be available in the UI. If you go to the Analysis tab the option for "Log send queue" is near the bottom under the "Availability group metrics" section. You would then be able to set the time frame to 7 days (or your own custom time frame) and export to csv using the link just above the graph to get the data you are looking for.

    I hope this helps!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Hi Alex

    not my preferred opinion but thanks for the hint.
    Handling with CSV Export / Import is time consuming manual work and thats not what im looking for.

    regards, Frank
Sign In or Register to comment.