HP OpenView Smart Plug-in
for Microsoft SQL Server
Product brief
The HP OpenView Smart Plug-in (SPI) for Microsoft® (MS) SQL Server is the intelligent choice for managing SQL Server environments of any size—from a single SQL Server database managed with local tools to a distributed environment of hundreds of databases managed from a central, best-in-class console.
The OpenView Smart Plug-in will increase availability and performance, let you visualize capacity shortages and trends and lower the costs of maintaining a SQL Server environment. To maximize your return on investment, HP provides high-quality software services that address all aspects of your software application life-cycle needs and align with your business goals. With HP, you have access to standards-based, modular, multiplatform software coupled with best-in-class services and support.
Key features and benefits
• Proactively reduce MS SQL Server down time — The MS SQL Server SPI, with
more than 30 predefined threshold events for SQL Server and several log file conditions that are easily deployed to MS SQL Server, works to proactively identify database problems before they affect applications and end-users.
• Get only the needed level of information — The MS SQL Server SPI provides
administrators with only the information they need. At the highest level of aggregation, roll-up metrics provide a single exception message to report on trouble within
databases. For more detailed information, drill-down metrics provide object-specific messages. For environments that demand very selective monitoring, administrators can apply filters and object-specific thresholds.
• Facilitate fast recoveries — The MS SQL Server SPI reduces mean time to recovery
(MTTR) through intuitive instructional text, automatically launched snapshot reports, the ability to shut down or restart servers from a remote location, and the ability to see the last 40 lines of the SQL Server log file to assist in root cause analysis.
The HP OpenView SPI for Microsoft SQL Server helps administrators
efficiently manage SQL Server environments of any size, from a
single SQL Server database managed with local tools, to a
Other benefits
• Flatten the learning curve — The MS SQL Server SPI is configured and operated
through the familiar interfaces of the OpenView Operations family, enabling operators to confidently assume routine database monitoring activities without learning a new management paradigm.
• Delegate without losing control — The MS SQL Server SPI allows database and
IT administrators to precisely configure each database operator’s environment. • Comprehensive monitoring capabilities from one software package — The MS SQL
Server SPI even checks whether Report execution by MS SQL Server Reporting Services has completed or failed. It diagnoses the problem and its cause.
The MS SQL Server SPI increases SQL Server RDBMS availability and performance,
while letting database administrators visualize capacity shortages and trends and,
consequently, lowering the costs of maintaining a SQL Server environment.
Product Functionality Overview
Event /Action
HP OpenView Operations monitors key operational activities and events to ensure always on availability, including:
• Caching information (cache hit %, cache free buffer %) • CPU activity (SQL Server CPU utilization)
• Activity information (number of current users, database open information) • Transaction data (server transaction rate, database transaction rate) • Deadlock information (deadlock rates, deadlock rates by object)
• Lock Data (lock wait rate, lock wait rate by object, average wait per lock)
Performance
HP OpenView Performance Manager monitors critical SQL Server resources, including: • Server availability (reports uptime information)
• Server database size (database size in MB allocated and used) • Server table size (table size in MB allocated and used)
• Server virtual device size (virtual device size in MB allocated)
• Server workload I/O (number of physical reads/writes during last measurement interval) • Server sessions (maximum number of sessions recorded during 5-minute interval)
• Server transactions (number of transactions during 5-minute interval, long-running transactions)
Service reports
HP OpenView Reporter enables IT to provide timely, accurate reports to prove IT service quality levels. It provides pre-defined reports in the areas of availability, space
management, workload and operations (15 in total).
Figure 1. This report from HP OpenView Reporter gives a quick graphical overview of the top tables by allocated size.
Service views
HP OpenView Smart Plug-in for MS SQL Server offers auto-discovery and visualization of the MS SQL Server service topology, comprising more than four object types and their
A complete solution
Through the combination of multiple HP OpenView Smart Plug-ins, HP OpenView provides a comprehensive solution covering MS SQL Server and non-MS SQL Server components of your business process.
HP OpenView monitoring architecture for MS SQL Server databases.
Figure 3. HP delivers a comprehensive solution for MS SQL Server environments in support of your business.
Get the most from your software investment
HP provides high-quality software services that address all aspects of your software application life-cycle needs and align with your business goals. With HP as your
partner, you have access to standards-based, modular, multi-platform software coupled with HP’s best-in-class services and support portfolio. HP offers a scalable set of services for HP OpenView and HP OpenCall products and solutions. This wide range of service offerings enables you to choose the services that best match your business needs.
For more information on HP software services available to address your specific business needs, visit www.openview.hp.com/services.
Comprehensive training
HP provides a comprehensive curriculum of HP OpenView and IT Service Management courses. These offerings provide the training you need to realize the full potential of your HP solutions, increase your network optimization and responsiveness, and achieve better return on your IT investments.
With more than 25 years experience meeting complex education challenges
The smartest way to invest in IT
HP Financial Services provides innovative financing and financial asset management
programs to help you cost-effectively acquire, manage and ultimately retire your HP solutions. For more information on these services, please contact your HP sales representative or find us on the web at www.hp.com/go/hpfinancialservices.
Technical specifications
Managed MS SQL Server Nodes
Supported MS SQL Server releases Microsoft SQL Server 6.5, 7.0, 2000, 2005 Supported Operating Systems Microsoft Windows
Supported OpenView Platforms HP OpenView Operations Agent, HP OpenView Performance Agent Management Server
Supported OpenView Platforms HP OpenView Operations, HP OpenView Performance Manager, HP OpenView Reporter, HP OpenView Performance Insight
Supported Operating Systems Microsoft Windows, HP-UX, Sun Solaris For detailed release compatibility, contact your HP reseller or HP sales office.
Ordering information
Part number Product name
For more information about hp OpenView smart plug-in for WebLogic Server, contact your local HP reseller of HP sales office:
Australia/New Zealand:+61 3 8877 4097, [email protected]; China: +86 10 6564 3678, [email protected];
Europe: [email protected];
Hong Kong: +85 2 2805 3551, [email protected]; India: +91 11 690 6176, [email protected]; Japan: +81 3 3331 6111; Korea: +82 2 2199 0913, [email protected]; Malaysia: +603 2698 6555, [email protected]; Philippines: +63 2 894 1451; Singapore: +65 6275 3888, [email protected]; Thailand: +662 661 3900; Taiwan: +886 2 2712 0404, [email protected];
United States of America: 1-877-OV-OWNER or visit www.openview.com
© Copyright Hewlett-Packard Company 2006. All Rights Reserved. Reproduction, adaptation or translation without prior written permission is prohibited except as allowed under the copyright laws. Microsoft, Windows and Windows NT are U.S. registered trademarks of Microsoft Corporation.
For more information, visit www.openview.hp.com
