That explains how to set memory limits. It also suggests that SQL shouldn't run a machine out of memory, as it checks for available memory before allocating.