Benchmark Data I/O on Azure Sql Database

Thomas Bolon 1 Reputation point
2021-11-30T10:02:16.263+00:00

Hi,

We have some suspicion of performance degradation on our Azure SQL Database.

I would like to benchmark the data I/O throughput on one database without and conflictual activity on our server.

We have observed an increasing occurrence of timeouts in our queries despite our workload did not change in this timeline.

In most cases, the Data I/O graph in the different metrics view on the portal did not show a spike or a saturation of our Data I/O DTU, neither the different dmv on our database.

And the timed out queries only seems to do some table scan which relies on Data I/O performances (often data are in cache after that and only logical reads are observed)

Has anyone tried to measure such performances on Azure SQL database?

Regards,

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2021-11-30T11:04:13.657+00:00

    You can use HammerDB for that purpose. See this step-by-step article on how to do it.

    My suggestion, in addition to benchmark the IO of your database, make sure you create a maintenance plan for your indexes and statistics using Azure Automation. Create also the missing indexes and the situation will disappear.