Has anyone run into issues with the Daily DB maintenance routine? Ever since we upgraded our environment to 2024.1 and since to 2025.1 our daily DB maintenance routine has been crashing our application. At first it would fill up our SQLLogs volume and force the DB into recovery as there was no remaining space. We resolved this issue by upgrading to 2025.1 but now the maintenance routine, when able to actually complete, takes almost 24hrs. We have tried adjusting the time it runs; we recently worked with our DBA to drop and recreate all indexes with issues. Even ran repair with data loss but now we are getting so many blocks that the application loses its connection to the DB. Every morning, we have to restart the SQL service, and this forces the DB into recovery. We are hard down for hours while this completes. We even deployed a whole new windows server (2022) and migrated just the SolarWinds and associated DBs to this server to isolate the DB and we are still crashing. Wondering if anyone has run into any similar issues, we have had an open case with support since January 2025 and we still have not been able to fix this issue. Any assistance would be greatly appreciated. Thanks.
