A Solution to the Cross-Platform Database Blues

by Aug 16, 2019

Categories

Tags

Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShell

The role of a database administrator (DBA) has undergone tremendous evolution in the 21st Century. In the murky past, a DBA could carve out a career by specializing in a particular database platform. You’d come to work and log into your DB2 or Oracle system and do your thing. Every day presented an opportunity to increase your level of expertise regarding the specific databases that you were responsible for supporting.

Those days are gone forever. In today’s fast-paced IT environment the single platform DBA is an endangered species. Your organization likely employs multiple database platforms which you need to manage. This adds complexity to your everyday work life as you move between different database systems. While the general functions that you need to perform will be fairly consistent across different platforms, the specific methods may differ based on the tools provided by the solution.

The cloud further complicates database support in a multi-platform environment.  You need to be familiar with diverse database products as well as understanding the implications of hosting them in multiple locations. Some of your databases may be on-premises while others live comfortably in the cloud. A tool that can help manage this complexity is essential to maintaining productivity in this distributed and diverse landscape.

A Tool to Manage Diverse Database Platforms

Aqua Data Studio (ADS) provides a tool that can mitigate the complexities of multi-platform support. The application offers a versatile database management and development solution that can tame the most complex implementation. You can access and manage all your database instances from a common interface which in itself will boost productivity. Think of all the time that can be saved by eliminating the need to jump around to different idiosyncratic management platforms.

One of the more outstanding features of Aqua Data Studio from a DBA’s perspective is how they have customized the tools within the application to conform to the database platforms that you will be administering. This customization increases the value of the app and will help streamline the daily activities that are required to keep your systems running efficiently.

Let’s take a look at some specific database platforms and the customizations that are built into Aqua Data Studio to make it easier to manage your systems. The general utilities which are similar to all platforms take into account the differences in the databases to provide precise functionality for your database team. Each tool provides a GUI for viewing and searching within the given Manager.

Amazon Redshift DBA Tools

Amazon Web Services (AWS) offers the Redshift data warehouse to its cloud customers. ADS provides a suite of tools designed for DBAs working on this platform.

  • Instance Manager enables investigating query history and instance summaries.
  • Session Manager displays session details, statistics, locks, and grouping. You can also kill a session from within the tool.
  • Storage Manager lets you view, create, and drop storage for your databases.
  • Security Manager allows you to view, create, alter, and drop users and groups from your database.

Oracle DBA Tools

DBA’s administering Oracle systems will benefit from these tools, which provide modify access in addition to view and search capability.

  • Instance Manager lets you work with control files, Oracle job information, as well as general instance, Oracle, hidden, and NLS parameters.
  • Session Manager gives you access to session details, statistics and many detailed items such as locks, open cursors, and long operations. You can trace and kill a session from here.
  • Storage Manager is meant to work with Oracle tablespaces, datafiles, and objects and displays file and object I/O statistics.
  • Security Manager which enables you to view, alter, create and drop users, roles, and profiles.
  • Rollback Manager works with rollback segment properties.
  • Log Manager lets you with log files, take checkpoints, and view the parameters of archive logs.
  • SGA Manager and Oracle Server Statistics are two additional tools specifically designed for Oracle databases.

Microsoft SQL Server DBA Tools

The Aqua Data Studio tools designed for Microsoft SQL Server also furnish edit or modify capacity where appropriate.

  • Instance Manager lets you access instance summaries, parameters, and server logs.
  • Session Manager provides session statistics, details, locks, and groupings by process ID or other parameters.
  • Storage Manager enables many operations to be performed on a database’s storage including backup and restore, setting checkpoints, and shrinking capacity.
  • Security Manager allows for viewing and modifying security settings rated to database users and roles.
  • Agent Manager lets you view, create, drop or alter alerts, jobs, and operators.

As you can see from the rundown of the specific toolsets, while their general functionality is similar, the details are tailored to the design and features of the databases on which they operate. This is what makes these tools incredibly valuable to the DBAs using them.

This is not an exhaustive list of the database platforms supported by Aqua Data Studio. Tools for many other flavors of databases are available in ADS. Our list is intended to illustrate how the application presents a method of managing many databases from a single point while offering the specific features required to handle your environment’s software diversity. DBAs working in multi-platform installations will enjoy the time-savings and productivity gains that Aqua Data Studio will provide.