Comparing Oracle and SQL Server 2000 Performances

• S Javed

  Grasshopper

  Points: 12

  More actions

  February 14, 2005 at 12:20 pm

  #60695

  I am currently doing research on the ways to implement the performance comparison of the Oracle and SQL Server DBMS databases.

  I am stuck at following tasks as I am not sure whats the right direction to take:

    1. Investigate the existing benchmarking tools for Oracle and MS SQL Server 2000

   I have searched alot to find out the existing benchmarking tools but all I can find on web are the ones created by different companies and they want you to buy their products first.

  There is no such examplery tools I could find. Is there something in the market that I am not aware off???

   

   

       2. Design and Implement test databases in the above mentioned DBMS.

  I am thinking of designing a generic database satisfying the project requirements and not potraying any specific scenario/case study.I'll then implement this database in both MS SQL Server and Oracle.

   

  The requirement is it to be a complex database!!!

   

  The question now arises is that what makes a database complex .Apart from using lots of foreign keys I am not sure what factors I need to consider in order to design this database.

  This is the most important part of my project as all my performance results are based partially on the database structure.

  Many Thanks.

• Muhammad Saljook

  SSC Rookie

  Points: 28

  More actions

  February 15, 2005 at 7:34 am

  #542275

  For complexitiy, just have alot of JOINS, have some complex CONSTRAINTS, try some aggregations in the queries, use some replication, try disaster recovery scenarios, use cross-server queries, try data migration (may be using SQL Loader in Oracle and DTS in MS SQL 2000). As for as tools are concerned, we at work use Quest Central (A tool given by Quest.com), I think the trial is free, it should be good enough for testing purposes, both for Oracle and SQL 2000.

  Thanks,