Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Negative Hash values in DPA

Negative Hash values in DPA

Table of contents

Updated 09/26/2017


This article explains why you may get negative hash values for certain queries detected by DPA.


  • DPA, all versions


  • DPA generated negative hash values because SQL Server gave DPA an empty SQL Handle, i.e. SQL Server did not tell DPA what the SQL was so there is no way to show it.
  • DPA does try to show other info like the user, program and some other values, but drilling into the database and other dimensions may help you understand what it is.
  • Also, use the Sessions tab to see if it's always the same session. If so, try looking at the Current page in DPA to see other data for that SPID.




Last modified