Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How much memory to allocate to SQL?
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00522092
Message ID:
00522650
Views:
6
>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?

There's actually a formula but I don't have it memorized.

>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?

You do not want SQL Server hitting the swap file. Nor do you want the OS hitting it. SQL Server's dynamic allocation will handle this.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform