Documentation forServer Configuration Monitor

Database profiles in SCM

Server Configuration Monitor (SCM) offers a number of out-of-the-box database profiles. See the table below for compatible versions and a comparison of the information you can track in each database profile type:

  MS SQL Server Essentials PostgreSQL Essentials MySQL Essentials
Versions of database software that are compatible with SCM out-of-the-box profiles
  • MS SQL 2012 and later
  • PostgreSQL 12.1
  • PostgreSQL 11.6
  • PostgreSQL 10.11
  • PostgreSQL 9.6.16
  • PostgreSQL 9.5.20
  • PostgreSQL 9.4.25
  • MySQL 8.0
  • MySQL 5.7
Global
  • Configuration registry entries
  • Query optimizer hotfixes
  • Instant file initialization
  • Server configuration
  • Server properties
  • SSIS packages
  • Server settings
  • Time zones
  • Collations
  • Version information
  • Global variables
  • Character sets and collations
Server configuration
  • Linked servers
  • Database files
  • Database mail
  • Database options
  • Default data and log location
  • TempDB
  • Publications
  • Configuration files
  • Engines
  • Plugins
DB Schema
  • Filegroups
  • Tables
  • Columns
  • Views
  • Indexes
  • Triggers
  • Stored procedures
  • System database objects
  • Databases
  • Tablespaces
  • Tables
  • Views
  • Attributes (Columns)
  • Indexes
  • Procedures and functions
  • Databases (schemata)
  • Tablespaces
  • Tables
  • Columns
  • Views
  • Table constraints
  • Triggers
  • Routines
  • Routine parameters
Users and privileges
  • Logins
  • Permissions
  • Security
  • Suspect pages
  • Database roles
  • Authentication rules
  • Users
  • Administrable role authorization
  • Enabled roles
  • Database privileges (schema)
  • Table privileges
  • User privileges
  • Column privileges
  • Role table grants
  • Role column grants
  • Role routine grants
Events and jobs
  • SQL agent jobs

 

  • Events
Backup and recovery, mirroring
  • Database backup
  • Recovery mode
  • Mirroring
  • High availability
  • Subscriptions

 

Policy
  • Policy management