Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

App server & sql server on same machine  RSS feed

 
rakesh Kamat
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello friends,
Wanted to know if keeping an app server and sql server running on the same machine will affect performance of the application in a big way.
The machine in question is a P4 with 1 gb RAM.

Does anyone has any idea about this? Kindly let me know.

Sincere regards,
rakesh
 
Ernest Friedman-Hill
author and iconoclast
Sheriff
Posts: 24215
37
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Welcome to JavaRanch!

We have a strict policy on display names, which must be a real first and last name with a space between. Obviously fake names aren't OK.

Please go here and fix your display name up, pronto. Thanks, pardner!
 
Joe Ess
Bartender
Posts: 9406
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As with many things performance-oriented, the answer is "it depends".
It depends on the number of other processes running, the size and load of your application, the size of the tables you are running queries against and so on. As all these factors increase, so does competition for scarce resources. The worst-case scenario is your app and database both requesting more resources than physically available, resulting in your OS spending more time swapping things around than working on your problem.
Ideally you would test your application with both configurations and see which meets the requirements for your application's performance.
 
Sandesh Ballikar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by rakshas hahahaha:
Hello friends,
Wanted to know if keeping an app server and sql server running on the same machine will affect performance of the application in a big way.
The machine in question is a P4 with 1 gb RAM.

Does anyone has any idea about this? Kindly let me know.

Sincere regards,
rakesh


Hey..having app server and sql server server is a bad idea esp if you app is high on DB transactions. by the way are you rakesh kamat from Khalsa?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!