E10: Single Server - Limit RAM for SQL?

Single physical server.


[cid:de00dc.png@a6f7abe8.41b1e9e4]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, October 05, 2015 8:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10: Single Server - Limit RAM for SQL?



Joe,

Are you going physical or virtual? We are looking to do the same thing but the thought was a VM for SQL and multiple VM's with IIS if needed.

John



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

I am in the process of building our production server for E10.0.700.4.
This will be a single server setup so SQL Server and the ERP application will all be on one server.

SQL Server is designed to consume any and all RAM that it needs and I’m wondering if I should consider capping it to a certain amount so as to not impact ERP10, IIS, and general Windows activity.
The server has 64 GB of RAM.
What are others doing in this type of setup?

[cid:d99a9e.png@3ffd2327.4288d0df]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>



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

Are you going physical or virtual? We are looking to do the same thing but the thought was a VM for SQL and multiple VM's with IIS if needed.

John