16 operating status— sql server properties, Properties window – HP StorageWorks All-in-One SB600c Storage Blade User Manual
Page 53
1.
In the Actions pane, select Application View.
2.
From the Filters drop-down menu, select SQL Server or All.
3.
Do one of the following:
• Select one of the following:SQL Server, SQL Server database or a SQL Server database
component in the content pane and then click Properties in the Actions pane.
• Right-click SQL Server, SQL Server database or a SQL Server database component in the
content pane and select Properties.
Properties window
ASM provides properties information for the SQL server, databases and database components when
SQL Server storage is hosted on your HP All-in-One Storage System. The following lists the tabs in the
properties window, and in parenthesis, which applications are applicable: SQL Server, SQL Server
databases or SQL Server database components.
•
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 16 Operating status— SQL Server properties
Status indicator
Value
OK
SQL Server is running and storage is online. No alerts.
Warning
See the Alerts list for more information. See
on page 68 for
alert descriptions.
Critical
See the Alerts list for more information. See
on page 68 for
alert descriptions.
•
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 17 Storage tab—SQL Server database component properties
Property
Value
Application Path
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.
Protocol
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.
Application Server Host Name
Name of server that hosts SQL Server and the database component.
Application Server Volume -
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 -
Status
Status of the volume on the server that hosts SQL Server where the
database component is stored.
Application Server Volume -
Exclusive Storage
Indicates if database component storage is configured with exclusive
storage. See
on page 27 for more information.
Application Server Volume - RAID
Level
The RAID level to which the database component storage is configured.
See
on page 28 for more information.
Application Server Volume - RAID
Stripe Size
The RAID stripe size to which the database component’s storage is
configured. See
on page 27 for more information.
All-in-One Storage Manager
53