Centralize the Red Gate Database, DDL and SP scripts only on the monitoring server
Centralize the Red Gate Database, DDL and SP scripts only on the monitoring server. All the monitored DBs will be pointing to this centralize DB and no need to create red gate DB and scripts on each monitored server
Pedro Penduko
shared this idea
-
dave
commented
NONE of these things can be installed on our production servers, but we still need to monitor them. We need the scripts running on a management server and to use SSMS/SQL-Compare to enquire to our productions servers. But NOTHING can be installed on our production servers.
-
WesH
commented
The DDL trigger needs a very quick destination or it will slow down activity on your servers. This sounds like you'd be trying to capture the DDL over a linked server. Having the RedGate database on the monitored server minimizes the impact to that server.
However, maybe RedGate could implement a passive monitoring strategy that requires the monitoring server to retrieve all of the metadata for all of the objects in a database. Although that would be a massive result set to compare, if it only happened nightly, it might be feasible. However, on my servers, the performance impact during the compare would be far worse than the minimal impact of the DLD triggers.
-
Pedro Penduko
commented
I want to set the DLM Dashboard to reside the Red Gate database on one server only and deploy the needed scripts like SPs to the monitored servers where all data will be pulled and save it to the centralized Red Gate database. Is this possible?