I have a "Client" table with over 1 million records which I pinned in memory. The DBCC command returns the message:
" .. If a pinned table is larger, or grows larger, than the available data cache, the server may need to be restarted .. "
I issued a number of broad select statements to load as much of the table in memory as possible. Two questions:
- How do I determine what the "available data cache" size is, from the DBCC message, and
- How do I determine the maximum amount of space the pinned table will require?