Hello;
I am looking for a way to run the Database Maintenance application from the SQL server itself, instead running it from the NPM server.
How I can do this? Or Is there a script I can run from TSQL?
Thank you
All the execution for the maintenance already occurs on the SQL server. The only thing the server does is send a command to begin maintenance and log the progression based on the feedback from the SQL server. Most of your network utilization between the app and SQL servers are going to be website calls for data, polling collection, etc. This would not speed up the execution either, since, as previously stated, all the commands are already on the SQL server. The only thing the app does is fire off the "start command" at the designated time and starts logging.
Database maintenance is a number of stored procedures in the database that are called by the commands from the Orion server. There isn't an easy way to run these in a scripted manner other than what the program does. This maintenance task runs automatically every night. Is there a reason you are wanting to run it manually from the database server?
Regards,
Matthew Harvey
Senior Sales Engineer
Loop1 Systems
http://www.loop1systems.com
Putting Knowledge Into Motion
Hi!
Yes, I would like to prevent network utilization between APP and SQL Server and for a faster execution.
Thank you for clarifying my concern.
Thank you!
Not a problem at all.
As a side note, you can always kick off DB Maintenance off-schedule using the utility on the primary poller - Start -> SolarWinds Orion -> Advanced Features -> Database Maintenance.
So where can you confirm that the maintenance is running as it should?
You can view the logs on the server. C:\ProgramData\SolarWinds\Logs\Orion\swdebugmaintenance.log.
