HP Storage Essentials V5.00.01 application guide (T4283-96014, January 2006)

Storage Essentials 5.00.01 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 Sybase 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 36
• ”Viewing Properties” on page 37
• ”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 Sybase, 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
Properties of a Microsoft SQL Server Database File
You can view the properties of a Sybase database file by doing the following:
1. Access Application Viewer by clicking Tools > Storage Essentials > Application Viewer.