... SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API.
On a Microsoft Windows 2000 Server-based system, SQL Server periodically calculates the free physical memory on the system by using the native Windows API.
Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server responds to the current memory situation on a specific system...