What is the correct approach for handling MS SQL "system" databases?

Bobby Campbell
Kilo Sage

Our database owner does not see value in having CIs for the system databases: master, model, msdb, tempdb, mssqlsystemresource.  He has asked us to hide or otherwise eliminate them from the CMDB.

 

We have considered:

  • prevent discovery from creating these CIs, perhaps via a pattern extension
  • create a business rule or data policy to delete or retire them
  • filter our views so that these CIs still exist, but aren't visible to anyone but admins

Has anyone else encountered a similar situation in their environment? If so, how did you handle it?

0 REPLIES 0