Microsoft Azure Synapse Analytics Scalability

Sunil Gidwani - PeerSpot reviewer
Cloud Solution Development Manager at Stryker Corporation

Scalability is built in. You don't need to do anything. If you're working with a terabyte of data on one day, you can go up to a petabyte the next day. There's no need to worry about scalability in terms of performance.

View full review »
ShubhamSharma2 - PeerSpot reviewer
Project Trainee at Neal Analytics

The solution is scalable.

View full review »
AT
Senior Director/ Advisory Architect at a tech vendor with 10,001+ employees

The product can scale. 

For one of my clients, it was used as an Enterprise Data Warehouse, so it has got all kinds of insurance functions, and users. It has got an underwriting team, it has got the actual team, it has got a claims operations team, et cetera. All the enterprise Data Warehouse users start consuming data while using the visualization tools like Boll-BI, and then MicroStrategy, et cetera.

View full review »
Buyer's Guide
Microsoft Azure Synapse Analytics
March 2024
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.
Herb Heltzel - PeerSpot reviewer
Data Solutions Architect at King County Gov

It is pretty much infinitely scalable if you got the money to pay for it.

Currently, we probably have 600 or 700 users in the county. They are mostly data analysts and data scientists. As far as developers go, we probably have 15 developers working with it right now.

View full review »
Matthew Spieth - PeerSpot reviewer
Senior Database Administrator at Summa Health System

Microsoft Azure Synapse Analytics is created out-of-the-box to be scalable. That was always the struggle of Analytics and BI Teams you had to spend $2 million to receive the server with RAM and disk space needed to use this type of solution. Microsoft Azure Synapse Analytics will scale automatically behind the scenes. Which is one of its main powerful features.

We have many people using the solution. The data engineer, who is moving data around and brings data in. The data scientist and the IoT developer. There are different areas in Microsoft Azure Synapse Analytics for each role.

View full review »
KS
Technical Manager at LTIMINDTREE

We manage four to five Microsoft Azure Synapse Analytics customers in our environment. It is a scalable software.

View full review »
Debashish  Saha - PeerSpot reviewer
Technical Lead at Linde

Azure products are highly scalable, so I would rate it nine out of ten. 

View full review »
Peter Aderoju - PeerSpot reviewer
Student at University of Derby

I will rate the scalability an eight out of ten. It depends on how much you scale it, but it's been proven to be quite scalable for what I'm working with.

Around eight end users are using this solution. The usage frequency depends on the job. Sometimes, it could be almost every day, depending on if we're receiving a lot of information. And at some point, it's quite slow, so we have to be on it almost every few days to check and update.

So, in the future, we may use it more than we are using it now.

View full review »
VarunJoshi - PeerSpot reviewer
Senior manager at Accenture

I work for Accenture, so there are hundreds and thousands of customers on Microsoft.

The solution scales very well. You can scale up or down as required. It's very easy.

View full review »
Ibrahim_Rasras - PeerSpot reviewer
Senior lead Enterprise Designer Architect at a government with 10,001+ employees

It is a scalable solution.  

View full review »
SS
Business Architect at YASH Technologies

Microsoft Azure Synapse Analytics is able to scale to the needs of our requirements.

View full review »
VK
General Manager at itcinfotech

Azure cloud is very scalable and allows this product to scale as well. We can scale horizontally and vertically.

View full review »
Ashwin Baatjes - PeerSpot reviewer
Cloud Architect at Astute - The Financial Services Exchange

I rate Synapse 10 out of 10 for scalability. Scaling up Synapse is quick and easy. That's one thing I appreciate the most about it. You can scale with a click 

View full review »
SeshagiriSriram - PeerSpot reviewer
Head IT Architecture at a tech vendor with 11-50 employees

The solution is scalable.

We use the solution intermittently, approximately 50 percent of the time.

We have approximately 1,500 users using the solution.

I rate the scalability of Microsoft Azure Synapse Analytics a ten out of ten.

View full review »
BS
Global IT Solution Architect at Campari Group

The solution is very scalable. We are a medium-sized enterprise, and there are almost 4000 end-users.

View full review »
Pankaj Rathod - PeerSpot reviewer
Data Architect at a retailer with 1,001-5,000 employees

The solution is scalable. Generally, the development team of around 20 people uses Azure Synapse Analytics directly. Otherwise, a Power BI dashboard accesses the Azure Synapse Analytics database, and the end user uses the Power BI reports, not being directly exposed to Azure Synapse Analytics. Only the development and software development teams use Azure Synapse Analytics.

View full review »
RP
Senior Specialist at a comms service provider with 10,001+ employees

The solution is a web data warehousing and analytical platform built for enterprise environments, so it is definitely scalable. 

View full review »
Muralidharan Lakshmanachar - PeerSpot reviewer
Director at Capgemini

I haven't seen any issues with scalability. 

View full review »
JoseArguello - PeerSpot reviewer
Data Engineer at a manufacturing company with 10,001+ employees

The solution is scalable.

We have about 20 people using the solution in our company.

View full review »
PedroNavarro - PeerSpot reviewer
BI Development & Validation Manager at JT International SA

The solution is scalable. We currently have fifty to sixty people working within it and, now that we are using Serverless more often, we are planning to have more people working with it.

View full review »
Mukund Mishra - PeerSpot reviewer
Sr. Technology Architect at a tech services company with 10,001+ employees

As Microsoft Azure Synapse Analytics is on the cloud, it's scalable, and you won't have that many issues with scalability. If a solution is cloud-based, you won't have to worry about whether it's scalable or whether it supports other features, because you'd have all features in the cloud itself. You can scale up or scale down Microsoft Azure Synapse Analytics based on your requirement, so it all depends on what exactly you want. In the cloud, you won't have to schedule, wait, think, or plan. You can scale up or scale down automatically anytime.

View full review »
HV
Data Engineer at a financial services firm with 1-10 employees

The solution is scalable to a customer's needs. A few customers have written scripts to scale how they want, but most customers use the out-of-the-box database.  

View full review »
AB
Architect at a tech vendor with 10,001+ employees

I rate the scalability of Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
RM
Head of Business Integration and Architecture at Jakala

Microsoft Azure Synapse Analytics is scalable.

View full review »
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions

The Azure Synapse service is highly scalable. 

View full review »
Erick Oliveira Da Silva - PeerSpot reviewer
Senior Data Engineer at a tech company with 201-500 employees

It is simple to scale the service. I'd rate it at ten out of ten for scalability. We had 45 engineers who used the solution.

View full review »
Mithun Thirisseri - PeerSpot reviewer
IT Solutions Architect at a financial services firm with 10,001+ employees

The scalability of Microsoft Azure Synapse Analytics is very good.

We have hundreds of people using this solution.

View full review »
YP
Senior Manager, Global Network Development at a comms service provider with 10,001+ employees

It's scalable. I'd rate it an eight out of ten in terms of scalability. Our clients are enterprises. 

View full review »
SR
Vice President of Data Practice at a computer software company with 5,001-10,000 employees

We can scale the product up and down according to our needs.

We have around 100 people using the solution right now. 

My customer uses it on a daily basis.

View full review »
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees

The solution is scalable.

View full review »
AB
STI Data Leader at grupo gtd

The solution can scale, however, it is expensive to do so. If a company wants to expand, it will have to pay. Therefore, they should be prepared for that.

Currently, we have about 200 people using the solution.

View full review »
DE
Linux Platform System Administrator at a healthcare company with 10,001+ employees

The scalability of Microsoft Azure Synapse Analytics is good.

View full review »
BS
Founder and Managing Director at a tech services company with 1-10 employees

The scalability of Microsoft Azure Synapse Analytics is very good.

We have approximately 40 people using the solution. We have plans to increase our usage in the future.

View full review »
AB
STI Data Leader at grupo gtd

I'm very impressed by the scalability of Synapse Analytics, even though we don't use it for huge amounts of data most of the time. Combined with the availability of machine learning and other features in the cloud, it has a lot of potential, especially in the area of finance.

View full review »
Kundan Amin - PeerSpot reviewer
Senior Consultant at Dynamic Elements AS

Azure Synapse is serverless architecture, so you can scale as and when required. It makes no difference if there are 100 users or 1,000 users. We have around 50,000 end users.

View full review »
Alekhya  Golla - PeerSpot reviewer
Senior Software Engineer at a computer software company with 501-1,000 employees

Synapse Analytics is definitely scalable.

View full review »
NT
Senior Systems Analyst at a non-profit with 201-500 employees

The solution is scalable. I have changed the interface and most of the operations can be done from the interface by clicking a few buttons, it is quick and easy.

At the moment we only have approximately four people using the solution because it is a data warehouse creation in the back end. We have not reached the stage where our staff will use the product but we are building a single customer view using the platform and we will be increase usage in the future.

View full review »
AM
Enterprise Solutions Architect at a consultancy with 1-10 employees

For the amount of data that we have, Microsoft Azure Synapse Analytics has worked perfectly fine in terms of scalability. Thus, for us the scalability is a ten out of ten.

View full review »
Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

The solution is highly scalable. For example, if you have 100 DWUs, you can increase up to 20,000 DWUs by letting Microsoft know your requirements. Your needs for DWUs will be satisfied based on how much you are willing to pay.

View full review »
JS
Information Architect at a analyst firm with 201-500 employees

It's a scalable solution.

Our client's companies vary in size. They are across the board from insurance companies, healthcare, marketing, and manufacturing.

View full review »
JS
Solution Principal at a computer software company with 5,001-10,000 employees

This solution is scalable, although I don't expect that we will expand it beyond the current usage.

View full review »
MT
CHTO at Timp-iT

We have not tried to expand the solution into a very large extension because it is a rather small organization that I am working for. The Azure platform where Power BI is running on is expandable to whatever you like.

We have many organizations using this solution. The care organization I am working for has three customers using it. I am also working as an associate with another company and they have multiple organizations that are working with these solutions. My estimate would be approximately 15 organizations that are working with this solution.

We have plans to increase usage, but these organizations are all at the starting point. This is a strategic solution to improve their processes and business continuity. It is a conservative environment, every change is really hard. It is really stressful to get changes done and it will take some time. This solution changes the way in which work is done, it will take up to three to four years to be widely adopted.

View full review »
HF
Data engineer at Inicon S.r.l.

This solution is quite easy to scale depending on your workload. Overall it is a little bit expensive. You have to know exactly what you are doing as you scale up, otherwise the cost goes up quite quickly.

View full review »
JL
Senior Architect at a tech services company with 51-200 employees

For its traditional data warehousing, it's scalable.

For Synapse Analytics, I am uncertain about being able to trust it with large volumes, which is what you would expect with Databricks.

There are only three or four people in our organization who do this type of work.

View full review »
MD
Managing Partner at a tech services company with 11-50 employees

This solution is scalable.

We have a couple of administrations using this solution and the rest are indirectly using third-party tools. They are developers and administrators.

View full review »
EK
Data Architect at a tech services company with 10,001+ employees

One of the reasons we decided to go with Azure was because we knew we could scale-out. We were happy with this scalability before we committed to the product.

Right now, I know only two of our clients are using the solution. They are actually a government organization. But we know we can scale up when we have to.

View full review »
CG
BI Consultant at a tech services company with 11-50 employees

On the client's side, there are approximately 100 users of this solution.

View full review »
VP
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees

While I haven't really tested the scalability, it is my impression that the solution can scale and it shouldn't be an issue for any company to do so.

View full review »
AP
Data Architect at a tech services company with 51-200 employees

You can scale it, although you need to put in more effort. We have approximately 800 users.

View full review »
BT
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees

I think the architectural design is very scalable.

View full review »
Mullai Selvan - PeerSpot reviewer
Project Manager at MAQ Software

The scalability has been pretty good, in our experience. We have been able to scale it twice to the number of users we needed. We were also able to double the amount of data load. We haven't had issues. If a company needs to expand, it should be able to do so without problems.

View full review »
IH
Advisory Software Engineer at a tech services company with 1,001-5,000 employees

Synapse Analytics is deployed in a cloud environment and one of the best advantages of this is that it provides scalability.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

Synapse Analytics is a scalable product.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

It's a scalable solution and we find it to be easy to scale.

View full review »
SS
Sr. Teradata Consultant at a tech services company with 201-500 employees

Microsoft has different sizing options that comes at different price points. It's easy to scale up or down. If you find, after a few years, your needs are growing, you can increase your BTU size the maximum may be about 13,000. 

With this solution, we can actually automate scalability, which makes it very easy to scale. If you require more data, it will automatically increase your DP size and process the data. We have the flexibility we need so that, whenever a node gets filled, we never have to worry. Another node will pick up and process the data.

With Snowflake, in comparison, if your system is not running, then Snowflake will go into an auto suspend mode. You can sync the time, and, within the 10 minutes, if the system is not running, it will go to an automatic suspended mode. There is no charge in this mode. In that case, we have to manually find what we need to virtualize the function. 

Azure has other mechanisms in place. We can write Azure functions and we can schedule the Azure functions in order to automate them. We can do similar kinds of functionality, however, we have some additional coding we require for Snowflake. 

View full review »
AD
Analytics Engineer at a tech services company with 51-200 employees

The scalability is good. I think we are already using a high availability cluster for 2016, so I assume that it will be the same with the 2019 version. We are also using it with our data recovery system, so it is not an issue.

We have approximately twelve to fifteen developers and approx. 900+ customers who will be using the data warehouse. We are acquiring customers on a monthly or quarterly basis, so it is a pretty big user base and we expect that our usage will continue to increase.

View full review »
VY
Chief Data Architect - Europe at a computer software company with 10,001+ employees

It is scalable to a certain limit. It is not as scalable as Snowflake, but it is scalable.

View full review »
NN
Data Architect at a insurance company with 1,001-5,000 employees

The solution is scalable. It's online. That means you can scale it online and can stop the database to change the scaling of it.

View full review »
ML
Managing Director at a consultancy with 1-10 employees

We do plan to increase usage and we may hire a consultant to help with an expansion in a few months. This will likely happen, however, anything can change in terms of the business and the larger industry.

Scalability is good. I foresee scalability in terms of the possibility of using more features and the only difficult thing that I see already is the macros of the Excel spreadsheets. I also know that it has a good opportunity for scalability, in terms of the more complex tasks that can be achieved. 

Currently, we have ten people on the solution.

View full review »
HG
Director Of Software Development at a healthcare company with 5,001-10,000 employees

Scalability is something that is improving.

View full review »
JS
Project Manager at a tech services company with 5,001-10,000 employees

Scalability is good and we haven't had any issues.

We have approximately 150 users. We are stable at the moment but we will expand our usage as we get more data.

View full review »
DR
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees

Its scalability is good. The only thing is that when you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration.

View full review »
AM
Director of Data Analytics Practice at a computer software company with 501-1,000 employees

This solution is scalable.

View full review »
SZ
Data Platform Architect at APN Promise

Scalability is one of the main advantages of this solution.

View full review »
AS
Enterprise architect at a computer software company with 201-500 employees

The product is scalable. 

View full review »
MB
Enterprise Solutions at Celebal Technologies

In principle, it's a limitless, serverless solution. As long as your region has resources, you can go on expanding. We have not had any problems with scalability.

Microsoft Azure comes integrated with Databricks as a Machine Learning platform, it's highly scalable.

View full review »
JT
Senior Project Manager at a tech company with 501-1,000 employees

The solution is scalable. A company shouldn't have issues expanding it out.

In our organizations, we have less than a dozen users, and those are mostly IT and IT management people.

View full review »
PP
Vice President Technologies at Excelencia

Scalability is the best part of going with a cloud-based solution. I don't have to worry about server space. Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to. What we propose to the people who are implementing this solution is to start with the minimum requirements and then scale up based on demand.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

We have three to four people using the product.

View full review »
JS
Practice Head BI at a tech vendor with 1,001-5,000 employees

We are satisfied with the scalability.

A lot of people use the analytics and I would estimate it to be between 50 and 100 users. Most of them are business users, although some are power users who built the system for them.

View full review »
it_user937602 - PeerSpot reviewer
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees

This scalability of this solution is five out of five. It is easy to scale, although it is a bit pricey compared to the competition, even with the Microsoft discount that we get for being a big enterprise.

We have approximately three hundred users for Azure SQL. With respect to Power BI reporting that can run queries in Azure SQL, I think that there are thousands. We have no plans to expand at this time.

View full review »
SR
Co Founder & CTO at a manufacturing company with 1-10 employees

It is a Cloud platform and so it is easy to scale.

View full review »
SB
Co-owner, Director at a tech services company with 1-10 employees

We don't scale up because the current level is enough for our customers. Our customers are small and medium companies in Europe.

View full review »
CK
Consultant at a non-profit with 11-50 employees

Scalability is great. It can go from zero to infinity. 

View full review »
RR
Executive Board Member / General Manager at a comms service provider with 51-200 employees

We haven't grown a lot so I am not able to say if the solution is scalable or not.

View full review »
Buyer's Guide
Microsoft Azure Synapse Analytics
March 2024
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.