Actionable Data Analytics
Join Our Email List for Data News Sent to Your Inbox

Azure Synapse Analytics Queries #3 Last Operations in Server

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

				
			
Azure Synapse Analytics Queries #3 Last Operations in Server

 

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.       

comment [ 0 ]
share
No tags 0

No Comments Yet.

Do you want to leave a comment?

Your email address will not be published. Required fields are marked *