Secrets of Advanced Windowing Extensions: Making Sure Your SQL Server Has "Air to Breathe"

I'd like to put a spotlight on several NAV/SQL matters--things I consider important (maybe picking something from my book "The NAV/SQL Performance Field Guide"), not too detailed but still technical enough ..."NAV/SQL Quickies".

SQL and Memory Madness

"Memory" - or physical RAM - of a computer is something we consider naturally like the air we breathe - it's there, we take it. But just like our air is only breathable with the optimal mixture of Nitrogen, Oxygen & Co. also "Memory" is only usable if configured correctly.

At first it is necessary to understand the technical limitations of computers: a 32bit system could allocate 2³² Bytes, that's 4 Giga Bytes - no more, no less. Out-of-the-box a MS Windows Operating System "splits" this RAM 50:50 - half of the Memory is assigned to the OS, the other half is granted to application.

Hence, any application can only use 2 GB of RAM at maximum - and of...