Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How much memory can be allocated to sql server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

20 Posts

Posted - 02/28/2013 :  12:43:33  Show Profile  Reply with Quote
hi how much memory can be allocated to sql server.

When i use SSMS to set sql server memory. A default number is displayed i.e 2,147,483,648. Is this number in kb ,mb or in GB.

Or this number doen`t has any significance and what we type that much amount of memory in mb is allocated to sql server.please clear my doubt

Most Valuable Yak

15732 Posts

Posted - 02/28/2013 :  13:29:29  Show Profile  Visit robvolk's Homepage  Reply with Quote
The number is in MB, it's the maximum amount that SQL Server will reserve for buffering data and procedure code. There is still some additional memory it will reserve beyond that, but it's not much.

There's more information on how to set the memory limit and what the capacities are:
Go to Top of Page

Aged Yak Warrior

737 Posts

Posted - 03/05/2013 :  23:38:13  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
If it is sql server dedicated system you can assign 80 percent of the memory to sql server and remaing 20 for the OS.
Go to Top of Page

Posting Yak Master

160 Posts

Posted - 03/06/2013 :  14:41:20  Show Profile  Reply with Quote
As standard best practice, set the Sql Server memory to 90% of RAM and page memory to 1.5 times of RAM
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 03/07/2013 :  01:47:45  Show Profile  Visit jackv's Homepage  Reply with Quote
I'd recommend you profile the memory requirements of other applications on the OS - such as anti virus , monitoring agents and identify the memory requirements , then you know how much memory is available for SQL Server.

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000