Home / Database Monitoring – Database Administration – DBA

Database Monitoring – Database Administration – DBA

Database Monitoring

DBA CENTRE comprehends the value of effective monitoring. There is a saying “Good defense is the best offense.” All the critical systems need 24*7 monitoring. With a good monitoring system in place, organization can avoid huge downtime in database systems which is a very critical issue for any business enterprise.

We have customized monitoring tools and plugins to manage database availability more efficiently. Our team of consultants are experts in monitoring mission critical database systems. Our automation is build around the open source tools such as Nagios, Icigna, Monyog, Grafana and Cacti. We also cater monitoring in Galera Cluster.

We will monitor with SQL Diagnostic Manager and Foglight.

Monitoring the host operating system is equally important for running the database smoothly, so beyond database parameters, we also monitor the OS stats and Network. Our team adapt the monitoring system based on the new features in Oracle 12c, MySQL 5.7, MSSQL Server 2016 and evolving new hardware’s.

We also provide capacity planning to predict the future. This prevents the downtime before the occurrence.

Platforms Supported

  • All flavors of UNIX.
  • Windows

ORACLE Database Monitoring and checklist

  • Oracle status Check
  • Backups Checks
  • Space related checks
  • Alert log checks
  • Long Running Queries
  • Open Transactions
  • Blocking Checks

MS-SQL Server Checklist

  • SQL Server status Check
  • Backups Checks
  • Space related checks
  • Error log checks
  • Long Running Queries
  • Open transactions
  • Blocking Checks
  • Deadlock monitoring
  • Log-Shipping Monitoring
  • Mirroring Monitoring
  • Cluster status Monitoring

MYSQL Server Checklist

  • MySQL status Check
  • Replication Check
  • Replication lags
  • Binary log retention’s
  • Long Running Queries
  • MySQL Thread checks
  • Open transactions
  • InnoDB Checks
  • Deadlock monitoring
  • Slow log and error log monitoring
  • Backup Checks
  • Partitioning Checks
  • Galera Status check
  • Quorum check
  • Distributed Replication Checks*
  • Multi Source Replication Checks*

OS Checks

  • Memory Checks
  • MySQL log-rotate
  • Disk space checks
  • RAID Monitoring
  • CPU & IO stats
  • Network checks
  • OS log checks
  • Security Checks

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.