| 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 andnow 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 |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
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. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
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-editionsWhich section on that page are you seeing a different limit Swepeso? |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 100In above information is return from our server. if it possible allocate more memory 128G Ram into server and improve of performance ? |
|
|
|
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 ? |
|
|
|
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 |
|
|
|
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)? |
|
|
|
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 risingHope this helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
16G ram increase to 128G ram.SQL server