Access "What's the best network storage for databases?"
This article is part of the Vol. 1 No. 6 August 2002 issue of .NET server storage: Friendly or not?
A company is only as strong as the data in its databases. And the care, feeding and protection of the company's databases are mission-critical IT services. Question: What's the best way to design network storage for databases? Don't answer too quickly. It's one of those sneaky SAT questions: The most obvious answer is usually wrong. Mapping tablespaces Tablespaces can be mapped directly to LUNs using either raw partition or file system storage. And that brings us to the old network-attached storage (NAS) vs. storage area network (SAN) debate for databases. While many people assume that database storage equates with SANs, it's also possible, and may be advantageous to use NAS for database storage (not including transaction processing databases). The fact that NAS systems provide a ready file system interface with integrated management tools can make them very appealing for database storage. Raw partitions vs. file system As database and storage administrators well know, databases can provide their own filing system - called raw partitions - or use the filing ... Access >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
Your worst nightmares ... and how to avoid them
by Jon William Toigo
It's 10 p.m. Do you know where your data is?
- Centralized Storage No Fad
-
InfiniBand Marches on Despite Intel Retreat
Intel has put the brakes on some of its InfiniBand activities.
-
Are You a SAN Guru?
Take these sample exam questions to see if you could pass SNIA's FC certification programs.
- IFCP and FCIP by Marc Farley
-
Where hard drives are headed
by Eric Knorr
Bigger used to be better, but get ready for smaller, faster.
-
Taxonomy of Storage Management Software Providers
There's no lack of vendors who will sell you tools to help you regain control of your storage resources.
-
Will .NET server make Windows storage friendly?
by David Braue
Here's how the next version of Windows will change storage managers' lives.
-
Storage managers plan more SANs
by Mark Schlack and Karen Bannan
Our extensive survey of 2003 spending plans documents continuing networked storage growth and selective adoption of new technology.
- Will disk replace tape?
-
Your worst nightmares ... and how to avoid them
by Jon William Toigo
-
-
Tape Spins Right Round
Tape vendors continue to put out products at dizzying speeds.
-
Solid State Disk: Coming Soon to a SAN Near You
It's commonplace to find disk subsystems and tape drives on the SAN, but that's not always the case for solid state disk (SSD).
-
USB Drives Make Small Work of Large File Transfers
The market has seen a flood of small plug-and-play USB storage devices that have ample capacity.
-
What's the best network storage for databases?
by Marc Farley
Conventional wisdom says SANs, but that depends what you're doing with your database.
-
With SANs, Street Price Bears Little Resemblance to List
If you're not getting deep discounts on your storage networking equipment, you need to hone your bargaining skills.
-
Windows backup: avoid the landmines
by W. Curtis Preston
Backing up in Windows may be tricky, but there are shortcuts.
-
Managing a SAN the old-fashioned way
by Benjamin Kuo
With automation largely a fantasy, you'll need to know how to do it the hard way.
-
ASK THE EXPERT:
by Randy Kerns
Why doesn't my mail client software create a lock for e-mail files if it's reading it off a NAS device? Which non-EMC NAS devices provide a gateway to connect to an EMC Symmetrix SAN?
-
The price of independence
by David Braue
As storage has become more strategic, so has the need for focused professionals. Here's how some companies are working that out.
-
Tape Spins Right Round
-
Columns
-
Introducing new data storage technologies
by Stephen Foskett
Introducing new technology to your department isn't as easy as it sounds.
-
Snapshot: Using multiple storage array vendors
How many array vendors are in your shop?
-
Where in the world is iSCSI?
Storage Bin: Where in the world is iSCSI?
-
Avoiding failure in the SAN is easy, back your switch up
by Darryl Brooks
Avoiding failure in the SAN is easy - back your switch up.
-
Introducing new data storage technologies
by Stephen Foskett
More Premium Content Accessible For Free
Improve data storage efficiency with archiving technology
E-Zine
Data archiving technology moves inactive data from primary storage to more suitable media. It may be used for compliance, governance or storage ...
How to improve your virtual server storage setups
E-Zine
One of the biggest challenges of building a virtual server infrastructure is fine-tuning the storage that supports the virtual machines. Having ...
Rethinking the way storage architectures are packaged and presented
E-Zine
Cloud storage, virtualization and the growth of unstructured data have contributed to the way storage architectures are built and used. Virtual ...
Storage Management Strategies for the CIO