Choice between Oracle and Microsoft Sql Server has always been on the discussion while organization decides on database platform. Running Microsoft Sql Server costs much less than running Oracle because companies who have implemented Oracle spending millions of dollars every year compared to thousands of dollars for Microsoft Sql Server. Even though cost of maintaining Oracle database is higher than Microsoft Sql Server, it is still leading the market of database world. Let’s discuss some the facts that why Oracle is more preferred than Microsoft Sql Server.
Microsoft Sql Server is easy to administrator and works well where sizes of the database are less than few hundred of gigabytes and if it grows faster then there will be performance issue arises on the surface. In contrast Oracle can run multi terabyte database without any performance issue with the help of larger number of tuning options and features available along with software.
Microsoft Sql server only offers vertical scalability so you can add more memory and CPU to the server to address vertical scalability. In contrast Oracle can offer you the same but once threshold is reached then we can upgrade to Real Application Cluster technology to address the horizontal scalability.
Microsoft Sql Server ties to Windows operating system which makes it a weak contender as Oracle works well on Windows and UNIX both. Most business considers UNIX operating system as it is more robust, stable and reliable compare to Windows which prone to crashes.
So It is up to organization to decide whether they want to go for Oracle or Microsoft Sql Server.