Install DLM on every Prod server or onto a Live deployment Server

Bob_H

Hi,

I have been looking around in the documentation but can’t find an answer to my question.

 

I am currently looking to understand the best practice approach for hosting DLM Automation tool on our prod servers. Should I be installing the DML automation tool on every Prod SQL box or can I install it onto a Prod deployment server which then pushes the changes onto the different servers and databases?

AlexYates

Generally you want to install it on a separate machine that can talk to the SQL Server.

You don't want to let DLM Automation hog the prod SQL Servers CPU and memory. Also, you can potentially just configure one deployment machine for multiple targets. Might help with all the firewall-foo.