Which tool / technology: System management for databases and dependent services

manpreet Best Answer 3 years ago

I'm looking for advice on how to enable our team to take down and re-start our company systems for maintenance 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.

In other words: What technology should I use to develop a flexible solution that will allow me to stop service A, B and C on machine D in the right order and disable task E on machine F when taking down database X?

manpreet 3 years ago

We use powershell to manage SQL Server and various applications based on SQL Server, so I can definitely recommend using it. I don't know any specifics of managing Oracle with it, but I know IIS, Windows Services, SQL Server, scheduled tasks are all pretty straight-forward to manage with powershell scripts.