I was wondering what is done to maintain the servers and/or databases once everything is setup. What are the best practices everyone does. Please share.
Solarwinds runs maintenance every day default at 2:15 am and cleans up old records which falls out of the retention period... it also shows up a notification in console if it had some prob in completing..
Apart from this you can setup monitoring of Solarwinds server and DB using SAM templates OR just service monitoring... U can also have a daily report which shows health of Solarwinds....
If u have any other source from where u can monitor Solarwinds then that would be an added advantage to know in advance about Solarwinds not being accessible.
On DB level, if u have dedicated team then request them to have the health check done frequently and inform on issues found...
This KB explains how to set up a basic maintenance plan in SQL
How to create a SQL Server maintenance plan - Video - SolarWinds Worldwide, LLC. Help and Support
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.