The set of buffer pages that are currently available for immediate re-use. These are SQL Server memory pages that are not currently allocated to any cache. The Free List is maintained by the Lazy Writer process (see glossary definition of Lazy writer ). If the Free List becomes empty, free pages are not immediately available to SQL Server when required, and the connections needing them might have to wait while SQL Server makes buffers available. This can result in lower performance.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center