Try our new research platform with insights from 80,000+ expert users

Citus Data vs SQL Server comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Citus Data
Ranking in Relational Databases Tools
21st
Average Rating
8.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
266
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of Citus Data is 1.7%, up from 1.2% compared to the previous year. The mindshare of SQL Server is 22.0%, down from 23.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Arucy Lionel - PeerSpot reviewer
Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management
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. Currently, setting up a multi-node environment is challenging. It's a bit tricky. Installation on each PostgreSQL node can lead to communication issues between nodes. An automatic rebalancing feature would be a significant improvement. Currently, I have to manually command the rebalance. It would be more convenient if it was rebalanced automatically. The dashboard and monitoring capabilities are good, but it would be helpful to have an integrated availability dashboard.
AhmadTalha - PeerSpot reviewer
A robust and secure solution that helps to store data
The GUI needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"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."
"It's very straightforward to implement the solution. It took us two days to set up everything."
"The technical support is good."
"SQL Server is easy to manage."
"This solution has proven stability and operational power."
"I haven't really experienced any issues that required the assistance of technical support."
"The most valuable features of this solution are easy queries and straightforward programming for beginners."
"One of the things I most like about SQL Server is the log shipping piece. This is a great feature."
"Similar to Microsoft SQL, it is easy to scale."
"If you need to, you can scale the solution very easily."
 

Cons

"More features in monitoring and the reporting could make it better."
"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."
"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."
"The solution could improve by being more user-friendly."
"The tool's support needs to be improved."
"We experience latency at times when there is a lot of data being processed."
"With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages."
"The upgrades are unstable."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
 

Pricing and Cost Advice

"Citus Data is an open-source product."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten."
"Pricing for this product is very reasonable."
"My advice is quite straightforward. If you know the number of users who really and truly need access to the Server then it is a no-brainer. If you do not know, then get the basic package and minimum licenses and start from there. Needless to say, users can develop/use data structures outside and then deploy onto the Server."
"It is expensive, but you get what you pay for."
"SQL Server is expensive if you use the advanced SQL version, but if you use the standard version, it's not expensive."
"The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
"Some of the licensing are very expensive, such as the Enterprise license."
"There is a license required for servers and for the POS we use the free version. The free version allows you to have tables and a total database size of approximately 10 GB, which is enough for our requirements."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
816,192 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
12%
Manufacturing Company
10%
Comms Service Provider
8%
Educational Organization
49%
Financial Services Firm
9%
Computer Software Company
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Citus Data?
You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well.
What needs improvement with Citus Data?
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.
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Cloud Flare, Agari, Mix Rank, Heap
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Citus Data vs. SQL Server and other solutions. Updated: October 2024.
816,192 professionals have used our research since 2012.