Not AFAIK.

However, you can use DBCC MEMUSAGE to list the top 20 objects that are
held in memory. So this would be the top list "through usage".

In general, I would be very cautious with pinning tables. There are only
very few situations in which it is useful to pin a table. In general, it
is best to leave it up to SQL-Server to optimize its memory use.

HTH,
Gert-Jan


csomberg@dwr.com wrote:
>
> I'm doing some performance reviews and wish to know what tables SQL has
> pinned in memory and which ones have are loaded through usage ...
>
> Is there a way ?
>
> Thanks,
>
> Craig