Planning, profiling, monitoring, and troubleshooting
Database administration rightfully occupies one of the leading positions under any database management system. Every DBA has plenty of concerns and responsibilities. Among them, checking and ensuring that all databases function properly, controlling database user sessions, troubleshooting issues, and preventing troubles from happening again are the most crucial.
These tasks are routine and never-ending, requiring numerous daily checks and tuning operations, all of which fall under the umbrella of monitoring.
What you need to ensure the quality of monitoring
- Identify performance bottlenecks, failures and other issues.
- Identify slow queries and optimize them.
- Get notified about important events and potential risks.
- Access the information about all sessions running on servers.
- Monitor and examine user activities.
- Manage user permissions and logins.
- Monitor resource utilization (CPU, memory, disk space, etc.)
- Detect and predict extensive growth of database files.
"Easy, repeatable. Just works. We just wanted the easy way to do things. You've provided us with a reliable tool that we depend on daily."