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).
Maria_SS
Posts: 1 New member
Answers
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).