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
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 16G ram increase to 128G ram.SQL server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

usafelix
Yak Posting Veteran

Hong Kong
90 Posts

Posted - 08/24/2014 :  11:48:22  Show Profile  Reply with Quote
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

Sweden
30249 Posts

Posted - 08/24/2014 :  15:02:44  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 08/25/2014 :  06:22:31  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

3660 Posts

Posted - 08/25/2014 :  10:42:59  Show Profile  Reply with Quote
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

Sweden
30249 Posts

Posted - 08/25/2014 :  12:02:28  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

3660 Posts

Posted - 08/25/2014 :  14:02:01  Show Profile  Reply with Quote
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

Sweden
30249 Posts

Posted - 08/25/2014 :  14:30:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Sweden
30249 Posts

Posted - 08/25/2014 :  14:32:26  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Yak Posting Veteran

Hong Kong
90 Posts

Posted - 08/26/2014 :  00:10:28  Show Profile  Reply with Quote
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
Yak Posting Veteran

Hong Kong
90 Posts

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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 08/26/2014 :  02:29:51  Show Profile  Visit jackv's Homepage  Reply with Quote
@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

USA
797 Posts

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

Shanky
Starting Member

United Kingdom
48 Posts

Posted - 08/27/2014 :  05:25:18  Show Profile  Reply with Quote
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
  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