Exporting SQL queries and stats from the Top Queries list

Maria_SSMaria_SS Posts: 1 New member
in Redgate Monitor
Can you export the TOP 10, 25, or 50 SQL statements to an output file like MS Excel?
Tagged:
· Share on Twitter

Answers

  • ThomasBEThomasBE Posts: 24 Bronze 3
    You could use the 'longest running queries' tile and copy that to an Excel file.
    You can also email it but that is less nice if you wanna work with the data afterwards.

    If you want to export the 'top' view in the monitor tab I would rather download the query plan and track the query so you can follow up on performance influence by your changes.
    Dumping the top 50 in anyone's queue will just cause nothing to happen because nobody can tune 50 queries at the same time.
    Focus on 1 or 2 and than move on to the next (which would require a new top since you made some changes on server level perhaps).
    · Share on Twitter
Sign In or Register to comment.