December 21, 2017 at 2:30 am
From and Oracle DBA perspective (I've been with Oracle since late 1980's - Oracle and UNIX will always be my first love) I think SQL Server is doing a pretty good job. I cannot make any comparisons, as I have not had the chance to build or maintain any huge SQLServer instances, however for a brief moment we did have a data warehouse solution, which proves MS can deliver a cost effective proper solution.
What I love about SQLServer (not that it will become my first love) is that when it comes to monitoring Oracle has been failing miserably, especially during version up till Oracle10. Without additional "paid for" licensed software (or TOAD and Spotlite) you are basically on your own. With SQLServer on a Windows Server "perfmon" has what a DBA needs to locate any potential problems and help in the administration field. Also the best part is the integration with MS Office tools, like Excel. With Oracle it takes additional non-Oracle software (also paid for) to deliver some of the features MS has already by nature integrated without additional cost. And that integration is one of the key factors where Oracle will cause some stress and complicates the structure of your application.
You also may have to take into account that MS claims their Query Optimizer is better than Oracle's Cost Based Optimizer. What seems to be the case is that Oracle is actually behind MS and is trying to make their solution more like SQLServers solution. The changes that Oracle has introduced with the Cost Based Optimizer have given my nothing but headaches over the past few years, where MS has tools that basically work out of the box.
Just my 2c.
Richard
December 21, 2017 at 9:00 am
richlion2 - Thursday, December 21, 2017 2:30 AMFrom and Oracle DBA perspective (I've been with Oracle since late 1980's - Oracle and UNIX will always be my first love) I think SQL Server is doing a pretty good job. I cannot make any comparisons, as I have not had the chance to build or maintain any huge SQLServer instances, however for a brief moment we did have a data warehouse solution, which proves MS can deliver a cost effective proper solution.What I love about SQLServer (not that it will become my first love) is that when it comes to monitoring Oracle has been failing miserably, especially during version up till Oracle10. Without additional "paid for" licensed software (or TOAD and Spotlite) you are basically on your own. With SQLServer on a Windows Server "perfmon" has what a DBA needs to locate any potential problems and help in the administration field. Also the best part is the integration with MS Office tools, like Excel. With Oracle it takes additional non-Oracle software (also paid for) to deliver some of the features MS has already by nature integrated without additional cost. And that integration is one of the key factors where Oracle will cause some stress and complicates the structure of your application.
You also may have to take into account that MS claims their Query Optimizer is better than Oracle's Cost Based Optimizer. What seems to be the case is that Oracle is actually behind MS and is trying to make their solution more like SQLServers solution. The changes that Oracle has introduced with the Cost Based Optimizer have given my nothing but headaches over the past few years, where MS has tools that basically work out of the box.
Just my 2c.
Richard
The DBA side of Oracle and MS SQL Server are night and day. If you are a Database Developer much of what you do on either are basically the same, you just have to learn the differences between PL/SQL and T-SQL. I worked with Oracle for a year as a developer and found some things I liked about Oracle that Microsoft has adopted (create or replace for example). There are still a couple (or is it one) things I'd like to see but won't hold my breath. The big thing for me is that I cut my teeth on SQL Server having worked with it for over 20 years and love the product, and more importantly, the SQL Server community.
December 21, 2017 at 10:23 am
richlion2 - Thursday, December 21, 2017 2:30 AMYou also may have to take into account that MS claims their Query Optimizer is better than Oracle's Cost Based Optimizer. What seems to be the case is that Oracle is actually behind MS and is trying to make their solution more like SQLServers solution. The changes that Oracle has introduced with the Cost Based Optimizer have given my nothing but headaches over the past few years, where MS has tools that basically work out of the box.
I remember back in my Oracle days, there were a number of third party software companies that insisted you use the Rule based optimizer instead of the Cost based optimizer.
January 4, 2018 at 8:27 am
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply