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

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 15 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. Warning
See the Alerts list for more information. Critical
•
Details tab — (SQL Server database) — (SQL Server database) Displays the following SQL
Server values:
Table 16 Details tab: SQL Server database properties
Value Property
Name of server where SQL Server storage is being hosted. SQL Server
Operational status of the SQL Server. SQL server status
Version of SQL Server. Version
Operational status of the SQL Server database. Database status
Workload type of the SQL Server database. Workload type
Indicates whether the server that hosts SQL Server is part of a cluster. Clustered
•
Snapshots tab — (SQL Server database) Allows you to schedule snapshots of the database.
For more information, see
“Scheduling and running snapshots” (page 27) .
•
Backup tab — (SQL Server database) Allows you to schedule backups of the database. See
“Scheduling backups” (page 29) for more information.
•
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 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
Status of the volume on the server that hosts SQL Server where the database
component is stored. Application Server Volume - Status
Indicates if database component storage is configured with exclusive storage.
See
“Advanced Storage Properties items” (page 19) for more information.
Application Server Volume - Exclusive
Storage
42 Monitoring storage