Solved

Oracle and SQL performance on Window 2008

Posted on 2011-02-25
3
481 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
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle collections 15 27
Why I am having this error in my query? 2 25
oracle differnce between two timestamps 5 31
return value in based on value passed 6 28
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

829 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