Which tool / technology: System management for databases and dependent services
- by Filburt
I'm looking for advice on how to enable our team to take down and re-start our company systems for maintainance purposes.
The scenario includes
several Oracle db machines
several MS SQL Server machines with multiple instances
windows services (IIS etc.)
BizTalk EAI solution
Apache and Tomcat instances
lots of scheduled tasks
on win2003 and win2008 machines (physical and virtual).
The main focus is on capture all dependencies between said databases and services and tasks connecting to them.
At the moment an enterprise class solution is not an option.
We are considering developing a solution driven by PowerShell scripts but I hope for some more suggestions.