Re: Installing MS-SQL and Oracle into a same server

On Dec 3, 5:03 am, achan..._at_gmail.com wrote:
> Hi ! I have 3 questions that I need help on:
> 1. Is it possible to install and run MS-SQL and Oracle from a single
> Windows-server box ?
> 2. What specific area should I beef-up the server to enable the 2
> database engine to run without problems ?
> 3. Am I crazy to do this ???

It depends.
If the license metric used for the Oracle database server software in this case is "per CPU (processor socket)" such as for Oracle Standard Edition One, then why would you want to run a potentially CPU hungry app such as MS SQL Server on those CPUs?

I can't imagine being able to support response time levels in such an environment, unless you've overcompensated for processor power (and just as likely, Oracle licensing and support), memory and storage . But maybe you just can't get hardware orders through the management structure of your organization or this is just a test box at home in which case their are other criteria involved besides minimizing the cost of ownership of supporting the database(s).

Perhaps the setup is so starved for disk IO that it cannot possibly be CPU-bound.
At least disable the OS file cache.
If this is a 32 bit version of MS Windows Server, you're not going to have much memory available for applications (meaning, Oracle and MS SQL Server). If you're using a heuristic of 1 GB of memory per processor core and have even a single quad core processor ... you've hit the wall at 4 GB. So you have 3 GB of memory to "share" between the 2. Where to add beef? Use a 64 bit OS with a boatload of memory for starters.

Enough speculating, as you haven't really provided any details.

-bdbafh Received on Mon Dec 03 2007 - 09:12:09 CST