mealies (3/22/2013)

---

ok running this query

select *

from sys.dm_exec_query_stats qs cross apply sys.dm_exec_sql_text(sql_handle) st

ORDER BY qs.total_logical_reads DESC

. Am assuming that this DMV data is since the last fail over at 6:17am this morning.

1 proc has been executed 999 times with a total_logical_read = 453124440

Having never looked at these figures before its hard to analyse but, iirc that indicates that this proc is trying to read an awful lot of data for only 1000 executions. I assume that wont help memory issues