Hi Jeff,

Thanks for the information,

The problem we are facing is when SQL decides to change the plan it was using, then the query run really slow for at least a...

Hi Jeff,

I do not have force parameterization turned on. The sp passes two parameters as input. One is productcode varchar and locationid int. I checked the data and there is...

I will check the execution times as well.

Everything is one database.

I checked all the 4 plans generated for the SP and they all have the same SET options. So, now I will look for parameters that SP is running with,...

Thanks Grant,

I will check the plans for the query and go from there.

Regards,

Anoop

are you able not able to create any objects in the database or getting creating a specific object

Thanks All for your input, will try to enable the query store and let you know how it goes.

I am thinking of disabling this option on UAT database we have and monitor it for a week or after which I will move it to production.

I do not have...

Hello, Thanks for your reply. Looks like someone set the database scoped option for the legacy cardinality estimator to 1. will change that to 0 and see how performance improves.

Thanks

Thanks for writing this, was able to start using sql azure because of this simple article.

Thanks worked for me as well. I also forgot to give dates for initial certificates and they expired.

We monitor running time of reindex jobs and stop the job it goes over x hrs.