SQL Database performance

How can we check if Azure SQL Database “Force_Last_Good_Plan” enabled?

select * from sys.database_automatic_tuning_options where name = ‘FORCE_LAST_GOOD_PLAN’

Published by Santhosh Reddy

I am working as a SQL Server DBA.

Leave a comment