RE: Oracle and SQL server together?
- From: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
- To: 'Kellyn Pot'vin' <kellyn.potvin@xxxxxxxxx>, "dedba@xxxxxxxxxx" <dedba@xxxxxxxxxx>
- Date: Tue, 18 Sep 2012 13:39:45 +0000
Never done anything with SQL Server before...so the fun just never stops.
Right now the setup will be Oracle 11g and Sql Server 2012 on a Windows 64bit
box running 2008R2 24gig ram and multi core processors....so we shall see.
From: Kellyn Pot'vin [mailto:kellyn.potvin@xxxxxxxxx]
Sent: Tuesday, September 18, 2012 8:36 AM
To: dedba@xxxxxxxxxx; Storey, Robert (DCSO)
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle and SQL server together?
I'm not sure if Jeremiah Wilton is out on this list, but last year at RMOUG
Training Days, he was doing a comparison of Oracle to SQL Server and had the
opposite problem that we looked into- No matter what the settings for Oracle
he set for SGA_TARGET, SGA_MAX_SIZE, it was starving SQL Server!. I believe he
was on Win 2008 with 11g and MsSQL 2008 for the comparison. He was doing
everything correctly, but there was some odd *memory leak* on the Oracle side.
If he does see this, maybe he has more light to shed since the event.
As a long-time Oracle/SQL Server DBA, (yes, I do both, working on a chapter on
a book for each right now, there's no escape! :)) I have run Oracle and MsSQL
on the same physical box often. I have found that they do run well together
and not many issues outside of the standard issues most DBA's run into with
Oracle on Windows vs. Linux/Unix flavors of the OS.
-Do not let memory be dynamically allocated or adjusted for either Oracle or
MsSQL. Figure out what each one needs and SET VALUES.
-Know that you should apply the monthly Widows updates and that this will
require db downtime to do.
-If you have the opportunity to choose your OS/db platform, do choose Win 2008
R2 and MsSQL 2008 R2. The enhancements to these were not actually that minor
and are worth the investment.
-Ensure you have the CPU and memory resources you need to run both databases!
Verify this with AWR/ASH reports, (I know, licensing!) and query the DMVs in
MsSQL to ensure that you do not have performance issues where one database can
be impacting the other.
VM's come in very handy to test out the requirements for this type of scenario,
too. Build it up, run workloads against it, allocate resources to figure out
what you are going to need come go-live... :)
Hope this helps,
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
RMOUG Director of Training Days 2013
~Tombez sept fois, se relever huit!
________________________________
From: De DBA <dedba@xxxxxxxxxx<mailto:dedba@xxxxxxxxxx>>
To: RStorey@xxxxxxxxxxxxxxxxxx<mailto:RStorey@xxxxxxxxxxxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>"
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Sent: Tuesday, September 18, 2012 6:34 AM
Subject: Re: Oracle and SQL server together?
Not recently, but I have in the past. In my experience SQL Server ties in
rather intimately with the OS and will starve Oracle (or any other application
for that matter) for resources. This was even noticeable when running VMWare
instances in an ESX pool with some VMs running SQLServer and others running
Oracle (not sure how the SQLServer VMs coexisted..). If memory serves well,
that last configuration involved Windows 2000/2003, SQL Server 2003 and Oracle
10gR2.
I tend to fight for a dedicated server where I can.. :)
Cheers,
Tony
On 18/09/12 22:01, Storey, Robert (DCSO) wrote:
> Anyone every run Oracle and SQL server together on the same physical box? Do
> they play well with each other or have both secretly embedded hacking code to
> look for the other and sabatoge it...lol.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
