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 ?