We performed a comparison between Citus Data and SQL Server based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's very straightforward to implement the solution. It took us two days to set up everything."
"Its distributed processing capabilities are a standout feature. It requires minimal changes to get up and running if you already have a system on PostgreSQL. Citus can run in its natural state."
"You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"The interface is user friendly."
"The solution has proven to be very stable."
"It integrates well with other platforms."
"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"SQL is very easy to manage."
"I have seen that this is a very stable product."
"A big advantage is the ability to store any type of data in SQL Server."
"The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
"There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward."
"More features in monitoring and the reporting could make it better."
"Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues."
"Microsoft support is an issue unto itself."
"The solution could be better when it comes to security."
"As we have faced problems with the solution in both the past and present, I feel it could be more stable."
"SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"Scalability of the database could be improved if it could handle increased volumes of data."
"The remote access aspect needs to be improved in terms of security."
"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."
Citus Data is ranked 18th in Relational Databases Tools with 3 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Citus Data is rated 8.0, while SQL Server is rated 8.4. The top reviewer of Citus Data writes "Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Citus Data is most compared with YugabyteDB, CockroachDB, Amazon Aurora, MySQL and SingleStore, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our Citus Data vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.