Solved

Oracle and SQL performance on Window 2008

Posted on 2011-02-25
3
482 Views
Last Modified: 2013-12-19
We will install an new ERP on Window 2008. The database could support Oracle and SQL 2008. Any performance difference for these two database under Window 2008 ? Is there any performance reference or comparsion between these two databases in Window performance ?

Thanks
0
Comment
Question by:AXISHK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 250 total points
ID: 34981270
1. Oracle runs on many platforms, SQL on Windows only
2. Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database
3. Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users)
4. SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that
5. Replication is much easier in SQL (I have been at clients where even the Oracle consultant couldn't get it working w/oracle)
6. Failover support in SQL is much, much easier
7. JDBC support is much better in Oracle, although Microsoft is working on it
8. ODBC support in both
9. SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in.
10. SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though.
11. SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line (Back in SQL 6.5 days I had a customer who was so proud that after a day's worth of work he had managed to script his database. I showed him how it was a 3 click operation in SQL ;-) 12. Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in
13. SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase.

Reference Link:
http://www.oracle.com/technology/products/database/clustering/pdf/twp_racsqlserver_2008.pdf
http://www.infoworld.com/d/data-management/real-difference-between-sql-server-and-oracle-755
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 250 total points
ID: 34986252
http://www.microsoft.com/sqlserver/2008/en/us/sql2008-oracle11g.aspx

It’s from Microsoft so obviously the comparison is more geared towards favoring how well SQL Server 2008 is positioned as compared to Oracle 11g.  Oracle has a similar comparison whitepaper but with SQL Server 2005.

http://www.oracle.com/technology/products/database/clustering/pdf/twp_racsqlserver_2008.pdf


0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 34990316
i would look at the ERP ... what do they say
and what goal you have for the future

in general you put only 1 ERP on 1 database
that's how the vendor likes it, but it's not a must, you can put other schemas in too

it all depends on what dba or people with knowledge of that type of db you have
and if not if you are willing to invest in it


0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Fill Date time Field 12 29
find SQL job run average duration 24 54
Many to one in one row 2 39
error starting form builder in 11g 2 25
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question