sqlwatch icon indicating copy to clipboard operation
sqlwatch copied to clipboard
verified publisher icon marcingminski

index fragmentation monitor

Open jjjan opened this issue 4 years ago • 2 comments

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

jjjan avatar Dec 26 '21 19:12 jjjan

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.

marcingminski avatar Jan 05 '22 00:01 marcingminski

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?

jjjan avatar Jan 05 '22 06:01 jjjan