Post reply

Query Store regressing queries Report: can I get its results without GUI?

  • June 17, 2020 at 4:10 pm

    #3763930

    The GUI is beautiful and all.

    Yet only Sr. Prod DBAs can access that, noone else, in our environment.

    Can I request them to send me that report in any other format than visual/direct access via GUI?  How?

    is there a ready script for something like that somewhere by any chance?

    Thank you.

    Likes to play Chess

  • June 18, 2020 at 1:02 pm

    #3764150

    I don't have a handy script for that. However, generating one would be really easy. Run the report. Capture the query it uses. Done.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 18, 2020 at 2:05 pm

    #3764164

    Use the Extended Events profiler to do this.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply