HP X1800sb G2 Network Storage Blade - Manual (Page 43)

Table 17 Storage tab: SQL Server database component properties (continued)
Value Property
The RAID level to which the database component storage is configured. See
“Customizing RAID levels” (page 20) for more information.
Application Server Volume - RAID
Level
The RAID stripe size to which the database component's storage is configured.
See
“Advanced Storage Properties items” (page 19) 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
“Advanced Storage Properties items” (page 19) 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” (page 21) 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
Description Value
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
•
Log tab—Displays the log file's free space and the following storage allocation details about
the SQL Server log file.
Table 19 Log tab: SQL Server database component properties
Description Value
Name of database log file. Log Name
Relative path to where the database log file is stored on the server that hosts
SQL Server. File Name
Accessing properties for user-defined applications
ASM provides properties information for the user-defined applications on your HP Storage System.
Using properties information, you can determine the status of all user-defined application areas
monitored by ASM, and any warning or critical status indicators.
1. In the Actions pane, select Application View.
2. From the Filter drop-down menu, select User-Defined or Show all.
Application View 43