Operating status— sql server properties – HP StorageWorks All-in-One SB600c Storage Blade User Manual
Page 53
Accessing properties for SQL Server
ASM provides properties information for SQL Server when SQL Server storage is hosted on your HP
All-in-One Storage System.
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
Value
Status indicator
SQL Server is running and storage is online. No alerts.
OK
See the Alerts list for more information. See “
alert descriptions.
Warning
See the Alerts list for more information. See “
alert descriptions.
Critical
•
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
Value
Property
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.
Application Path
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.
Protocol
Name of server that hosts SQL Server and the database component.
Application Server Host 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 - Name
All-in-One Storage Manager
53