HammerDB is one popular and easy-to-use tool that a lot of people are using to benchmark the performance of the databases. In the previous article, I have used 100 HammerDB users to measure the performance of the workload on TPCC database with 5000 warehouses, and the conclusion was that in…

When you migrate your databases from SQL Server (on-premises or Azure VM) to Azure SQL Managed Instance, the first thing that you might want to do is to compare the performance of your database in new environment with the performance of the original database on the source SQL Server. In…

One of the most important tests that you need to run on your database is a performance test that shows you how many queries, requests, or transactions you can run. In the previous articles, I have used HammerDB to run a simulation of TPCC workload with 100 users on an…

When you migrate your databases from one SQL Server instance to another or from SQL Server to cloud (for example Azure SQL Managed Instance), one of the first things you would like to do is to compare the workload performance between source and target environment. …

HammerDB is one popular and easy-to-use tool that a lot of people are using to benchmark the performance of the databases. In the previous article, I have used 100 HammerDB users to measure the performance of the workload on the TPCC database with 5000 warehouses, and the conclusion was that…

HammerDB is a popular benchmark tool that simulates TPCC workload and that a lot of people use to benchmark different environment. In this article I will explain how to run HammerDB Managed Instance and analyze performance on Managed Instance. WARNING: HammerDB is not official standard and don’t have precise specification…

Azure SQL Database Managed Instance is a fully-managed SQL Server database engine hosted in Azure cloud. In General Purpose architecture of Managed Instance, SQL Server database engine is placed on a stateless compute VM that contains only tempdb, while all other database files are placed on remote Azure Premium disk…

Azure SQL Database Managed Instance is SQL Server database engine hosted in Azure cloud. General Purpose tier of Managed Instance is placed on Azure infrastructure where SQL Server process is placed on stateless VM, and data files are stored on Azure premium storage. One of the important thing you will…

Azure SQL Database Managed Instance is a fully managed version of SQL Server Database engine hosted in Azure cloud that provides built-in maintenance operations such as automatic backups. Managed Instance guarantees that the database backups are taken every 5–10 min (log backups) so it must ensure that it can take…