HP StorageWorks All-in-One Storage Manager user guide (452695-004, November 2008)

2. To view the properties for a database component, select the database component name and
then click Properties.
See “Data file properties” on page 55 and “Log file properties for database” on page 56 for
descriptions of the properties displayed.
3. If you do not want ASM to delete the original files for the selected database components from
the server that hosts SQL Server after it migrates the data to your HP Storage Server, clear the
Delete original files after successful migration checkbox.
4. When you are done, click Next to open the Select the Database Workload Type page (see
“Selecting a database workload type” on page 19).
Selecting a database workload type
Use the Select the Database Workload Type page to select the workload type for the SQL Server
database.
NOTE:
You can only select the database workload type while using the Host a SQL Server Database Wizard. The
database workload type cannot be changed later.
1. Do one of the following:
• Select Transaction processing (TP) for frequently updated, fast growing databases with large
volumes of data requiring concurrent user access.
• Select Decision support systems (DSS) for databases designed to handle queries on large
amounts of data, typically used for data-mining applications.
2. When you are done, click Next to open the Storage Allocation page (see
“Allocating space for components” on page 21).
Using the Host a User-Defined Application Wizard
This wizard helps you set up your HP Storage Server to store application data for various applications.
Storage is allocated for the application, optionally exposed to another server using the iSCSI protocol,
and an NTFS file volume may be optionally created on the remote application server. Upon completion,
you can monitor and manage storage for the application through the All-in-One Storage Manager.
After storage is allocated and configured on your HP Storage Server for a remote application using
the Host a User-Defined Application Wizard, do the following:
• Manually migrate the remote application's data to your HP Storage Server. See
“Migrating user-defined application data from a remote application” on page 31 for more
information.
• Configure the remote application to store its data on the iSCSI LUN exported by ASM to the
application server as described in the application's documentation.
Before you begin configuring storage for a user-defined application
• Make sure the ASM agent is installed on each application server with data you plan to host.
• Make sure you have a current backup of your remote application data and logs.
• For an iSCSI LUN application, you will need the iSCSI qualified name.
All-in-One Storage Manager 19