Selecting a database workload type, Using the host a user-defined application wizard, Using the host a user-defined application – HP StorageWorks All-in-One SB600c Storage Blade User Manual
Page 24: Wizard, Using, The host a user-defined application
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
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
Using the Host a User-Defined Application Wizard
The wizard helps you set up your All-in-One Storage System to store application data for various
applications. Storage will be 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 the All-in-One
Storage manager.
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
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
•
Verify the remote application has the following characteristics:
• Runs under Windows Server 2003
• Uses NTFS volumes for storage
•
Make sure the ASM agent is installed on each application server with data you plan to host. See
the HP StorageWorks All-in-One Storage System quick start instructions for more information.
•
Make sure you have an up-to-date backup of your remote application data and logs.
•
For an iSCSI LUN application, you will need the iSCSI qualified name.
NOTE:
For a remote windows application, you need to know the path to the iSCSI LUN on the application
server to configure the remote application to store data on the iSCSI LUN. The path to the iSCSI LUN is
displayed on the application’s Properties window on the Storage tab.
24
Hosting storage for applications and shared folders