Saturday, September 13, 2008

SAN usage guidelines for ETL

You can have multiple copies of the same database on different servers at same time. This will allow you to do “mix and match” configurations by having EMC re-map volumes from one server to another. It may sound like a rare luxury to have that amount of storage available. Here are some of the SAN experiences and guidelines:

Establish a usage pattern for your storage volumes that lets you and your SAN expert predict what will be needed.

Follow a naming convention that gives each volume a name indicating what it is for.

Volume names should be unique over all machines.

Mount the volumes on NTFS folders that follow the same naming convention.

Keep in communication with your SAN expert about the usage patterns for your storage.

No comments: