Is your feature request related to a problem? Please describe.
As databases grow over the years and integration jobs update tables, indexes tend to be very fragmented, and customers report slowness creeping in, and even SQL timeouts started to become more frequent.
In an ideal scenario we'd have a DBA staying on top of these. We try to click on "Rebuild Indexes", but that hardly ever produces results.
It wasn't until we started running a SQL script that Imar Spaanjaars provided to rebuild and reorganize indexes, that we started to see some immediate improvements on those.
Maybe a scheduled add-in we can set to rebuild the indexes every week during downtime, as a poor-man's approach to DBA activities
Describe alternatives you've considered
Since "slowness" is a very unspecific issue, we spent countless times looking into SQL settings, infrastructure, code, caching, increasing VM resources and version upgrades (in the hopes to fix some).
We also considered a more DBA activities and a more in-depth approach to creating indexes.
We also followed Azure recommendation to creating and dropping indexes with little/no success on perceived performance.
Additional context
This topic was discussed with Jeppe at the Summit
Is your feature request related to a problem? Please describe. As databases grow over the years and integration jobs update tables, indexes tend to be very fragmented, and customers report slowness creeping in, and even SQL timeouts started to become more frequent. In an ideal scenario we'd have a DBA staying on top of these. We try to click on "Rebuild Indexes", but that hardly ever produces results. It wasn't until we started running a SQL script that Imar Spaanjaars provided to rebuild and reorganize indexes, that we started to see some immediate improvements on those.
Describe the solution you'd like
Describe alternatives you've considered Since "slowness" is a very unspecific issue, we spent countless times looking into SQL settings, infrastructure, code, caching, increasing VM resources and version upgrades (in the hopes to fix some). We also considered a more DBA activities and a more in-depth approach to creating indexes. We also followed Azure recommendation to creating and dropping indexes with little/no success on perceived performance.
Additional context This topic was discussed with Jeppe at the Summit