We performed a comparison between IBM Db2 Database, Oracle Database, and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."IBM DB2 pureScale Feature is valuable."
"The self-management and optimization features are probably the best on the market"
"We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running."
"The solution helps secure the database."
"The solution is a very stable relational database and has integration with legacy systems. It is a great product."
"The most valuable feature of the solution is its compatibility with IBM Power Systems."
"We are dealing with millions of transactions a month and the performance is very good."
"Scalability-wise, I rate the solution a nine out of ten."
"I really appreciate the performance of Oracle. When using AWR records you can really see where a problem is. You can get advice about which queries are the heaviest for the database. You also can see advice for indexes. If an index isn't used, then you can just remove it to improve performance. This is a really good feature. Also, the JDBC connection is quite good. Finally, the object types are really good, the types of tables you can use in PL/SQL are also really helpful."
"Oracle Database is easy to use."
"I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated."
"The solution is very easy to use in general."
"Oracle Database is fast and easy to use."
"The reliability is the solution's most valuable feature. We've had great success with the solution."
"The initial setup isn't too difficult."
"The ease of migration between databases."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"The performance is reliable."
"The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The most valuable feature is easy installation. It was very easy to install."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"The solution has proven to be very stable."
"The initial setup could be improved."
"End-to-end encryption specifically is something the solution needs to have in the next release."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"IBM Db2 Database could improve with better security."
"The licensing fees can be reduced."
"The pricing could be improved, it's expensive."
"The technical support can be faster."
"The capabilities of this solution could improve."
"The previous version was a little clunky."
"The pricing of the product could be better. It's too expensive right now. They need to bring down the cost."
"I am not very satisfied with the support at times. You don't always get the support at the time you want and need it."
"The documentation needs improvement because as it is now, providing support is a headache."
"Oracle is very expensive. So if I suggest Oracle to a client, they'll often say it's too costly."
"Technical support needs improvement."
"Their migration strategies could be better because most of these companies keep the same version for six or seven years and then update it to the latest version."
"There is a lot that can improve in Oracle Database. For example, it could be more user-friendly and should be easier to integrate into the cloud."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"If this solution could provide an automatic indexing feature it would be very useful."
"When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."
"The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."
"The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting."
"The user interface and the reporting could also be improved."
"SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."
"The interface integration could be better."