Thanks for your suggestion. Understanding Microsoft licensing is always a top task for me.

Ok, I would like to be little specific here. Can I collect 'expensive quries by CPU' data for last 24 hours by using a DMV? If yes, could you please...

Thanks for your immediate response. Actually, I am in the process collecting performance data of a SQL Server particularly used for reporting. I was using ‘Performance Dashboard’ to figure out...

Thanks Guys.

The server is belonging to a consumer website and remains busy all the time. So, I am having a challenge in maintaining the index all the time. So,...