A table-level option that can be used to force pages from that table to remain in memory after they are accessed. After a page of a pinned table or index is read into the Buffer Cache, it remains there until SQL Server is restarted.
An area of memory that SQL Server uses for storing execution plans so that they can be re-used, thereby avoiding the Recompile procedure. This area of memory was formerly known as Procedure cache. For details, see .
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center