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

Posted by Filburt on Server Fault See other posts from Server Fault or by Filburt
Published on 2010-05-14T10:58:47Z Indexed on 2010/05/14 11:04 UTC
Read the original article Hit count: 315

Filed under:

windows-service

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.

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

Posted by Filburt on Stack Overflow See other posts from Stack Overflow or by Filburt
Published on 2010-05-14T20:05:59Z Indexed on 2010/05/14 20:24 UTC
Read the original article Hit count: 315

Filed under:

msbuild

A follow-up on this system management question:

Since I probably will not get much feedback on serverfault I'll give it a try here.

My main concern is to reflect the dependencies between the databases, services ans tasks/jobs I'll have to manage.

Besides considering Powershell, I even thought about using MSBuild because it would allow for modeling dependencies and reuse configuration targets.

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?

Developer IT