I'm currently analysing a performance issue with some dmv's that return execution performance information (max_worker_time, exec_count, etc) along with the execution plan text and even de query plan xml. Like this:
I can easily extract data from an ssms query result to excel, csv, or text file.
Problem is, the text and query_plan columns contains commands and spaces. I can't export it in an useful way. By that I mean that the exported data won't be useful at all.
If I close the query, I will loose valuable information.
How can I save this data in a way that I can continue with my work later?
Edit: I also know (and actually did it) that I can click each execution plan and save it as a file to analyse later). But I must export the rest of the data to excel,then each query plan manually and name the files by some kind of convention so I can match the query plan with the rest of the information... kinda lame.