Recently we had a 2nd hash appear for a query that is run frequently. Exact same query, two different hashes. The queries did not run at the same time.
Any ideas?
Which database platform is this for? Is this a 3rd party application running on this database or is it built in-house?
Can you send in some screenshots of the SQL text including the different hashes? Keep in mind that the hashes can change for what looks to be the same query, but something very minor like whitespace was modified.
We're running SQL2008 on a Win2003r2 box. The query is initiated by the 3rd party ERP application; Epicore Vantage. No customizations to the DB.
The SQL text for both hashes visually looks the same. Let's run a query against the DPA repository to see if SQL Server thinks the text is different somewhere.
-- pick the id value for the monitored instance
SELECT id, name FROM ignite.cond ORDER BY name;
-- replace <DBID> below with id from above query
-- use SQL Server hash function to see if it thinks they
SELECT h, HASHBYTES('MD5', st) AS sql_hash, LEN(st) AS text_length, st AS sql_text
FROM ignite.const_<DBID> WHERE h in (5728427084, 5728435733);
