devdocs (6/11/2013)
Thanks Dave...One more question:
Will this query (Finding queries to tune) be executed in Master DB only???
The DMVs look at overall cache, not just a specific database. I ran it against three different production databases and got (largely) the same results, nothing indicating that it was DB-specific.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]