HP StorageWorks All-in-One SB600c Storage Blade - Manual (Page 24)

2. To view the properties for a database component, select the database component name and
then click Properties.
See “ Data file properties ” on page 54 and “ Log file properties for database ” on page 54 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 All-in-One Storage System,
clear the Delete original files after checkbox.
4. When you are done, click Next to open the Select the Database Workload Type page (see
Selecting a database workload type ).
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 25).
Using the Host a User-Defined Application Wizard
The Host a User-Defined Application Wizard helps you allocate and configure storage space for a
remote application on your HP All-in-One Storage System. As part of this process, ASM exports an
iSCSI LUN to the application server whose storage will be hosted. ASM also creates a LUN (logical
disk) on your HP All-in-One Storage System to host the application storage. All storage communication
passes through the iSCSI LUN on the application server to the LUN on your HP All-in-One Storage
System. This allows data saved by the application to the iSCSI LUN on the application server to be
automatically saved to your HP All-in-One Storage System instead.
After storage is allocated and configured on your HP All-in-One Storage System 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 All-in-One Storage System. See
“
Migrating user-defined application data to your HP All-in-One Storage System ” on page 35 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.
Hosting storage for applications and shared folders 24