Applications Systems

DPA does not display some SQL Server graphical plans

DPA collects SQL Server plans and displays them in graphical format, similar to the way SQL Server Management Studio does. Sometimes, however, DPA does not display the plan and instead shows this message: Graphical SQL plan could not be displayed.

First published date

10/16/2018 1:35 PM

Last published date

5/10/2019 5:20 PM

Overview

PA collects SQL Server plans and displays them in graphical format, similar to the way SQL Server Management Studio does. Sometimes, however, DPA does not display the plan and instead shows this message:

Graphical SQL plan could not be displayed.

This article explains why DPA displays the message above.

Product section

Database Performance Analyzer

Resolution

The SQL Server plan is actually an XML file, and DPA gives you the ability to download the plan XML file to your computer with a .sqlplan extension. If you open up the plan XML file, you will see that it contains a <statements> node, and beneath it you will see one of the following nodes:

<StmtSimple>       
<StmtCursor>
<StmtCond>
<StmtCursor>
<StmtReceive>
<StmtUseDb>

DPA supports only StmtSimple. DPA displays the message above for all other statement types. To see the plan, download the plan file and open it in SQL Server Management Studio.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.