Do you know how to find the last operations in server? When using Azure Synapse Analytics SQL Pools, many times you want to verify the latest operations or progress of your databases when scaling out and down, resuming or pausing them.
You can get the latest transactions as well as the progress of the operations by using the following query.
-- This query returns the latest operations in the server
-- it needs to be executed in the master database
-- the information in this table is removed automatically after 2 or 3 hours
SELECT [session_activity_id]
,[resource_type]
,[resource_type_desc]
,[major_resource_id]
,[minor_resource_id]
,[operation]
,[state]
,[state_desc]
,[percent_complete]
,[error_code]
,[error_desc]
,[error_severity]
,[error_state]
,[start_time]
,[last_modify_time]
FROM sys.dm_operation_status
WHAT’S NEXT?
In upcoming blog posts, we’ll continue to explore some of the features within Azure Services.
Please follow Tech Talk Corner on Twitter for blog updates, virtual presentations, and more!
As always, please leave any comments or questions below.
