Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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