Several Years ago - I found an article about of things that should be "done'" regularly.
I would like to know do these still hold true?
Are there things that I am missing?
Or are there things not needed any longer?
Again comments would be of great help.
Database Maintenance Review - Monthly
Verify Database Maintenance is Completing
Review C:\ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log
Ensure “Database Maintenance Complete” Message appears in a reasonable amount of time from when it beings
Typically begins at 2:15AM every morning by default
Ensure you have Database backups & you can restore from those backups (otherwise there isn’t much value in them)
Index Rebuilds / Reindexing - Ensure this is happening Quarterly at minimum
Review Total Database Size and/or large tables for uncharacteristic growth
Verifying Trap & Syslog Messages are being cleaned out (Cause of space reservations in SQL DB)
NCM Refresh EOX Information - Monthly
NCM maintains a database with EOS data for Cisco device models. Based on a schedule, NCM matches EOS data with the machine type of your NCM devices. What you see in the table of the EOS resource is the result of the matching. To make sure you are looking at the latest matches, use Refresh Suggested Dates.
Click My Dashboards > Network Configuration > End of Support.
Select the devices for which you want updated data, if available.
Click Refresh Suggested Dates.
Settings and Configurations - Monthly
Review Polling Engine Polling Status/Rates
Check Polling Completion (Polling Engine Status Report)
Check Polling Settings (Consider Alert Time Frames vs. Polling Intervals)
Reminder - Retention Syslog, Trap, Discovery, Downtime - Will increase DB Size
Review Logging Levels - Utilize Logadjuster.exe to see all logging settings
Ensure that Logging Levels are at the Defaults or specified standard settings
Review Logs with Quick Rotations/Timestamp Successions
Review Diagnostic Logs for Errors - Check against Success Center for common issues; escalate to Support if KB is unable to solve
Ensure Permissions are set appropriately (Run Orion Permission Checker)
Preventative Maintenance - Monthly
Review and apply as needed Application Patches, Hotfixes
Review and apply as needed Updates to OS, Hardware Drivers, etc.
Review CPU/Memory/Disk on Orion (You are monitoring it right?)
Check Active Diagnostics Bi-Weekly
Run Diagnostics - Store elsewhere than application or database server (Redundant Storage Drive recommended)
Take Snapshots (If virtualized)
Review Enable/Disable Automatic Baselining settings as needed
Review Enable/Disable Automatic Dependencies as needed
Alerts should be running every 1 minute - unless the environment calls for alternative timeframes
Check in-house created Alerts’ raw SQL Queries against Estimated Execution Plan Time in SQL Server Management Studio to ensure queries don’t need refactoring
Review “Down” or “Unknown” Nodes or Applications for polling errors or that need to be unmanaged or removed from monitoring
Review Custom Property Utilization Across the Board for all Nodes, Applications, Interfaces, etc. - Fill in gaps where needed
Thank You for your time an comments.
