Options
Install DLM on every Prod server or onto a Live deployment Server
Bob_H
Posts: 1 New member
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?
Tagged:
Best Answer
-
Options
AlexYates
Posts: 264 Rose Gold 2
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.Alex Yates
DevOps Mentor and Coach
Director of DLM Consultants
Creator of Speaking Mentors
Microsoft Data Platform MVP
Friend of Redgate
Twitter / LinkedIn
