Craig,

This query would show the tables that are "marked for pinning".
SQL-Server does not actively load pinned tables into memory. What
pinning will do is retain all the table's pages that were loaded since
startup.

Gert-Jan


Erland Sommarskog wrote:
>
> (csomberg@dwr.com) writes:
> > 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 ?
>
> SELECT * FROM sysobjects WHERE objectproperty(id, 'TableIsPinned') = 1
>
> I completely share Gert-Jan's recommendation to stay away from DBCC
> PINTABLE.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp