Essentially I'm looking for a query that will give me the size of each table and index and the percentage of that object that is in RAM presently. I've got several queries to report the total size of the tables and indexes. I can't see how to determine
if any of those data pages are presently in RAM. Is that information available with a performance query of some kind?
View Complete Post