Operating status: sql server properties, Details tab: sql server database properties – HP StorageWorks 1200r All-in-One Storage System User Manual
Page 108
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 31 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 32 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
•
Backup tab — (SQL Server database) Allows you to schedule backups of the database. See
“
” on page 90 for more information.
•
Replication tab — (SQL Server database) Allows you to configure data replication of the database.
See “
” on page 93 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 33 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
Monitoring storage
108