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

anoop_mig25
Starting Member

India
13 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

robvolk
Most Valuable Yak

USA
15688 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:

http://msdn.microsoft.com/en-us/library/ms178067.aspx
http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
691 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

srimami
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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 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.
http://www.sqlserver-dba.com/2010/10/sql-server-2005-memory-configuration-management.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
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.08 seconds. Powered By: Snitz Forums 2000