Database & Replication Monitoring

SQLDBManager Plus displays in-depth information on Database Name, Data File Size (in MB), Percentage of Log Used, Status of Databases, Availability and Health of Databases, etc. Through 7/30 reports, you can identify the growth patterns for various databases and use it for capacity planning according to the need. In addition, the following performance metrics for Data File and Log File is also displayed in the Database tab.

  • Used space
  • Free space
  • Total space
  • Max size

You can also monitor the health of SQL server replication with SQLDBManager Plus. You can monitor the status of publications, subscriptions and information about each replication agent running in the SQL server.

  • Publication and subscription status
  • Distribution latency
  • Current average and worst performance
  • Performance of a subscription
  • Replication agent status
  • Expiration Status

By configuring alarm for specific databases which needs utmost care, DBAs can avoid cases where the database is full without his/her knowledge resulting in loss of queries or delays in query execution. By monitoring the percentage of log used, DBA can now ensure know before hand whether the particular database in question is being overused and if they need to increase the size of the database or not. This also presents the user with an insight into the growth patterns of the database and help re-design databases to perform more efficiently and effectively.

  • Database Name
  • Data File size (MB)
  • Percentage of Log Used
  • Creation Date
  • Status
  • Availability
  • Health
  • Ability to Configure Alarms for specific Database
SQL Server Database Metrics

SQLDBManager Plus also pulls in Log Shipping Status information for the DBA to view. It gathers information such as Database Name, Agent Type, Status, Time Elapsed (in min), Log Time, Error Log Time and Error Message.