HP StorageWorks All-in-One Storage System user guide (440583-005, February 2008)

• General tab—(SQL Server, SQL Server database, SQL Server database component) Displays the
name of the application, the total capacity reserved for the application, and its operating status:
Table 29 Operating status: SQL Server properties
ValueStatus indicator
SQL Server is running and storage is online. No alerts.OK
See the Alerts list for more information. See Table 45 on page 113 for alert
descriptions.
Warning
See the Alerts list for more information. See Table 45 on page 113 for alert
descriptions.
Critical
• Storage tab—(SQL Server database component) Displays the database component's storage
space, including allocated space, used space, free space, and the following storage allocation
details:
Table 30 Storage tab: SQL Server database component properties
ValueProperty
Path to the file directory on the server that hosts SQL Server where the
database component's data is saved by SQL Server. The file directory is
located on the volume created on the iSCSI LUN exported by ASM to the
server that hosts SQL Server.
Application Path
Communication protocol used to transfer data between the server that
hosts SQL Server (and the database component) and your HP All-in-One
Storage System.
Protocol
Name of server that hosts SQL Server and the database component.Application Server Host Name
Name of the volume on the server that hosts SQL Server to which SQL
Server saves the database component's data. The volume resides on the
iSCSI LUN (logical disk) exported by ASM to the server that hosts SQL
Server.
Application Server Volume - Name
Status of the volume on the server that hosts SQL Server where the
database component is stored.
Application Server Volume - Status
Indicates if database component storage is configured with exclusive
storage. See Table 19 on page 72 for more information.
Application Server Volume -
Exclusive Storage
The RAID level to which the database component storage is configured.
See Customizing RAID levels on page 73 for more information.
Application Server Volume - RAID
Level
The RAID stripe size to which the database component's storage is
configured. See Table 19 on page 72 for more information.
Application Server Volume - RAID
Stripe Size
Speeds up reads when enabled. This setting is determined by the storage
array, not ASM.
Application Server Volume - Read
Cache
Speeds up writes when enabled. This setting is determined by the storage
array, not ASM.
Application Server Volume - Write
Cache
The number of hot spares with which the database component storage is
configured. See Table 19 on page 72 for more information.
Application Server Volume -
Number of Hot Spares
Monitoring storage100