Tip

Can a database get too big for its SAN?

Can a database get too big for your SAN?

Not according to Marc Staimer, president of Dragon Slayer Consulting. "There is no way in hell a database can saturate a SAN in any way, shape, or form," he declares.

Staimer notes that while databases can demand a large volume of data, the latency is small and databases are usually spread across multiple platters so seek time can be minimized. Furthermore, database administrators can deploy additional tricks of the trade to improve performance -- implementing hot files, for example. For those who think they have a database performance problem, he advises an investment in caching and lots of solid state memory. Similarly, says Staimer, NAS setups have no problems with most databases. However, he adds, Oracle may be an important exception "because it has about 300 commands when it writes to block storage," which adds a lot of processing overhead.

Nancy Hurley, an analyst with Enterprise Storage Group, takes a similarly upbeat view of networked storage and databases. She says the only time a database would present a real performance challenge is if it has been allowed to grow out of control. In this scenario, increased search time could bog down the I/O. Those facing performance problems from that source could consider solutions such as those available from Princeton Softech (their Active Archive Solutions enable companies to manage and store data, based on its business value using an information lifecycle management

Requires Free Membership to View

approach) and OuterBay Technologies, Inc., a provider of application data management (ADM) solutions that can allows users to move data between storage tiers based on its current value to the business.

Likewise, Hurley gives her endorsement to NAS for databases though she cautions that very low-end NAS might not be robust enough. The bottom line, she says, is to detemine what how long a latency your application can handle.

For more information:

Tip: Scale your SAN for tomorrow

Tip: Do some basic performance analysis

Tip: Using NAS for database storage


About the author: Alan Earls is a freelance writer in Franklin, Mass.

This was first published in June 2004

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:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.