Hello again Grant
Heres what i am finding.
The alert for hash warnings is showing up against server 15 and in the Master database.
I click on 'overview', then my server (server15), then 'local' and that brings up the databases on the server, then i click on 'master' and change the time to the required time when the alert happened (in this case 04:28).
When i look at the query text at the bottom the first query is this :
SELECT cntr_value
FROM sys.dm_os_performance_counters
WHERE object_name = CASE WHEN SERVERPROPERTY('InstanceName') IS NULL
THEN 'SQLServer'
ELSE 'MSSQL$'
+ CAST(SERVERPROPERTY('InstanceName') AS VARCHAR)
END + ':SQL Errors'
AND instance_name = 'User Errors'
From query plan: 0x060001001847c40140a18482000000000000000000000000
*****************************************************************
Another one of the queries reads:
SELECT cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Cache Pages'
AND instance_name = 'SQL Plans';
From query plan: 0x060001009877e62440a1a082000000000000000000000000
The querys dont seem to correlate to the things we run - How are these being generated ?