Measuring Stored Procedure Performance Over Time

BrainDonorBrainDonor Posts: 57 Silver 2
in Redgate Monitor
Is it possible to monitor the performance of stored procedures over time, with Monitor? I'm just fishing for an existing method of watching for performance degradation without having to implement something of my own.
Tagged:
· Share on Twitter

Comments

  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi @BrainDonor,

    There's the query history shown in the Top X queries section (when you select one of the queries, below the query plan), but this would only help if that query entry was representing the single stored procedure and it was displayed in the Top X queries section.

    Beyond that, there currently isn't a way to single out a stored procedure.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.