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

Monitoring Microsoft SQL Server36
1. Access Application Viewer by clicking Tools > Storage Essentials > Application Viewer.
2. Expand the node for the SQL Server database from which you want to obtain event
information.
3. Click Path Events.
The events for that SQL Server database and its dependent elements are displayed in the right
pane.
The management server provides the following information about the events:
• ID- The identification number assigned to the event
• Severity - Provides the severity level
• Time - The time the event was recorded.
• Summary Text - A brief explanation of the event. When you click the summary text, the details
of the event are displayed.
Refer to the Chapter "Managing Events" in the User Guide for more information.
Viewing Properties
This section describes the following:
• ”Properties of a SQL Server Instance” on page 36
• ”Properties of a SQL Server Database” on page 37
• ”Properties of a SQL Server Database File” on page 37
Properties of a SQL Server Instance
You can view the properties of a SQL Server instance on a host by doing the following:
1. Access Application Viewer by clicking Tools > Storage Essentials > Application Viewer.
2. Click the SQL Server instance in Application Viewer.
3. Click the Properties tab.
The following properties are displayed:
• Custom Name - To make it easier to identify the element instance in the system, assign the
instance a Custom Name. The Custom Name also appears in Chargeback. Since all users
query the same database, this name is displayed to others using the software. As a result,
you might want to make them aware of the name.
• Business Cost - The management server lets you assign a business cost to an application,
including virtual applications. This information is used in Event Manager for ranking events
from elements. Event Manager determines the rank of an event by taking into account the
business cost of the application and the severity of the event. You can sort events by rank in
Event Manager by clicking the Rank column.
• Vendor
• Contacted
• Record Created
• Discovery Status