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."MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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 paramount advantage is the exceptional speed."
"It is a stable product, and it runs seamlessly. It is not complex."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"The solution can be deployed in a few minutes."
"One of the things I most like about SQL Server is the log shipping piece. This is a great feature."
"It will do clustering, so you can have two database servers looking at the same data simultaneously."
"It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups."
"SQL Server's performance is fine."
"The feature that I have found most valuable is that it is easy to code."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"We don't get good discounts in Pakistan."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We experience latency at times when there is a lot of data being processed."
"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."
"Technical support could be faster."
"The interface integration could be better."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"The scalability is adequate but could improve."
"The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."
"Security is an issue."
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.