SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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
 New Topic  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

15720 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

726 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
2127 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  
 New 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.06 seconds. Powered By: Snitz Forums 2000