beautypg.com

Log tab: sql server database component properties, Data file properties, Log file properties for database – HP StoreEasy 1000 Storage User Manual

Page 55

background image

Value

Property

Status of the volume on the server that hosts SQL Server where the data-
base component is stored.

Application Server Volume - Status

Indicates if database component storage is configured with exclusive
storage. See

Table 5

on page 25 for more information.

Application Server Volume - Exclus-
ive Storage

The RAID level to which the database component storage is configured.
See

Customizing RAID levels

on page 27 for more information.

Application Server Volume - RAID
Level

The RAID stripe size to which the database component's storage is con-
figured. See

Table 5

on page 25 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 25 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 28 for more information.

Data File or Log tab— (SQL Server database component) One of these two tabs is available de-
pending 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

HP StorageWorks Automated Storage Manager User Guide

55

This manual is related to the following products: