We performed a comparison between Google Cloud Spanner, Oracle Database as a Service, and SQL Azure based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), Microsoft, MongoDB and others in Database as a Service."Google Cloud Spanner is stable."
"The application deployment in the cloud is the best feature of the infrastructure."
"The most valuable feature of the solution is its scalability. Scalability comes with two options, among which Google Cloud Spanner can scale horizontally, compared to other relational databases that scale vertically."
"We can scale the solution if we need to."
"It is a good solution and has a large community."
"We have found all of the features of this solution to be valuable to our organization."
"As a database administrator, it has a lot of features to help you manage the database and the backup."
"Oracle Database as a Service is stable."
"The most valuable features of Oracle Database as a Service are the ease of use. We can use a simple syntax to get data and we can easily go to procedures to see data other than using a query."
"The most valuable aspect of the solution is its security, performance, and availability."
"The most valuable aspects of the solution are the general database system resilience and security."
"Scalability is very easy. If you want to, you can make it onto two or three servers, racks, or whatever you want. It's easy."
"I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security."
"The stability is good and the performance is fantastic. Even when we try to do an inquiry into issues we can do it easily."
"The hardware is all managed by Microsoft."
"It is good for scalability and high availability. It is also secure because of Microsoft's cloud investment. It is easy to use because it is on the cloud. Creation or making it available through web services is super easy. Azure SQL can be quickly published as web services for APIs to connect with other applications. Because it is in Microsoft Cloud, you can easily integrate with Microsoft stack."
"Because the solution is cloud-based it's highly manageable, it makes maintenance of logs, space, storage and backups much easier compared to a traditional SQL server installation."
"The initial setup was straightforward. It took less than one day for deployment."
"Cost savings are the most valuable. The DR/high availability is also valuable. The failover group with the built-in DR/high availability features is probably one of the easiest things."
"The most useful feature of Azure SQL is the queries for manipulating the data, such as the tables and the storage processors."
"The tool needs to improve horizontal scaling."
"Google came up with something called Cloud Spanner Emulator, which fails to work like the real product if I want to develop some code and run a database locally on my machine."
"The cost can be a bit high."
"I want to improve the deployment of cameras and surveillance infrastructure."
"The solution’s price could be reduced."
"My favorite option – Multitenant – should be available for some pluggable databases in all editions, without any fee."
"The area in this solution that could be improved is that currently, it's difficult to do the setup. You need to do all kinds of command lines to get it set up. If that setup becomes easier and easily manageable, that would be great."
"The tool needs to improve its pricing and stability."
"When migrating to a different instance, the internal machine learning is lost."
"Oracle Database as a Service could improve by having ETL for larger data."
"I would like to see a better dashboard for the storage. It need to be more complete overall."
"The direct scaling is a feature that has room for improvement. I would like to see virtual management machines that can scale storage well with zero downtime. The backup option and patching would then be much easier to do."
"The configuration is the area that is most cumbersome."
"Scalability is an issue because we can't upgrade to new versions due to hardware limitations."
"The way it has been designed, in the on-premises deployments, the underlying Windows OS is highly scalable but has a very large resource requirement. A lot of power-related and memory-related things are there, which I have not seen in the RHEL and Oracle. I have not tried SQL on RHEL EXEC. On Windows, infrastructure-wise, a very large workload is running on the SQL. This issue is related to Windows, not SQL."
"The solution could improve by allowing the export of the data more seamlessly. It is difficult to copy and back up data."
"It is a little bit expensive for us. They can improve the price. It would also be very helpful if they can offer some free trial."
"There is probably more functionality in our on-prem SQL Server than SQL Azure."
"It's very difficult to investigate if something wrong is going on behind the scenes. If we are facing a problem that our application is doing a CPU spike and when we look at the dump of the details, the processes that our application is generating are not consuming more than 40-50% of CPU. But we don’t know where it is going, who's generating it, and who's consuming the CPU. Even Microsoft says they don’t know."
"The only problem we have with Azure is regarding the price."