September 18, 2008 at 9:57 am
We are currently using SQL/Server 2000 and need to install Oracle 10g for one of our new applications. These are failry small applications, we currently have 2 applications that use SQL/Server 2000 (about 80 concurrent users total) and need to install Oracle 10G for another application about 50 users. Is there any recommendations on CPU and memory consumption when both SQL/Server and Oracle resides on the same server ?
Someone had mentionned to me that SQL/Server and Oracle don't live well together but I didn't find any documented facts that proves this.
Any feedback is welcome
Thanks
September 18, 2008 at 11:08 am
I've installed Oracle and SQL Server in a development environment a few years ago, with no issues. I've recently installed the Oracle 10G "express", SQL Server 2000 MSDE, SQL Server 2005 Express AND MySQL on my laptop for development... everything works ok for developing and testing.
For a production environment, I wouldn't recommend Oracle and SQL Server on the same server, as they both would be contending for RAM and I/O. I'd put the lesser-used database engine on a virtual server.
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
September 18, 2008 at 12:35 pm
Only if you can make sure both get the required share of the resources. If you think one of them is critical and might consume a lot resources then place it on a dedicated server. i have SQL 7.0 and Oracle 9i, had no issues though.
Hope this helps...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply