Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
Recent Blog ArticlesMost RecentMost LikesImproving Azure SQL Database reliability with accelerated database recovery in tempdb We are pleased to announce that in Azure SQL Database, accelerated database recovery is now enabled in the tempdb database to bring instant transaction rollback and aggressive log truncation for tran...Re: Introducing database watcher for Azure SQL itsmeupa the closest you can get to this is filter for aborted queries on the top queries dashboard using the "Execution types" dropdown, focusing on the same time interval where you see non-zero "Nu...Re: Introducing database watcher for Azure SQL Free Azure Data Explorer cluster is separate from database watcher and is intended to let customers evaluate and get familiar with the Azure Data Explorer service. There are no plans to make free clu...Re: Introducing database watcher for Azure SQL Hi Jonathan_Allen - when you create a free cluster, you can choose from several geographical locations such as Europe or North America. However, because the free ADX cluster is not exposed as an Azur...Re: Introducing database watcher for Azure SQL itsmeupa this is a regular (paid, not free) Azure Data Explorer (ADX) cluster. This is different from the free cluster in your earlier screenshot. When you create a watcher, a paid ADX cluster is c...Re: Introducing database watcher for Azure SQL Hi itsmeupa - the 100 GB limit is approximate and depends on the compression ratio. With higher compression, the limit is higher. The actual limit is on the compressed data. We recently clarified thi...Re: Introducing database watcher for Azure SQL There are two index-related datasets: Missing indexes and Index metadata. The former is indeed used to provide suggestions to create indexes that you can see on the Activity and Top queries tabs. You...Re: Introducing database watcher for Azure SQL Francesco_beqom - Yes, you can see the top queries across your monitored database estate in the Top queries tab of the estate dashboard. You can also access the data using the Query runtime statistic...Re: Introducing database watcher for Azure SQL markgebbet - we are tentatively planning making database watcher generally available in the spring of 2025. But this depends on preview feedback and on the quality signals, so the timeline is subject...Re: Announcing a limited public preview of the ABORT_QUERY_EXECUTION query hint max_null - yes, you can run a query like this: SELECT query_id FROM sys.query_store_query_hints WHERE UPPER(query_hint_text) LIKE '%ABORT[_]QUERY[_]EXECUTION%'
MicrosoftMicrosoftMicrosoftMicrosoft
