sp_BlitzCache: get it to work on read-only secondaries #3632
Description
Is your feature request related to a problem? Please describe.
Need to analyze performance on read-only replicas that require ApplicationIntent = ReadOnly.
Describe the solution you'd like
There have been pull requests in the past that simply skip read-only replicas, and that's cool, but even when I connect SSMS with ApplicationIntent = ReadOnly, sp_BlitzCache skips the database.
Add a parameter for IgnoreReadableReplicaDBs bit default 1. If it's passed in = 0, then skip populating the read-only intent database table.
Describe alternatives you've considered
I couldn't think of another.
Are you ready to build the code for the feature?
Yep! Built, coming right up.