HP Storage Essentials V5.1 Application Guide First Edition (T4283-96028, August 2006)

Storage Essentials 5.1 Application Guide 35
5 Monitoring Microsoft SQL Server
IMPORTANT: Depending on your license, monitoring Microsoft SQL Server instances may not be
available. See the "List of Features" to determine if you have access to monitoring Microsoft SQL
Server instances. The "List of Features" is accessible from the Documentation Center (Help >
Documentation Center in Storage Essentials).
This chapter describes the following:
• ”Monitoring Microsoft SQL Server Overview” on page 35
• ”Viewing Events for SQL Server” on page 35
• ”Viewing Properties” on page 36
• ”Viewing Topology for a SQL Server” on page 38
Monitoring Microsoft SQL Server Overview
Before you can monitor Microsoft SQL Server you must:
• Have the license for monitoring Microsoft SQL Server. To determine if your license supports the
monitoring of Microsoft SQL Server, see the "List of Features" The List of Features is accessible
from the Documentation Center (Help > Documentation Center in Storage Essentials).
• Provide the database server name and port number.*
• Discover the application.*
*Refer to the Installation Guide for more information.
Key Benefits
• Improved Microsoft SQL Server database performance
• Increased Microsoft SQL Server availability and reliability
• Maximized return on Microsoft SQL Server storage assets
Key Features
• Database to disk topology view
• Standards-based (CIM/WBEM/SMI-S) management platform
• Database to disk monitoring
• Real time monitoring of Microsoft SQL Server storage
• Web-based global management console
• Ease of install, deployment and manageability
Viewing Events for SQL Server
You can view events pertaining to a SQL Server database and its dependent elements, such as
storage systems by doing the following: