KTSL Limited
PO Box 2637 Corsham
Wiltshire
SN13 0ZQ
UK

Tel: 0845 034 8000

Database Management

With businesses expecting 24x7 availability and demanding superior performance, maintaining availability for all elements of the business infrastructure has become a great concern for IT enterprises. However, maintaining database availability is challenging and often impossible without proper monitoring and administrative tools.

Important information for current BMC Software SmartDBA customers

BMC Performance Manager for Databases

BMC Performance Manager for Databases is a comprehensive performance and availability solution designed to help you proactively manage and monitor your enterprise database environment for exceptional performance. BMC Performance Manager for Databases monitors critical elements ñ such as tablespace size, memory sizes, and locking conflicts ñ to help you avoid and resolve problems affecting application or database availability, resource usage, and transaction throughput before problems become apparent to the end users.

BMC enables you to significantly improve IT performance and availability by:

• Using one common management method to proactively optimise your IT infrastructure throughout the lifecycle of your enterprise applications
• Implementing consistent methodology and automation of repetitive, complex and error-prone tasks
• Controlling all aspects of enterprise data management with a common toolset across mainframe, distributed and desktop environments
• Provides a direct path to Business Service Management by enabling you to proactively manage and control all enterprise applications and underlying IT infrastructure components from a business service perspective

BMC Recovery Manager for Databases (formerly known as SQL-BackTrack)

BMC Recovery Manager for Databases is a database intelligent, high-performance backup and recovery product that simplifies and automates database administration tasks associated with backup and recovery across the enterprise. BMC Recovery Manager shortens the time to recovery and maximizes IT resources, allowing your IT staff to focus on the projects that drive competitive advantage for your business.

BMC Recovery Manager is an enterprise solution that supports Oracle, Sybase, DB2 Universal Database, and Microsoft SQL Server databases on Unix, Linux, and Microsoft Windows platforms.

BMC Recovery Manager for Databases provides the following key features and benefits:

• Maximises availability by providing database-aware intelligent backup and recovery and an easy-to-use guided recovery
• Provides centralised backup and recovery across the enterprise to include business-relevant policy compliance management, reporting, and trending
• Saves time by providing archive log management and automated database duplication to local and remote hosts
• Provides object-level extraction from physical backups while hiding the complexity of a recovery
• Improves performance by using parallel backup streams and compressing data during backups
• Ensures organisation preparedness through a dry-run backup and recovery feature

BMC Change Manager

BMC Change Manager provides a scalable, intelligent solution to simplify and automate change across multiple RDBMSs. It protects against data loss, and ensures high data availability and quality change processes across complex database and platform environments.

Key Features & Benefits

• Enables implementation of complex database changes using a consistent, reliable and auditable system
• Provides a common interface across multiple RDBMS environments
• Allows users to deploy database changes whether working with applications or data modeling tools
• Eliminates errors and costly rework by thoroughly analysing database changes and migrations
• Imports hand-coded and packaged DDL, increasing availability by reducing outage time for changes

Brother-Eagle^TM Enterprise Edition for Oracle

"A Bird's Eye View to Performance Prey"

Brother-Eagle^TM identifies database problems, poor performance and inefficiencies anywhere in your IT organisation and brings it to your attention via a single, easy to read and interpret, interactive scrolling "ticker" graphical representation.

Scrolling "Ticker" Display saves valuable screen real estate Assess Database Health, Performance, & Efficiency Expert Advice Highly Customisable Interactive Drill Downs (Enterprise Edition only) Add your own metrics (Enterprise Edition only) Read more ...

Brother-Wolf^TM for Oracle

"Hunts Space Management Issues at Maximum Speed"

Brother-Wolf^TM reorganises business-critical databases while applications remain up and running and fully available to business users. It quickly and easily identifies the objects that are most active and in need of reorganisation, and then schedules reorganisation jobs for those objects. By optimising performance and reclaiming wasted disk space, Brother-Wolf reduces the need for additional storage expenditures. This automated process is ideal for complex environments such as ERP and CRM systems with thousands of user objects or e-business systems with high transaction rates

Easily Understand and Manage Space Utilisation Diagnose and correct row migration problems REORG tablespaces online for optimum performance without interruption to business application Read more ...

Brother-Owl^TM for Oracle

"Wise to SQL Performance Problems"

Brother-Owl^TM captures, analyses, and fixes application SQL and Oracle indexes. DBAs and developers can use this tool to fix SQL in production or as part of the testing process for new code. Brother-Owl gives expert advice on how to tune SQL, Oracle objects, use Oracle hints, or advise you on Index effectiveness. The product allows "What If" analysis on a variety of changes. Most importantly, all of this work can be done without impacting your production systems.

Explore & Tune SQL Performance Enables "What If" prototyping of SQL and Index changes with NO production database impact Best "Breadth" and "Depth" of SQL rewrites to improve performance Provides intelligently generated Oracle hints High Speed Data Collector (HSDC) captures SQL Performance directly from memory with negligible overhead Read more ...

KTSL's experienced database management team will be pleased to discuss your requirements with you. Please contact us for more information.

Further Reading

BMC Performance Manager for Databases datasheet

BMC Change Manager datasheet

Change Manager Case Study - Yorkshire Building Society

You will need Adobe Acrobat to view the documents on this page, which may be downloaded from Adobe's website using the following link:

All trademarks and product names are the property of their respective owners.