Viewing 5 posts - 1 through 5 (of 5 total)
@arvisam on #sqlhelp has asked me to provide memorystatus output. Here is truncated output
Memory Manager ...
March 22, 2013 at 9:01 am
Thanks for all the replies, and yes, hunting around on forums whilst the production system crashes & burns is never fun to watch.
We got it in the end, it was...
March 22, 2013 at 7:22 am
The execution plan wasn't pretty but no missing indexes reported. Although the SSMS toolkit plugin warns the query plan takes 5mb of space.
Looked into the SQL stack dumps and...
March 22, 2013 at 5:59 am
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...
March 22, 2013 at 5:09 am
Thanks for the reply
The server has 24GB mem with SQL set to a max of 20GB and win 2008R2 having 4GB. SQL normally sits at 16GB but something is...
March 22, 2013 at 4:38 am
Viewing 5 posts - 1 through 5 (of 5 total)