E10: How to stop DB and "App Server"

Yahoo Archive
1

This is how much RAM you should set in SQL.

 

(Available – 8)\2

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 12, 2014 2:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10: How to stop DB and "App Server"

 

 

Is it the database server or IIS taking up your RAM?  You can stop the ERP 10 application pool in the IIS Admin tool.  Open the Internet Information Services Manager, open the Application Pools node in the treeview, find the Erp10 application pool (the name may be slightly different), and choose the option to stop the app pool.

 

You can also open a command line and stop *all of IIS* using this command: iisreset /stop

 

If SQL Server is consuming memory as well, you can stop and then restart SQL Server in the Services admin tool or using the command line: net stop mssqlserver followed by net start mssqlserver

 

You can configure SQL Server to limit the amount of RAM it consumes overall in SQL Manager.  It's worth doing on a test machine.  Left alone, SQL Server assumes it can take whatever RAM and CPU cores it feels it needs.

 

-Erik

2
Hi All,

How do I stop E10 from running?
For example, in Progress E9, I would stop all app servers and then stop the DB.
Is there an equivalent for E10?

My test server has limited RAM and I want to stop the E10 demo DB to free up RAM before running another process.




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:b4a22d.png@fda409ec.4f9f93e2]
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]
3

Is it the database server or IIS taking up your RAM?  You can stop the ERP 10 application pool in the IIS Admin tool.  Open the Internet Information Services Manager, open the Application Pools node in the treeview, find the Erp10 application pool (the name may be slightly different), and choose the option to stop the app pool.


You can also open a command line and stop *all of IIS* using this command: iisreset /stop


If SQL Server is consuming memory as well, you can stop and then restart SQL Server in the Services admin tool or using the command line: net stop mssqlserver followed by net start mssqlserver


You can configure SQL Server to limit the amount of RAM it consumes overall in SQL Manager.  It's worth doing on a test machine.  Left alone, SQL Server assumes it can take whatever RAM and CPU cores it feels it needs.


-Erik