We performed a comparison between SingleStore and SQL Server 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."The product's initial setup phase was pretty straightforward, with no complex processes."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The paramount advantage is the exceptional speed."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
"The stability is fine, especially if you're hosting it on AWS or Azure. You can get up to 99.99% stability on AWS."
"I like that it's very easy to use, and Veeam is excellent. There are tons of experts and writers in the area now, and we don't find the same for other databases."
"The availability is the most valuable feature. It has high availability. It also has good performance."
"This solution is user-friendly and easy to understand."
"Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable."
"We're satisfied with the stability."
"can extract data from the server and store it in a local data source for BI purposes."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"We don't get good discounts in Pakistan."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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 upgrades are unstable."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
"The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better."
"SQL Server could integrate better with other platforms."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"As we have faced problems with the solution in both the past and present, I feel it could be more stable."
"I would like to see more integration with other platforms."
SingleStore is ranked 6th in Database as a Service with 7 reviews while SQL Server is ranked 1st in Relational Databases Tools with 259 reviews. SingleStore is rated 8.8, while SQL Server is rated 8.4. The top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SingleStore is most compared with MySQL, Teradata, Oracle Database, CockroachDB and Vertica, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
We monitor all Database as a Service reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.