BMC Software has released its DBXray for Sybase's Adaptive Server Enterprise (ASE), a tool that allows database administrators to interface with the database through any Web browser.
The tool simplifies performance management of Sybase's relational database management system through a dashboard, allowing administrators to monitor the health of a system, anticipate and solve potential problems, and obtain a 24-hour view of activity for performance optimisation.
"Our user community depends on Sybase ASE to meet its high availability and performance needs," says Julie Tomlinson, sales manager for Sybase SA. "With DBXray for Sybase, we can help administrators further optimise their ASE systems with a performance monitoring tool that has been extensively tested with ASE 12.5.0.3 and is integrated with the Sybase Central management tool."
DBXray will be available as an option in Sybase Adaptive Server Enterprise 12.5.0.3 and will be supported by Sybase.
The BMC product allows database administrators of all levels to monitor database performance and health from any PC with a browser. In addition to providing a graphical snapshot of overall database health, DBXray identifies and eliminates potential server resource and other problems that could impact performance and availability.
"As a strategic enterprise management partner for Sybase, BMC works closely with Sybase to ensure the best management solutions for its customers," says Gene Austin, VP and GM, Enterprise Data Management, BMC Software. "By simplifying database management for administrators with solutions like DBXray for Sybase, BMC and Sybase are enabling them to focus on more critical tasks while ensuring the performance of their Sybase ASE system."
When specific activities of the database fall outside user-defined thresholds, a monitor alerts administrators to the potential problem. They can drill down on those issues in detail, and get advice on how to solve them. Alerts are archived for 14 days, ensuring that recurring performance issues are identified and solved. The product also provides information on disk subsystem and RAID configurations, helping users to avoid bottlenecks.
The 24-hour view of system activities helps administrators optimise performance, allowing them to determine when peak activity periods occur, so they can schedule resource-intensive tasks during off-peak times. Database activity can be 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 views of the hit ratios for buffer cache and procedure cache, allowing them to track database usage patterns and recognise fluctuations in normal activity that demand more memory. Drill-down screens also provide additional details about the objects currently stored in memory. User and SQL drill-downs help further optimise the overall system, providing information about each user and the SQL they are executing, and allowing termination of inactive or redundant sessions.
Share
Editorial contacts