How to check Azure Pricing tier change history for SQL Server Database?

2
votes

I created an AZURE SQL Database with S0 pricing tier, two months back. But somehow the pricing tier of the same database suddenly got upgraded to P15 for 10 days and then again downgraded to S0.

I want to check when and how this happened! Is there any way I can check pricing tier change history from Azure portal or using any Sql query?

Activity logs of Azure portal do not show any such pricing tier changes.

2
sql-serverazureazure-sql-database
Hi,did you see my answer? If my answer can be helps, could please accept or vote it? Thanks and have a good day. – Leon Yue
Hi, none of these helped in my case. Mine is a CSP subscription and these option does not work for CSP Azure subscription. – Shipra Trivedi

2 Answers

2
votes

Yes, in the portal you can scale the database:

enter image description here

There is no automatic auto-scaling, so somebody must have done manual changes.

//edit: Changing the SKU results in a "Update SQL Database" event in the activity log: enter image description here

1
votes

You can see a log of pricing tier changes by querying the sys.dm_operation_status dynamic management view.

SELECT * FROM sys.dm_operation_status   
   WHERE major_resource_id = 'myddb'   
   ORDER BY start_time DESC;

If you identify a pattern when these changes occur, for instance, the scale up or down occurs at the same time every day, Azure Automation is a good place to verify if a job schedule have been created that changes the service tier.