Unable to show execution plan on SQL server instance in DPA

10/23/2018 6:54 AM

10/23/2018 6:54 AM

When clicking into the plan tab in DPA for SQL server instance you are monitoring, no plans are display and collected.

Database Performance Analyzer

A bug in Microsoft SQL Server 2014 causes the DMV sys.dm_exec_requests to have a NULL value in the query_hash.

Because of this, DPA is unable to link the Plans to the queries.

User will see something like the image below:

This was patched in this bug fix release: "FIX: The values of column query_hash and query_plan_hash are NULL for DMV sys.dm_exec_requests in SQL Server 2014 " (© Microsoft 2018, obtained from https://support.microsoft.com/en-us/help/2953592 on October 2018)
 

Patch the SQL server that is being monitored to allow DPA to not have nulls in this dmv.

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.