Compliance Manager: Auditing Thousands of Similar Databases

by Sep 14, 2018

I am in the process of running a POC for CM to see if it will fit our needs. We have 60,000 databases – most similar in schema – across 70 or so instances. We also have a separate pool of databases with a different schema that will be monitored slightly differently. The key here is that for both pools we're going to typically only monitor activity on 1-2 tables per database along with security and schema changes on those objects. We also add new databases regularly as well as shuffle databases around instances for load balancing. We need a solution for monitoring that is scalable with this sort of behavior and structure. If we have to touch each database to set this up as well as each time we make a change the tool will be too burdensome to implement. That being said, I have a few questions to those who use Compliance Manager regularly:

  1. Is it possible to create a template for database auditing and apply it to multiple databases at once?
  2. Will the auditing configuration migrate with a database when moved between monitored instances?
  3. Can the audit config be automatically applied to new databases?

Thanks!

– Tim Ford