Skip to content

sp_BlitzIndex: Warn of persisted statistics if we are checking statistics #3679

@ReeceGoding

Description

@ReeceGoding

Is your feature request related to a problem? Please describe.
I'm always frustrated when I use sp_BlitzIndex to check out a new database, but it doesn't warn me that somebody has persisted statistics sample rates.

Image

Describe the solution you'd like
We already warn about low sample rates, so I imagine that this is just a simple matter of adding a check of the same priority with slightly different text.

Image

Describe alternatives you've considered
I wonder if this merits a place in sp_Blitz.

Are you ready to build the code for the feature?
Yeah. It sounds easy.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions