Improve Sql performance in Azure Sql DB

k.arun kumar 1 Reputation point
2023-03-12T04:57:17.7666667+00:00

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

  1. Is there a way to improve the performance.
  2. 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.
  3. Please provide me the documentation & Guidance to improve the stuff using the Azure Redis cache
Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Sreeju Nair 11,601 Reputation points
    2023-03-12T11:03:54.24+00:00

    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

    0 comments No comments

  2. Rahul Randive 8,021 Reputation points Microsoft Employee
    2023-03-12T12:29:07.28+00:00

    Hi,

    You can follow below links to start with-

    Tune applications and databases for performance in Azure SQL Database and Azure SQL Managed Instance

    https://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?view=azuresql

    Detectable types of query performance bottlenecks

    https://learn.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues?view=azuresql

    Index optimization in Azure SQL database Q&A thread

    https://learn.microsoft.com/en-us/answers/questions/1183017/index-optimization-in-azure-sql-database

    0 comments No comments