Data file properties, Log file properties for database – HP StorageWorks All-in-One SB600c Storage Blade User Manual
Page 54
Property
Value
Application Server Volume - Read
Cache
Speeds up reads when enabled. This setting is determined by the
storage array, not ASM.
Application Server Volume -
Write Cache
Speeds up writes when enabled. This setting is determined by the
storage array, not ASM.
Application Server Volume -
Number of Hot Spares
The number of hot spares with which the database component storage is
configured. See
on page 27 for more information.
Application Server Volume -
Mount Paths
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.
•
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 30 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
Value
Description
Data File Name
Name of database data file.
Filename
Relative path to where the database data file is stored on the server
that hosts SQL Server.
File Group
File group of data file. This value is assigned by SQL Server.
Data File Space Available
Free storage space available for data file.
•
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
Value
Description
Log Name
Name of database log file.
File Name
Relative path to where the database log file is stored on the server
that hosts SQL Server.
•
Data Protection tab—(SQL server database, SQL server database component) Allows you to
schedule backups or run a backup of the database that owns the database component, or restore
the database that owns the database component from a backup. It also allows you to schedule
snapshots or take a snapshot of the database that owns the database component, expose a
snapshot, or revert the database that owns the database component to a past snapshot. See
” on page 37 for more information.
Accessing properties for the user-defined applications
ASM provides properties information for the user-defined applications on your HP All-in-One 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 Filters drop-down menu, select User-Defined or All.
3.
To select properties for the user-defined application pool:
54
Monitoring storage