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 .
The term that Foglight for SQL Server uses to refer to the amount of disk space by which a File, File Group, Log, or Database can expand. This is a combination of the file's Auto Grow parameters, current size, and the available free disk space.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz