Load Simulation - Compare SQL performance on-prem to Azure

David C 191 Reputation points
2020-09-17T04:26:02.8+00:00

(I'll cross-post this to Azure Q&A as well...)

I need to perform a load simulation against an on-prem SQL Server and against a Azure VM running SQL Server. The purpose is to compare latency, response time, etc. I get there are many variables involved, like difference in server specs, storage subsystem, network latency, etc. What is the recommended methodology and tools to get started? I expect you'll suggest that I Google. Of course, I will. But I always like to get peer advice here as well. Thanks

SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,081 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. prmanhas-MSFT 17,886 Reputation points Microsoft Employee
    2020-09-24T13:35:33.817+00:00

    @David C Firstly, apologies for the delay in responding on this and any inconvenience this issue may have caused.

    After having discussion internally I came to know that We don’t really have any specific guidelines, but we do have a couple tools out there that can help.

    HammerDB is one of the most common tools for benchmarking.

    DEA is a Microsoft tool for A/B testing, typically used for migrations.

    RML Utilities is a Microsoft tool that allows customers to capture a workload on one server and replay it on another. The DEA tool is based on this.

    Hope it helps!!!

    Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics

    0 comments