HP StorageWorks All-in-One Storage Manager user guide (452695-004, November 2008)

ValueProperty
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 5 on page 23 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 24 for more information.
Application Server Volume - RAID
Level
The RAID stripe size to which the database component's storage is
configured. See Table 5 on page 23 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 5 on page 23 for more information.
Application Server Volume -
Number of Hot Spares
Path the volume is mounted on, on the server that hosts SQL Server. The
volume is built on the iSCSI LUN exported by ASM to the server that hosts
SQL Server.
Application Server Volume - Mount
Paths
• Warning Threshold tab—(SQL Server database component) Allows you to change the percent full
warning threshold value for the database component. See Setting a percent full warning
threshold on page 26 for more information.
• Data File or Log tab— (SQL Server database component) One of these two tabs is available
depending on whether the database component is a data file or log.
• Data File tab—Displays the data file's free space and the following storage allocation details about
the SQL Server data file:
Table 18 Data File tab: SQL Server database component properties
DescriptionValue
Name of database data file.Data File Name
Relative path to where the database data file is stored on the server
that hosts SQL Server.
Filename
File group of data file. This value is assigned by SQL Server.File Group
Free storage space available for data file.Data File Space Available
All-in-One Storage Manager 55