Home » HP Manuals » Storage Devices » HP AiO400r » Manual Viewer

HP AiO400r HP StorageWorks All-in-One Storage System User Guide (440583-005, F - Page 100

Table 29 Operating status: SQL Server properties

Add to My Manuals
Save this manual to your list of manuals

Page 100 highlights

• 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 29 Operating status: SQL Server properties Status indicator Value OK Warning Critical SQL Server is running and storage is online. No alerts. See the Alerts list for more information. See Table 45 on page 113 for alert descriptions. See the Alerts list for more information. See Table 45 on page 113 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 30 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 Table 19 on page 72 for more information. Application Server Volume - RAID The RAID level to which the database component storage is configured. Level See Customizing RAID levels on page 73 for more information. Application Server Volume - RAID The RAID stripe size to which the database component's storage is Stripe Size configured. See Table 19 on page 72 for more information. Application Server Volume - Read Speeds up reads when enabled. This setting is determined by the storage Cache array, not ASM. Application Server Volume - Write Speeds up writes when enabled. This setting is determined by the storage Cache array, not ASM. Application Server Volume Number of Hot Spares The number of hot spares with which the database component storage is configured. See Table 19 on page 72 for more information. 100 Monitoring storage

Section	Page
All-in-One Storage System	1
Table of Contents	3
About this guide	15
Intended audience	15
Related documentation	15
Document conventions and symbols	15
Rack stability	16
HP technical support	17
Customer self repair	17
Product warranties	17
Subscription service	17
HP websites	18
Documentation feedback	18
1 Installing and configuring the server	19
Setup overview	19
Planning for installation	19
Planning a network configuration	20
Configuration checklist	20
Installing the server	21
Locating and writing down the serial number	21
Checking kit contents	21
Powering on the server	22
Factory image	22
Physical configuration	22
Default boot sequence	23
Accessing the All-in-One Management Console	23
Using the direct attach method	23
Using the remote browser method	24
Using the Remote Desktop method	26
Logging off and disconnecting	27
Telnet Server	27
Enabling Telnet Server	27
Sessions information	27
Using remote management methods	28
Using the Lights-Out 100 method	28
Using the Integrated Lights-Out 2 method	29
Configuring the server on the network	30
Before you begin	30
Running the Rapid Startup Wizard	32
Completing system configuration	32
Installing the All-in-One Storage Manager Agent	33
Installing the All-in-One Storage Manager Agent on network application servers	33
2 Storage system components	35
HP StorageWorks 400r All-in-One Storage System	35
HP StorageWorks 400t All-in-One Storage System	37
HP StorageWorks 600 All-in-One Storage System	40
SAS and SATA hard drive LEDs	43
3 Storage management overview	45
Storage management elements	45
Storage process management example	45
Physical storage elements	46
Arrays	47
Fault tolerance	48
Online Spares	48
Logical storage elements	48
Logical drives (LUNs)	48
Partitions	49
Volumes	49
File system elements	50
File sharing elements	50
Volume Shadow Copy Service overview	50
Using storage elements	51
Network adapter teaming	51
Management tools	51
HP Systems Insight Manager	51
Management Agents	51
All-in-One Storage Manager	52
Software requirements	52
Software support	52
Storage management infrastructure	53
Managing storage for application servers	53
Managing storage for shared folders	54
About the user interface	56
Menu bar	56
Toolbar	56
Navigation pane	56
Content pane	56
Actions pane	57
Defining user interface options	58
Add an All-in-One Storage System	59
Remove an All-in-One Storage System	59
4 Hosting storage for applications and shared folders	61
Using the Host an Exchange Storage Group Wizard	62
Entering a name of a server that hosts Exchange	62
Selecting Exchange storage group components	63
Local Continuous Replication (LCR)	63
Using the Create a Shared Folder Wizard	64
Naming a shared folder	64
Setting permissions for a shared folder	64
Using the Host a SQL Server Database Wizard	65
Selecting a server that hosts SQL Server	65
Selecting SQL Server database components	65
Selecting a database workload type	66
Using the Host a User-Defined Application Wizard	67
Choose type of application	68
Entering an application name	68
Using the Create a Virtual Library Wizard	68
Accessing the Virtual Library Wizard	68
Configure your virtual library	68
Allocating space for components	69
Selecting advanced configuration settings	71
Selecting data protection	76
Reviewing task summary and scheduling tasks	78
Monitoring task completion status	79
Cancelling tasks	79
Migrating user-defined application data from a remote application	80
5 Data protection	81
Data Protection Window	81
Selecting local or alternate backup	81
Managing snapshots and backups	82
Snapshots	82
Scheduling snapshots	82
Taking snapshots	82
Exposing a snapshot	83
Unexposing a snapshot	83
Reverting data to snapshots	83
Scheduling and running backups	84
Managing backups	84
Restoring data from backups	84
Selecting the restore destination	85
Launching DPX	85
Using DPX to restore data	85
Setting the password for the ASMbackup user account	85
To specify a password	86
Using the Administrators' account to change the ASMbackup password	86
Installing Data Protector Express on other devices	86
6 Managing storage	89
Increasing or reducing the allocated storage	89
Changing the percent full warning threshold	90
Removing application areas from view	91
Changing permissions, names, descriptions, or paths of shared folders	91
Deleting shared folders	92
7 Monitoring storage	93
Application View	93
Accessing application and shared folder properties	94
Data Protection	103
Storage View	105
Accessing storage area properties	106
Application Server View	108
Accessing application server properties	108
Storage Utilization View	110
8 Troubleshooting, servicing, and maintenance	111
Troubleshooting the storage system	111
Operating system problems and resolutions	111
Application software problems	112
SQL Server errors	112
ASM alerts	112
Recovering from logical disk failure	117
Maintenance updates	117
System updates	117
Troubleshooting resources	117
HP web site	117
Storage system documentation	118
Subscriber's Choice	118
White papers	118
Firmware updates	118
WEBES (Web Based Enterprise Services)	118
Certificate of Authenticity	119
9 System recovery	121
The System Recovery DVD	121
To restore a factory image	121
Systems with a DON'T ERASE partition	121
Managing disks after a restoration	121
A File server management	123
New or improved file services features in Windows Storage Server 2003 R2	123
Storage Manager for SANs	123
Single Instance Storage	123
Search enhancements	124
File Server Resource Manager	124
Windows SharePoint Services	124
HP All-in-One Management Console	124
File services management	125
Configurable and pre-configured storage	125
Storage management utilities	126
Array management utilities	126
Array Configuration Utility	126
Disk Management utility	127
Guidelines for managing disks and volumes	127
When managing disks and volumes:	127
Scheduling defragmentation	128
Disk quotas	128
Adding storage	129
Expanding storage	129
Extending storage using Windows Storage Utilities	130
Extend volumes using Disk Management	130
Expanding storage using the Array Configuration Utility	130
Expand logical drive	130
Volume shadow copies	131
Shadow copy planning	131
Identifying the volume	131
Allocating disk space	132
Identifying the storage area	133
Determining creation frequency	133
Shadow copies and drive defragmentation	133
Mounted drives	134
Managing shadow copies	134
The shadow copy cache file	134
Enabling and creating shadow copies	136
Viewing a list of shadow copies	136
Set schedules	136
Viewing shadow copy properties	137
Redirecting shadow copies to an alternate volume	137
Disabling shadow copies	138
Managing shadow copies from the storage system desktop	138
Shadow Copies for Shared Folders	139
SMB shadow copies	140
NFS shadow copies	141
Recovery of files or folders	141
Recovering a deleted file or folder	141
Recovering an overwritten or corrupted file	142
Recovering a folder	142
Backup and shadow copies	143
Shadow Copy Transport	143
Folder and share management	144
Folder management	144
Share management	150
Share considerations	150
Defining Access Control Lists	151
Integrating local file system security into Windows domain environments	151
Comparing administrative (hidden) and standard shares	151
Managing shares	152
File Server Resource Manager	152
Quota management	152
File screening management	152
Storage reports	153
Other Windows disk and data management tools	153
Additional information and references for file services	153
Backup	153
HP StorageWorks Library and Tape Tools	153
Antivirus	153
Security	154
More information	154
B Print services	155
Microsoft Print Management Console	155
New or improved HP print server features	155
HP Web Jetadmin	155
HP Install Network Printer Wizard	155
HP Download Manager for Jetdirect Print Devices	155
Microsoft Print Migrator Utility	155
Network printer drivers	156
Print services management	156
Microsoft Print Management Console	156
HP Web Jetadmin installation	156
Web-based printer management and Internet printing	156
Planning considerations for print services	157
Print queue creation	157
Sustaining print administration tasks	158
Driver updates	158
Print drivers	158
User-mode vs. kernel-mode drivers	158
Kernel-mode driver installation blocked by default	158
HP Jetdirect firmware	158
Printer server scalability and sizing	159
Backup	159
Best practices	159
Troubleshooting	160
Additional references for print services	160
C Microsoft Services for Network File System (MSNFS)	161
MSNFS Features	161
UNIX Identity Management	161
MSNFS use scenarios	162
MSNFS components	162
Administering MSNFS	163
Server for NFS	163
Server for NFS Authentication DLL vs. Service for User for Active Directory domain controllers	163
Installing NFS Authentication DLL on domain controllers	164
Elevate S4U2 functionality on Windows Server 2003 domain controllers	165
Server for NFS administration	165
Accessing NFS resources for Windows users and groups	166
Managing access using the .maphosts file	166
Allowing anonymous access to resources by NFS clients	166
Best practices for running Server for NFS	167
User Name Mapping	168
User Name Mapping Administration	169
Best practices for User Name Mapping	169
Microsoft Services for NFS troubleshooting	169
Microsoft Services for NFS command-line tools	169
Optimizing Server for NFS performance	170
Print services for UNIX	170
Point and print from UNIX to Windows Server 2003	171
Additional resources	171
D Other network file and print services	173
File and Print Services for NetWare (FPNW)	173
Installing Services for NetWare	173
Managing File and Print Services for NetWare	174
Creating and managing NetWare users	175
Adding local NetWare users	176
Enabling local NetWare user accounts	176
Managing NCP volumes (shares)	177
Creating a new NCP share	178
Modifying NCP share properties	178
Print Services for NetWare	178
Point and Print from Novell to Windows Server 2003	178
Additional resources	179
AppleTalk and file services for Macintosh	179
Installing the AppleTalk protocol	179
Installing File Services for Macintosh	179
Completing setup of AppleTalk protocol and shares	179
Print services for Macintosh	180
Installing Print Services for Macintosh	180
Point and Print from Macintosh to Windows Server 2003	180
E Configuring storage system for Web access (optional)	181
Setting up an Internet connection	181
F Regulatory compliance and safety	183
Federal Communications Commission notice	183
Class A equipment	183
Class B equipment	183
Declaration of conformity for products marked with the FCC logo, United States only	184
Modifications	184
Cables	184
Laser compliance	184
International notices and statements	185
Canadian notice (Avis Canadien)	185
Class A equipment	185
Class B equipment	185
European Union notice	185
BSMI notice	186
Japanese notice	186
Korean notice A&B	186
Class A equipment	186
Class B equipment	186
Safety	187
Battery replacement notice	187
Taiwan battery recycling notice	187
Power cords	187
Japanese power cord notice	188
Electrostatic discharge	188
Preventing electrostatic discharge	188
Grounding methods	188
Waste Electrical and Electronic Equipment (WEEE) directive	188
Czechoslovakian notice	188
Danish notice	189
Dutch notice	189
English notice	189
Estonian notice	190
Finnish notice	190
French notice	190
German notice	190
Greek notice	191
Hungarian notice	191
Italian notice	191
Latvian notice	191
Lithuanian notice	192
Polish notice	192
Portuguese notice	192
Slovakian notice	193
Slovenian notice	193
Spanish notice	193
Swedish notice	193
Glossary	195

Match case Limit results 1 per page

•

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 29 Operating status: SQL Server properties

Value

Status indicator

SQL Server is running and storage is online. No alerts.

See the Alerts list for more information. See

Table 45

on page 113 for alert

descriptions.

Warning

See the Alerts list for more information. See

Table 45

on page 113 for 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 30 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

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

Table 19

on page 72 for more information.

Application Server Volume -

Exclusive Storage

The RAID level to which the database component storage is configured.

See

Customizing RAID levels

on page 73 for more information.

Application Server Volume - RAID

Level

The RAID stripe size to which the database component's storage is

configured. See

Table 19

on page 72 for more information.

Application Server Volume - RAID

Stripe Size

Speeds up reads when enabled. This setting is determined by the storage

array, not ASM.

Application Server Volume - Read

Cache

Speeds up writes when enabled. This setting is determined by the storage

array, not ASM.

Application Server Volume - Write

Cache

The number of hot spares with which the database component storage is

configured. See

Table 19

on page 72 for more information.

Application Server Volume -

Number of Hot Spares

Monitoring storage

100