E10 Server RAM - How much?

There's more to it than that...

How many users?
What modules are you using?
Size of DB? 

Obviously if you throw more at it, you will have it run faster...

Sent from my iPhone

On Oct 4, 2014, at 3:19 PM, "Jason Claggett jason@... [vantage]" <vantage@yahoogroups.com> wrote:

 

We are recommending 64 - 128 GB of RAM.

Thanks,

Jason Claggett
Vice President of Technology
2W Technologies, Inc.
Epicor Certified Partner
312.533.4033 x8039
jason@...

Hi All,

How much RAM are people throwing at their SQL Server E10 server?

I know SQL Server will take whatever it can get but I was trying to figure out how much was “enough”.

Right now our production server will have 64GB but I’m thinking of upping it.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:8f8f68.png@73b23f92.4aab1390]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
Jose,
 
Is your 64 gig database on E 9 or E10?  We found when we went t oE10 our database size dropped from 56 gig to 25 gigs.  We have 64 Gis of memory in our E10 server and it works well.
 

To: vantage@yahoogroups.com
From: vantage@yahoogroups.com
Date: Fri, 3 Oct 2014 13:19:56 +0000
Subject: [Vantage] E10 Server RAM - How much?

 

<div id="ygrps-yiv-1925851431ecxygrp-text">
  
  
  Hi All,


How much RAM are people throwing at their SQL Server E10 server?

I know SQL Server will take whatever it can get but I was trying to figure out how much was “enough”.

Right now our production server will have 64GB but I’m thinking of upping it.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:8f8f68.png@73b23f92.4aab1390]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]


</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div>

48GB on ERP server and 64GB on the SQL Server – both Hyper-V VMs.  We are not converting from 9 and are supporting only 60 full and 37 MES clients (when we go live) so our load may be less demanding.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, October 03, 2014 8:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 Server RAM - How much?

 

 

Hi All,

How much RAM are people throwing at their SQL Server E10 server?

I know SQL Server will take whatever it can get but I was trying to figure out how much was “enough”.

Right now our production server will have 64GB but I’m thinking of upping it.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:8f8f68.png@73b23f92.4aab1390]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]

We put 96GB on ours.


From: "Joe Rojas jrojas@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, October 3, 2014 8:19 AM
Subject: [Vantage] E10 Server RAM - How much?

 
<div id="ygrps-yiv-202048582yiv8937895079ygrp-text">
  
  
  <div>Hi All,


How much RAM are people throwing at their SQL Server E10 server?

I know SQL Server will take whatever it can get but I was trying to figure out how much was “enough”.

Right now our production server will have 64GB but I’m thinking of upping it.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:8f8f68.png@73b23f92.4aab1390]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079 -- #ygrps-yiv-202048582yiv8937895079ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp #ygrps-yiv-202048582yiv8937895079hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp #ygrps-yiv-202048582yiv8937895079ads {
margin-bottom:10px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp .ygrps-yiv-202048582yiv8937895079ad {
padding:0 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp .ygrps-yiv-202048582yiv8937895079ad p {
margin:0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mkp .ygrps-yiv-202048582yiv8937895079ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ygrp-lc {
font-family:Arial;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ygrp-lc #ygrps-yiv-202048582yiv8937895079hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ygrp-lc .ygrps-yiv-202048582yiv8937895079ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity span {
font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity span span {
color:#ff7900;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079activity span .ygrps-yiv-202048582yiv8937895079underline {
text-decoration:underline;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079attach div a {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079attach img {
border:none;padding-right:5px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079attach label a {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079bold a {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 dd.ygrps-yiv-202048582yiv8937895079last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 dd.ygrps-yiv-202048582yiv8937895079last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 dd.ygrps-yiv-202048582yiv8937895079last p span.ygrps-yiv-202048582yiv8937895079yshortcuts {
margin-right:0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079attach-table div div a {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079attach-table {
width:400px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079file-title a, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079file-title a:active, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079file-title a:hover, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079file-title a:visited {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079photo-title a, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079photo-title a:active, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079photo-title a:hover, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div.ygrps-yiv-202048582yiv8937895079photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 div#ygrps-yiv-202048582yiv8937895079ygrp-mlmsg #ygrps-yiv-202048582yiv8937895079ygrp-msg p a span.ygrps-yiv-202048582yiv8937895079yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079green {
color:#628c2a;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 o {
font-size:0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079photos div {
float:left;width:72px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079reco-category {
font-size:77%;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079reco-desc {
font-size:77%;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 .ygrps-yiv-202048582yiv8937895079replbq {
margin:4px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg select, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 input, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg pre, #ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 code {
font:115% monospace;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-mlmsg #ygrps-yiv-202048582yiv8937895079logo {
padding-bottom:10px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-msg p#ygrps-yiv-202048582yiv8937895079attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-reco #ygrps-yiv-202048582yiv8937895079reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-sponsor #ygrps-yiv-202048582yiv8937895079ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-text {
font-family:Georgia;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-text tt {
font-size:120%;}

#ygrps-yiv-202048582 #ygrps-yiv-202048582yiv8937895079 #ygrps-yiv-202048582yiv8937895079ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-202048582



We are recommending 64 - 128 GB of RAM.

Thanks,

Jason Claggett
Vice President of Technology
2W Technologies, Inc.
Epicor Certified Partner
312.533.4033 x8039
jason@...