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

General Tech Technology & Software 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 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?

profilepic.png
manpreet 2 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.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.