Improve Sql performance in Azure Sql DB

Question

Improve Sql performance in Azure Sql DB

k.arun kumar 1

I am have few SQL Tables when i execute the stored procedures it was taking 52 sec , but i need the stored procedures to be execute less than 10 sec.

I am trying to encrypt the data and storing in the Database . Reading that data makes time

Is there a way to improve the performance.
is there a way to store in azure storage account instead of sql db , will that gain performance. I need an bulk option to read and write the data . do that option is avaliable in the Azure Storage Accounts.
Please provide me the documentation & Guidance to improve the stuff using the Azure Redis cache

Erland Sommarskog 72,341 Reputation points MVP

2023-03-12T11:18:15.3866667+00:00

Is there a way to improve the performance.

Maybe. But if you don't share any information, we cannot say any more than that. We would need to see the code, the table definition and the query plan to be able to suggest anything,
Alberto Morillo 26,111 Reputation points MVP

2023-03-12T12:16:46.23+00:00

Share the query plan with us by using this free Paste The Plan service.
ShaktiSingh-MSFT 5,841 Reputation points Microsoft Employee

2023-03-14T09:43:46.41+00:00

Hi @k.arun kumar ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Erland Sommarskog 72,341 Reputation points MVP

2023-03-12T11:18:15.3866667+00:00

Is there a way to improve the performance.

Maybe. But if you don't share any information, we cannot say any more than that. We would need to see the code, the table definition and the query plan to be able to suggest anything,
Alberto Morillo 26,111 Reputation points MVP

2023-03-12T12:16:46.23+00:00

Share the query plan with us by using this free Paste The Plan service.
ShaktiSingh-MSFT 5,841 Reputation points Microsoft Employee

2023-03-14T09:43:46.41+00:00

Hi @k.arun kumar ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Answer 1

Are you using custom encryption logic to encrypt the data in the table? Is it possible to consider the TDE feature available in the Azure SQL server and move away from your custom encryption?

Read more about TDE at https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql&tabs=azure-portal.

If you cannot change your custom encryption logic, another option is to use a globally distributed Redis Cache with Azure SQL Database to achieve the performance.

https://devblogs.microsoft.com/azure-sql/maximizing-azure-sql-database-performance-with-a-globally-distributed-redis-write-behind-cache/

Another alternative approach is to use Azure Cosmos DB, a fast NoSQL and relational database.

Refer: https://azure.microsoft.com/en-us/products/cosmos-db

https://learn.microsoft.com/en-us/azure/cosmos-db/introduction

Hope this helps