Tool Monitors Database Performance
The tool, BMC Software Inc.s ASE Performance Monitoring Option-DBXray for Sybase, is designed to simplify database management through a performance dashboard that allows DBAs (database administrators) to monitor the health of a system, anticipate and solve potential problems, and get a 24-hour view of activity for database performance optimization.
DBXray for Sybase provides monitoring capabilities from any PC with a common Internet browser. Besides providing a graphical snapshot of overall database health, it also identifies and eliminates potential server resource and other problems that could impact performance and availability. When specific activities fall outside user-defined thresholds, the monitor alerts users to the potential problem. Alerts are archived for 14 days so that recurring performance issues can be identified. To help DBAs avoid bottlenecks, DBXray for Sybase also provides information on disk subsystem and RAID configurations.
The tools 24-hour view of system activities is designed to help DBAs optimize performance, allowing users to determine peak activity periods and thereby schedule resource-intensive tasks during off-peak hours. Database activity is measured based on the number of cache reads or datagrams per second, I/O per second, and response times. Users can monitor memory use through detailed view of hit ratios for buffer cache and procedure cache, allowing them to track database usage patterns and recognize fluctuations in normal activity that demand more memory. Drilldown screens provide additional details about objects currently stored in memory. User and SQL drilldowns also provide information about each user and the SQL they are executing, allowing termination of inactive or redundant sessions.
The tool, shipping now, is available directly from Sybase as an option in Sybase ASE 18.104.22.168 and is integrated with Sybase Central, a common graphical management console for all Sybase server and middleware products. It will be supported by Sybase, said company officials in Dublin, Calif. The tool runs on Windows NT 4, Windows 2000 and Windows Professional and includes an embedded application server. Pricing is $995 per CPU on the database system being monitored.