It provides some of what I am looking for. I don't seem to find objects of type 'user table' being generated. My SQL Server reports to be using something like 1.4 GB memory from Sysmon. I was hoping that syscacheobjects will shed like on the objects in memory. However, I will continue with the profiler.
Many thanks once more.
Originally posted by DesmondX
table "syscacheobjects" in master database, for cache usage.
setting up a trace in SQL Profiler is also useful