Thanks Syed for taking time to reply my question. It does make sense but I am looking for some kind of script to show.

Yes, Jeff.

Thanks guys. Found it.

Thanks Grant, Any particular script do you suggest for compilation/recompilation trouble shoot?

@phil, just play with AdventureWorks database.

Thanks for your reply, but since above query has 'group by' not able to add any other columns!

Thanks read the article. it helped

Thanks goher2000 and Sue_H for taking your time to reply my question. One more thing, what if the 'Cntr_Value' was 300GB? What actions could be taken to make Buffer pool...

It worked!!! Hat's off to you Sue. Thanks you so much for your kind reply.

First of all thanks for your reply. Secondly, sorry, English my second language. Is 'bothering' sounds better? (Don't get me wrong, I like when people point my 'weakness' because that...

thanks goher2000 for your response. 
Just wanted to clear my requirement, I...

Thanks everyone for the inputs

SQLServer Alert System: 'ProdDatabase Percent LogUsed 80%' occurred on \\ProdserverAZ

Thanks millions Eric and Grant.

if you do RDP to the server and right click on SSMS logo it gives your an option as 'run as different user" but it doesn't work on client