Đã hoàn thành

Improve performance on a Azure Synapse Table

I have a table with 100 million rows in Synapse. I have a requirement to query on a part of a text column. It takes close to 30 secs to return the results in Synapse, it takes less than 10 secs for the same table in SQL server database.

I need to improve the performance of this table in Synapse. This table is using Round Robin Dristribution and it has Clustered Columnstore Index on it.

Kĩ năng: Microsoft SQL Server, SQL, Quản trị cơ sở dữ liệu, Azure

Xem nhiều hơn: 100 million email address list, can improve performance job, java ajax table add remove rows, improve performance php large project, 100 million bots, 100 million webmaster email list, sql server database connectivity pivot table, vb net pivot table data source sql server database, vbscript update sql server database table, SQL Server Database Azure, migrate sql server database to azure, how to generate create table script for all tables in sql server database, sql server 100 million rows, sql server database performance monitoring tools, sql server settings to improve performance, sql table with 100 million rows, sql server database performance monitoring, html table million rows, download sample sql server database with million records

Về Bên Thuê:
( 2 nhận xét ) The Bronx, United States

ID dự án: #30477433

Được trao cho:

alexsuarez

It sounds like the issue is more with the querying of part of the text column. If we can create a derived column containing the part that needs to be queried, we can build an index on that to further increase performa Thêm

$120 USD trong 1 ngày
(0 Đánh Giá)
0.0

3 freelancer chào giá trung bình$188 cho công việc này

biswanath1989

I am an Azure Data Architect and expert in the donain you are looking for. I am expert in SQL, SQL Server, Database, ETL, Datawarehouse, T-SQL, Snowflake, Azure Data Factory, Python, Datalake, Databricks, Devops CIC Thêm

$222 USD trong 2 ngày
(0 Nhận xét)
0.0
Gventuri

Hi, this is a common issue in Synapsis. I've done some improvements in tables in DW related about it. Some issues was related DTUs contracted or bad practices in modeling.

$222 USD trong 4 ngày
(0 Nhận xét)
0.0