djordan 4543 (1/7/2013)
with the script provided - is there anything in particular to look for . I ran the script during high memory usage and low memory usage and I don't see anything of any particular concern (I don't profess to understand everything the script is doing though).
i qam sorry there is no straight forward bread for this. you need to see the result of each query carefully and before result see "the commented line above of every query"
then you need to dig into the issues.
Are you still seeing continous memory usage ( any particular time period or pattern)? have you seen the sql error log ? or even the system log ?
Have you seen the tempdb usage ? do you have dedicated or separate disk for it ?
and any kind of IO high usage ?
see this link for memory http://blogs.msdn.com/b/karthick_pk/archive/2012/06/15/troubleshooting-sql-server-memory.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)