Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

index fragmentation monitor #431

Open
jjjan opened this issue Dec 26, 2021 · 2 comments
Open

index fragmentation monitor #431

jjjan opened this issue Dec 26, 2021 · 2 comments

Comments

@jjjan
Copy link

jjjan commented Dec 26, 2021

Is your feature request related to a problem? Please describe.
Hello i need monitor index fragmentation from sqlwatch. how is possible

Describe the solution you'd like
visualize index fragmation on grafana

@marcingminski
Copy link
Owner

There is already a report for this:
Report id = 1:
https://github.com/marcingminski/sqlwatch/blob/a3816987fe4f622513bdebec884d22100db6fc5e/SqlWatch.Monitor/Project.SqlWatch.Database/Scripts/Post-Deployment/Reference-Data/Script.PostDeployment-CreateDefaultReports.sql

By default, it will email you indexes with fragmentation over 30%. This is consistent with Ola Hallengrens maintenance solution. You can change it in the report definition.

@jjjan
Copy link
Author

jjjan commented Jan 5, 2022

great should enable it after deploy sqlwatch dacpac file? or by default dacpac enable this script? where can i put my email address? on grafana or whatever?
how can i have percent of index fragmention on grafana dashboard?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants