User Login Bradmark Offices Bradmark Homepage Bradmark Homepage
About Bradmark Bradmark Product Solutions Professional Services/Training 24/7 Technical Support
Bradmark Authorized Partners
Bradmark Products
Oracle Solutions
Sybase Solutions
DB2 UDB Solutions
MS SQL Server Solutions




For all sales inquiries or additional product information, contact your regional Bradmark sales representative. 

24 Hours-a-day,
7 Days-a-week

 


Proactive database monitoring tool that quickly identifies problems and alerts DBAs before impacting availability.

 

(PDF; 367K)

 Download Whitepaper
Surveillance Technical Whitepaper: The Evolution of Information
(PDF: 2.3M)


Surveillance DB provides a facility to display an extensive set of predefined windows that provide an immediate global view of database activity and detailed performance metrics such as session/process activity, locks, batch contention, file I/O, and much more. Real-time data from multiple RDBMS can be viewed simultaneously. Data from each window can be sorted or filtered while most statistics can be graphed over time. In addition, each window or graph can be configured to refresh at either the default collection interval or its own refresh interval.

 

Easy Installation
Surveillance DB installs in only minutes and is able to be configured to begin monitoring right away.


Flexible Agent Architecture
Agents can run directly on the server (native agent) or in a multi-tiered configuration. This allows you to configure your agents to your business requirements, and you are not bound to some pre-determined architectural restriction, such as a centralized console. With Surveillance DB, you can monitor all of your Oracle, Sybase or SQL Server databases from either a single or multiple console configuration through an intuitive graphical user interface. 


Real-Time Monitoring
Surveillance DB is a real-time monitoring tool capable of overseeing your entire database environment. A DBA can view real-time performance data without writing scripts, reducing the need for a large, skilled staff to trace problems. The Surveillance DB Module deploys an analytical drill-down methodology for quick problem identification. 

For example, Surveillance DB for Oracle provides a set of pre-defined windows that are used to immediately display real-time information for a variety of performance statistics. Highlighting an entity under the Oracle agent displays a context toolbar at the top of the screen. The buttons on this toolbar represent the primary windows available for real-time monitoring. The buttons available depend upon the version of the Oracle database that is highlighted.

If the first button on the context-specific toolbar was clicked, a Global window would be opened for the corresponding database on that server, displaying important statistics regarding the status of the Oracle instance. Double-clicking on a line in a window allows you to go deeper or to "drill-down" to start a time-line graph for that statistic.


The Analyzer
Surveillance DB has an extensive alerting and alarming facility that comes with a large set of pre-defined collections and rules. To begin monitoring, the DBA uses these pre-defied rules to easily adjust default values and collection intervals before turning on the rules to be monitored.


User-defined Collections
The Surveillance DB Collector Agent is responsible for collecting the performance data from the entity via pre-defined collections. The data must first be collected by the collector agent before data can be used by the analyzer or repository agent for the Event Management and Historical Repository features. In the past, the end-user was limited to alerting and adding pre-defined collections to the repository, and was unable to modify or add new collections. With Surveillance DB, a facility exists for users to create user-defined collections that can be used with the Event Management and Historical Repository features.


User-defined Repositories
The Repository Agent is a process that stores historical performance or application data from any pre-defined or user-defined collection. Historical data is retained in named stores, which have user-specified time intervals and duration. An interval compression algorithm is used to minimize disk utilization.

Data from the repository is used to obtain a historical perspective when the Surveillance DB's Event Management feature detects and alerts the DBA that conditions are occurring that are negatively impacting performance. Data from the Repository can be used to trend performance and space utilization data; or the DBA could use the data to establish baselines for threshold values in Event Management's rule definitions.

Any ODBC-compliant reporting tool can be used to query and/or graph the historical data.

Back to top


Multiple Action Event Handling
Right out of the box, Surveillance DB can be easily set up to notify multiple DBAs by e-mail, pager, HP Openview or Tivoli alerts, pop-up windows, or to record the error in the Windows Event Log. The DBA can also execute a fix-it job by executing any operating system executable, including SQL*Plus and ISQL.

Surveillance DB automates the monitoring process through rules analysis and event generation. From these events, the system determines the actions that need to be taken. This process begins by defining and applying data rules in the Analyzer Agent. When the agent is started, it loads its rule set, attaches to the appropriate data collections, and begins a continuous process of evaluating rules. If a rule has been satisfied (for example, something noteworthy has occurred) it generates an event that is sent to the local alerter. The Alerter receives the event, and determines which, if any, Event Handler is appropriate for handling the event. 


Repository
Surveillance DB provides a mechanism for storing data collections to a repository for reporting and analysis. This process begins by defining data stores in the Repository Agent. When the agent is started, it loads its list of defined data stores, attaches to the appropriate data collections, and begins its continuous process of storing data.

Data Store definitions inform the Repository Agent what to store, how often, and for how long. Data Store definitions must be specified for the desired server entity and collection. 

A Repository Export Program can be used to export the data obtained in the Repository partitions. Once the repository data is stored in a comma-delimited ASCII file, it can be imported to a spreadsheet or database. This facilitates statistical reporting to analyze the performance data being monitored.


Unlimited Client Installs
With the purchase of the Surveillance DB Server Agent, you will be able to install the Client on an unlimited number of machines.


Surveillance Reporting Module
The Surveillance Reporting Module is a combination of several technologies and features that together provide the customer with a comprehensive reporting system. There are three major components to this module: the local host-based repository, the centralized repository, and the reporting system.

  • Local Host Repository Collection and Reporting
  • Surveillance Centralized Repository
  • The Surveillance Reporting Module

With either added solution, customers can create their own report specifications and use the predefined Surveillance report specifications.

 

Back to top