We've been having issues with DB maintenance lately after we moved our SQL server to a cluster. We've been manually checking the log file located at C:\ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log to make sure it's completed, but i'm wondering if there's a better way to do this, perhaps with SAM. I was thinking of just creating a custom powershell monitor and checking if "Database Maintenance Complete" is in the file, but not sure if there's a better way.
Top Replies
-
We have a dedicated dashboard in our Tools View which our team use as part of Daily Checks: It uses the below SWQL SELECT TOLOCAL(ST.EventTime) AS [Start Time] ,TOLOCAL(ET.EventTime) AS [Finish… -
We use this SQL in a report every day that shows the duration. SELECT [message], [eventtime] FROM [dbo].[events] WHERE [message] LIKE '%Nightly Maintenance%' AND [eventtime] >= Dateadd(hh, -24, Getdate… -
Have modified a bit to give the latest maintenance failed incase if you have triggered multiple times. please use this code. For trigger & reset condition, you just have to use the query starting from…
Parents
-
You can check in your My Orion Deployment tab.
Troubleshoot Orion Deployment issues with Active Diagnostics (solarwinds.com)
-
