Improve Sql performance in Azure Sql DB

k.arun kumar 1 Reputation point

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

    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

    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.

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


    Hope this helps

    0 comments No comments

  2. Rahul Randive 8,021 Reputation points Microsoft Employee


    You can follow below links to start with-

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

    Detectable types of query performance bottlenecks

    Index optimization in Azure SQL database Q&A thread

    0 comments No comments