search

marcingminski / sqlwatch

SQL Server Performance Monitor
https://docs.sqlwatch.io
Other
428 stars 168 forks source link

index fragmentation monitor #431

Open jjjan opened 2 years ago

jjjan commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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?