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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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 paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"Its security is good. The GUI of SQL Server is also very good."
"This solution has proven stability and operational power."
"SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based."
"Similar to Microsoft SQL, it is easy to scale."
"A valuable feature of the solution is that it is comparatively simpler to manage than Oracle."
"The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables."
"The technical support is good."
"What I like most is the management, as it is very easy compared with other products."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"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."
"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."
"While this is a reliable product, it has room for improvement."
"SQL Server could integrate better with other platforms."
"The solution is expensive. The licensing costs are high."
"The interface could be updated to make it slightly more user-friendly."
"It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
"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."
"There should be more security updates for the product."
"There are certain shortcomings in the scalability of the product, making it an area where improvements are required."
SingleStore is ranked 6th in Database as a Service with 7 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 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.