beautypg.com

Operating status: sql server properties, Details tab: sql server database properties – HP StorageWorks 1200r All-in-One Storage System User Manual

Page 108

background image

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

” on page 87.

Backup tab — (SQL Server database) Allows you to schedule backups of the database. See

Scheduling backups

” on page 90 for more information.

Replication tab — (SQL Server database) Allows you to configure data replication of the database.
See “

Running replication

” 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