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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 16G ram increase to 128G ram.SQL server

Author  Topic 

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-24 : 11:48:22
Anyone can help give idea. Our old sql server the ram size is 16G and
now already incrase 12BG Ram. but check the SQL memory is still using average around 30-50G Ram only , how to make server can full using all the 128G ram ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-24 : 15:02:44
It will not use all RAM if there is no need! SQL Server will only use as much RAM it need to populate the data cache.
In fact, perhaps your whole database are in memory right now?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-25 : 06:22:31
use this code to check how much memory is used - http://www.sqlserver-dba.com/2013/05/task-manager-not-showing-correct-sql-server-memory-usage.html

Is the sql server max memory configured? if so , what is the value?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-08-25 : 10:42:59
Also, if you are not using Enterprise edition, each instance can use only a maximum of 64 GB even if you have 128 GB of installed memory on the OS.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-25 : 12:02:28
James, not so true in 2012 http://msdn.microsoft.com/en-us/library/cc645993.aspx



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-08-25 : 14:02:01
The "Cross-Box Scale" section on the page for SQL 2012 says 64 Gigs (but I have no idea what the term cross-box refers to) msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx#CrossBoxScale Also, the SQL Mag article here http://sqlmag.com/sql-server-2012/sql-server-2012-editions

Which section on that page are you seeing a different limit Swepeso?

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-25 : 14:30:00
I see 128 GB when choosing 2012 or 2014. No difference, which is strange...
I will try another browser.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-25 : 14:32:26
That did it. My mistake, 64Gb on 2012 och 128GB on 2014.
Cross Box is probably when you install the product yourself and not using SQL Azure.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-26 : 00:10:28
phyical_memory_in_use_kb locked_page_allocation_kb memory_utilization_percentage.
29183472 0 100

In above information is return from our server. if it possible allocate more memory 128G Ram into server and improve of performance ?
Go to Top of Page

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-26 : 00:28:04
our server is 2008 and 64 bit. now installed 128G Ram but only used of 32G Ram why ?
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-26 : 02:29:51
@useflix - could you return the value for sp_configure 'max server memory' ?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2014-08-26 : 13:47:32
Can you also supply the OS Edition (Standard/Enterprise) and SQL Edition (Standard/Enterprise)?
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-08-27 : 05:25:18
You are unnecessarily worrying. SQL Server memory utilization is purely dynamic it would adjust memory as per required. To test this just create a dummy table start inserting records in it at same time do many select * on the different tables ( this could cause laod on system so do it on your own risk) you would see SQL Server memory utilization rising

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -