Database Monitoring

Database monitoring and check service is designed and priced to help small and medium sized organizations to align and grow with the business. For small and medium size organizations, having a dedicated DBA team is an overhead. As these are highly paid and skilled resources, getting the right skilled person is a nightmare.

We have come up with an affordable remote monitoring service model which is proven to work for these type of organizations.

Feature Highlights

  1. Is a remote service provided by a team of DBA’s
  2. Prevent Database failures and downtime
  3. We efficiently monitor your databases
  4. We rely on both automated and manual monitoring
  5. Collect performance data asynchronously using proprietary monitoring application.
  6. SQL Server 2000 through SQL Server 2014 environments are fully supported

How it works?

  • Various database scripts are executed to collect the health data from the servers
  • Monitoring data is collected in a central repository
  • Our proprietary tool transforms the data to generate the dashboard and various decision making reports
  • We rely on both automated and manual monitoring
  • Indicators and alerts are handled by the DBA’s to take appropriate action

Our Service

  1. Automatic database backup daily
  2. Daily monitoring of key performance indicators and service level
  3. Detailed performance reporting
  4. Analyze the databases, drive spaces, growth etc for capacity planning
  5. Daily, weekly and monthly monitoring of specific tasks
  6. Email alerts in case of anomalous and / or critical situations, also providing assistance for trouble shooting
  7. Collect monitoring data in a central repository for historical information and better decision making for capacity planning. We do not collect any user information.
  8. Just an email away for any advice or support
  9. Web based dashboard for the client to view decision making reports
  10. Access to past alerts and fix suggested

Data Monitored

  • Long running queries
  • Failed login attempts
  • Database size growth over a period
  • Free disk space available
  • Database backup analysis
  • Average reads and writes
  • Buffer Cache Hit Ratios
  • Page Life Expectancy
  • Checkpoint Pages
  • Lazy Writes
  • Free Pages
  • Memory Grants
  • Latch Waits
  • Memory Usage
  • CPU Usage
  • Disk Usage and I/O
  • Replication Latency
  • Concurrent Users
  • Database Free Space
  • Transaction Log Size
  • Database Free Space
  • Lock Waits
  • Deadlock Counts
  • Page Splits