Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2013-02-28 : 12:43:33
|
| 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
15732 Posts |
Posted - 2013-02-28 : 13:29:29
|
| 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.aspxhttp://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-05 : 23:38:13
|
| If it is sql server dedicated system you can assign 80 percent of the memory to sql server and remaing 20 for the OS. |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-03-06 : 14:41:20
|
| As standard best practice, set the Sql Server memory to 90% of RAM and page memory to 1.5 times of RAM |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
How much memory can be allocated to sql server