Ask the Expert

Asking the toughest question for SAN/NAS

Hello Randy,

When does one consider moving a database to a SAN/NAS environment? Are there any "best practices" for how large the database should be where a SAN/NAS would be most suitable? What would the recommended size be for a SQL/Oracle database if it were moved into a SAN/NAS?

Requires Free Membership to View

You've asked the toughest question for NAS. You need to know what your performance requirements are first. In general, the rule of thumb has been if you have a performance requirement for your online transaction processing (OLTP) application you don't use NAS because of the overhead in the TCP/IP implementation and with the variables in Ethernet networking. Improvements have been made with DAFS (direct access file system) that provides outstanding performance and with TCP/IP accelerators.

Both these require different NICs (network interface controllers) and driver software. Size does have something to do with it but I think you may not even get to the size question if you make the decision about basic performance. SAN should be no different in the decision making for direct attached storage regarding performance and size.

Randy Kerns
Evaluator Group, Inc.

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.

This was first published in July 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: