Hi Franz,
It turned out that DBAs only configured 1 CPU on the DB server, so we are going with configuring 3 more on the DB server which will help in getting us more room on CPU usage.
in this scenario I guess I do not need to shut down the AE for 1 hour of down time. however the DB server will be down for the time.
Can you explain what are the effects of bringing the DB server down (Job Failures, Agent Restart) and do I need to restart the AE
server as well??
I am more worried about what would happen to the jobs which are scheduled for the time when we put the DB/AE server down.
(Sorry for barging you with queries, but I guess that's the only way to learn)
Thanks
Shani