Welcome to the Azure Database Watcher Series! 👋
In our latest YouTube video titled “Azure Database Watcher Series: Generating Sample Workload on SQL Targets in Azure Database Watcher”, we demonstrate how to generate a realistic workload on an Azure SQL Managed Instance — a critical step before exploring metrics on the Azure Database Watcher dashboard.
To help you follow along and practice everything shown in the video, we’ve prepared a ZIP file containing all the necessary scripts. These scripts simulate a variety of workloads — including read, write, and even blocking scenarios — perfect for testing your monitoring setup in Azure.
📦 Download the Scripts
Click below to download the sample workload bundle:
🔗 Download JB_Database_Watcher_Sample_Workload.zip
The ZIP file includes the following SQL files:
Loadtest1.txt– Master script to create required objects for the workload.Loadtest1_q1.txt– Script 1 that simulates workload on the Azure SQL managed instance.Loadtest1_q2.txt– Script 2 that simulates workload on the Azure SQL managed instance.Blocking.txt– Script to check object details.
💡 How to Use
- Deploy the scripts against an Azure SQL Managed Instance that is being monitored by Azure Database Watcher.
- Follow the exact steps as shown in the video.
- Generate workloads and wait for metrics to populate.
- Get ready for our next video, where we’ll explore the Database Watcher dashboard and deep-dive into the insights gathered.
Thank You,
Vivek Janakiraman
Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.