I think one reason to enable  FORCED PARAMETERIZATION for specific DBs with high volume of ad-hoc queries would be to try and reduce the size of TokenAndPermUserStore cache.  When this...

I like Sergiy's idea.  Or use sliding window partitioning, if that's a fit.  Takes a bit more work to set this up, but requires much less outage/blocking time during the...

I agree with the other comments.  But if you want to do this in the short term you can add to your "check & kill" sp a raiserror or xp_logevent...

Without giving this a lot of thought, I don't see benefit of putting HA nodes in different subnets.  I have built and supported lots of AGs, never did this.  Different...

My favorite is still Query Analyzer, with its non-tabbed MDI windows.  SSMS is second, and while the notebooks really appeal to me, I find ADS even less attractive at present. ...

I love articles like this, explosing the hidden gotcha.  Thanks for sharing.

One thing to keep in mind is that the current DB context specifies whether PARAMETERIZATION is FORCED or SIMPLE.  When FORCED, some filtered indexes may be rendered unusable.

ref:  https://www.sqlservercentral.com/articles/Indexing/129423/

Thanks, Jeff.  Very interesting.

I just sync the service master key from the old server to the new one.  Simple process: 1) BACKUP SERVICE MASTER KEY TO FILE using some pwd; 2) copy the...

I am surprised to see this.  Thank you for posting it.

Here's one way that requires a temporary 3rd node:   add a standalone SQL server; configure new AG between your existing FCI and the standalone; evict one of the FCI nodes...

I appreciate you posting this.  I reckon the exhibited behavior does make sense, but would not have occurred to me.

I also suspect index maintenance.  If so, associated LDF growth can be minimized by temporarily changing tlog backup frequency to something very frequent (e.g. 30sec) while index maintenance is running,...

I think suspending would not help anyway, just would defer all that work until later (and I think it piles up in the LDF?).

Another way to possibly improve things would...

I am not good at this stuff, really not a fan of XML, but here's an example of approach I use.  Crude example, but maybe enough to get you started. ...