Blog Post

Azure Database Support Blog

4 MIN READ

Lesson Learned #450: Automating Alert Notifications for Query Data Store Usage in Azure SQL Database

Microsoft

Nov 02, 2023

In this article, we will introduce a PowerShell script that helps monitor the usage of Query Data Store (QDS) in SQL Server databases. The script automatically sends an email alert when the storage s...

Published Nov 02, 2023

Version 1.0

Jose_Manuel_Jurado

Microsoft

Joined November 29, 2018

View Profile

Azure Database Support Blog

Follow this blog board to get notified when there's new activity

Michael Bourgon

Brass Contributor

Nov 20, 2023

Jose_Manuel_Jurado would it be possible to show us how to turn this into a scheduled Azure Function? (Elastic Jobs are still in preview and our company prohibits the use of preview features). In general, knowing how to do that would be really helpful. Thanks!