• Active Directory
  • Application
  • Desktop & Mobile
  • Help Desk
  • Network
  • IT Security
  • MSP
  • On-Demand
 
 
Device Management, made easy
Manage control and secure your workstations, mobile
devices and tablets
 
 
Help Desk for Everyone
IT Help Desk Software and Customer Support Software
 
 
Protect Your IT. Save Your Business
Build a secure fortress with our security management solutions
 
 
MSP
Manage services faster, with multi-tenanted, ITIL-ready, and unified RMM solutions
 
 
On-Demand Solutions
IT Help Desk, Active Directory, and Operations Management from the Cloud
 

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 monitor the health of SQL server replication with SQLDBManager Plus. 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 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.

You can also monitor the mirroring details of SQL databases - attributes pertaining to Principal and Mirror Logs, Mirroring Sessions and Mirroring Performance Counters.

  • Mirroring Details like mirroring role, status, mirroring partner, partner connection, transaction safety and witness details.
  • Principal Log Details like unsent log, oldest unsent transaction, time to send log, current send rate and current rate of new transactions
  • Mirror Log Details like unrestored log, time to restore log and current restore rate.
  • Mirroring Session Details like mirror commit overhead and send/ restore log time.
  • Mirroring Performance Counter Details for principal and mirror database like logs sent, log send queue, average delay per transaction, logs redo and redo queue.

mirroring details