>The MS line is to allow SQL Server to dynamically manage memory. More memory is always good as long as you don't starve the OS or any other application on the box.
>
>-Mike

Mike,
how much memory does the OS need? I guess I need to monitor that and not let the memory spill into the swap file, right?

If I let SQL Server manage it dynamically, will it start using the swapfile? If so, is that a preferred practice over limiting the memory to installed RAM?

Thanks,