Determine which database performance tools best mitigate bottlenecks
A collection of articles that takes you from defining technology needs to purchasing options
Bradmark Technologies Inc. offers database performance management tools for reorganization and system performance monitoring. The company's flagship product, Surveillance DB, is a heterogeneous, agent-driven database performance monitoring tool that provides visibility to performance metrics for multiple database management systems from a single console.
The four core features of Surveillance DB include:
Real-time monitoring allows users to view real-time performance statistics through the Surveillance GUI. This is useful when investigating an issue, such as a long-running SQL statement. With this feature, database administrators have access to 2,500 detailed performance metrics such as session activity, lock details and I/O. DBAs who manage more than one database can use Surveillance DB to view real-time data from multiple DBMSes simultaneously.
Proactive event management alerts DBAs when a threshold has been exceeded. Problems can be identified quickly and then analyzed in more detail using the GUI. The product includes a library of ready-to-use predefined rules; new, customized rules can also be written as needed.
A historical repository stores performance statistics and metrics over time. Using the repository, reports can be created that identify usage trends and patterns.
Data flashback lets a DBA scan through performance data stored in the historical repository, making it easier to determine the root cause of database problems.
Surveillance DB supports Oracle Database, IBM DB2 for LUW, Informix, Microsoft SQL Server, SAP HANA, SAP IQ and SAP Adaptive Server Enterprise.
In addition to its database performance monitoring tools, Bradmark offers Surveillance OS, an operating system monitor with a similar interface. Users can monitor server statistics such as CPU; disk I/O; memory; and resource utilization for Unix, Linux and Windows operating systems.
DBControl for managing database reorgs
Bradmark's DBControl is a database structure and reorganization tool that DBAs can use to implement structural changes and perform database reorganizations without impacting user productivity or application availability. It delivers an online reorganization capability that lets applications remain online, accessing database structures, while they're being reorganized. This is achieved by copying the data to a shadow data set and reorganizing the shadow while the data remains online. When the reorganization is complete, the reorganized shadow copy is swapped with the active copy.
DBControl's Tablespace Map feature helps DBAs locate objects with incorrect storage parameters. It also provides database space analysis they can use to help determine when reorganization is necessary. In addition, a GUI enables DBAs to view and manage reorganizations, which simplifies restarting jobs and analyzing job logs and statuses. DBControl provides space usage trend analysis to help identify growing database objects so that additional storage space can be added before out-of-space conditions occur. DBControl can be used to monitor and manage storage for Oracle Database and DB2 for LUW database objects.
Bradmark's product licensing and support
The company sells its database performance monitoring tools and other products direct to customers and through its network of channel partners. Products are licensed and priced by database core on the server. Enterprise licensing is also available for sitewide usage of all products.
The company offers 24/7/365 worldwide technical support online and by phone. The Bradmark Help online knowledgebase provides a web-based forum for customers and partners to get assistance on Surveillance DB and DBControl.
How one database legend is improving the way databases fetch data for websites
What are the top database security tools on the market?
How companies are using data warehouse platforms