Cost optimization in azure synapse analytics

Question

Cost optimization in azure synapse analytics

Nagesh CL 696

Hi Team,

Are there any utilities or checklists which helps in cost optimization of azure synapse analytics.

Thanks in advance.

Regards,

Nagesh CL

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-10T08:30:50.6233333+00:00

@Nagesh CL - Just checking in to see if the below answer provided by @Vinodh247 helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-19T06:23:47.7666667+00:00

@Nagesh CL - Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,
PRADEEPCHEEKATLA-MSFT

Accepted answer

0 additional answers

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-10T08:30:50.6233333+00:00

@Nagesh CL - Just checking in to see if the below answer provided by @Vinodh247 helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-19T06:23:47.7666667+00:00

@Nagesh CL - Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,
PRADEEPCHEEKATLA-MSFT

Answer 1

Vinodh247 34,661 MVP Volunteer Moderator

There are too many things that can be checked for cost opt, I don't think as of now anybody has a checklist that can be followed. In day-to-day scenario, I am listing out some of the points that I remember.

Appropriate DWC for workloads
Workload management
Restricting access and avoiding too many big queries by users
Pausing database whenever idle more than 2 hours

Table scans can incur too much cost hence proper indexing will help in cost cutting a lot.

Note: All of the above are from dedicated pool perspective.

Nagesh CL 696 Reputation points

2023-05-17T10:40:29.3933333+00:00

Thanks @Vinodh247

The approach that you have suggested is definitely a good start.

Share via

Cost optimization in azure synapse analytics

0 additional answers

Your answer