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: 311

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?

© Stack Overflow or respective owner

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: 311

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.

© Server Fault or respective owner

Related posts about systemmanagement

Related posts about powershell