Skip to content

[QUESTION] Plan Viewer for external execution plans #359

@ClaudioESSilva

Description

@ClaudioESSilva

Which component is your question about?

Full Dashboard / Lite

Performance Monitor Version

vNext

Is your question about how it works, or the results?

Contributing / development

What's your question?

Could we have the "Plan Viewer" not only at the server level (when we are in a server tab), but also at the application level (without the need to connect to a specific server)?

I love the rules being implemented, and it will be useful to leverage this to analyse other plans that may not be from servers we are conneted too.
If a client shares a .sqlplan with us, and we can open it in the "Plan Viewer" of the PerformanceMonitor, we can benefit from all the rules/checks being done and shown.

Here is (a quick) PoC I'm playing with, and it works like a charm!
Image

These additions allow:

  • Open a ".sqlplan" file that you have in your file system
  • Drag & Drop a plan from a file
  • Paste some XML text you have in your clipboard (either by clicking the button or just "paste")

Do you see this as a possibility?

My idea would be having a "External Plan Viewer" button that opens an "External Plan Viewer" tab on the same level as the "Overview", "Alert History", "server1", "server2", "serverN".

This way, we won't need to connect to a server to open a plan.

I would keep the "Plan Viewer" within each server tab, as it's better for context/scope.

Before I keep playing with it, I would like to know what you think.

Additional Context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions