To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance...
It is evident that SQL Server 2005 component handles memory differently as compared to SQL Server 2000 version. As one of the KBA refers SQL Server 2000 Enterprise Edition introduces support for the use of Microsoft Windows 2000 Address Windowing Extensions...