SQL Server Architecture
Dynamically Managing Memory on Windows 95 and Windows 98
When running on Microsoft® Windows® 95 and Windows 98, each instance of Microsoft SQL Server™ 2000 uses a demand-driven algorithm for allocating memory. As more Transact-SQL statements are processed and demand for cached database pages rises, the instance of SQL Server requests more virtual memory. When the demands on the instance of SQL Server go down, such as when fewer Transact-SQL statements are being processed, the instance frees memory back to the operating system.