We have an application that is experiencing I/O contention,
particularly in tempdb but also in two other databases. The data is
stored on mirrored PowerVault 220's, each with 10 of 14 possible disks.
The PowerVaults are JBOD devices, not true SANs. The current config has
four separate groups of physical drives assigned to distinct logical
drives for log files, tempdb, and the two app dbs. This means, for
example, that tempdb resides on one mirrored drive. The standard advice
when faced with disk contention is to add spindles if possible. With 4
empty slots, we would presumably assign the new physical disks to the
most stressed db, e.g. tempdb.
An alternative arrangement would be to combine all the physical drives
into one logical drive, and put all the files, log and data, onto the
single logical drive. The hope for this configuration is that the
PowerVault would automagically distribute the data among the drives
such that all drives were in use, all spindles reading and writing at
maximum capacity when necessary. It is my understanding that
full-featured SANs, like NetApps and EMC models, do this. My question
is whether this configuration is best for the PowerVault, as well. Or
is this the essential difference between JBOD and a true SAN?
Has anyone tried both arrangements?
Advice is much appreciated. 2 3192
Hi
I can't say I know anything about the internals of JBOD.. but I would expect
combining the drives into a single logical drive to not be benificial even
though they are distributing the data over more spindles the type of access
between log file and data files will probably be counter productive.
If you are having contention on tempdb you may want to consider splitting
tempdb into multiple files (preferrably on separate sets of spindles) as
described in http://support.microsoft.com/default...b;en-us;328551
John
"JRoughgarden" <jr**********@stanfordalumni.org> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com... We have an application that is experiencing I/O contention, particularly in tempdb but also in two other databases. The data is stored on mirrored PowerVault 220's, each with 10 of 14 possible disks. The PowerVaults are JBOD devices, not true SANs. The current config has four separate groups of physical drives assigned to distinct logical drives for log files, tempdb, and the two app dbs. This means, for example, that tempdb resides on one mirrored drive. The standard advice when faced with disk contention is to add spindles if possible. With 4 empty slots, we would presumably assign the new physical disks to the most stressed db, e.g. tempdb.
An alternative arrangement would be to combine all the physical drives into one logical drive, and put all the files, log and data, onto the single logical drive. The hope for this configuration is that the PowerVault would automagically distribute the data among the drives such that all drives were in use, all spindles reading and writing at maximum capacity when necessary. It is my understanding that full-featured SANs, like NetApps and EMC models, do this. My question is whether this configuration is best for the PowerVault, as well. Or is this the essential difference between JBOD and a true SAN?
Has anyone tried both arrangements?
Advice is much appreciated.
Yes, we have split tempdb in accordance with this article. No obvious
improvement yet. Looking at the -T1118 flag in a replicated
environment.
I am gathering that a JBOD is just a holder for physical disks that is
capable of splitting them up into logical disks, with or without RAID.
No real optimization.
Still, it would be an interesting experiment to put everything on one
logical disk comprising 14-physical disks vs. splitting the 14 into
separate logical drives for log files, tempdb mdf, and app data file
mdfs. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: ajjvn |
last post by:
I 'inherited' a group of SQL Server server class machines. They are
true server technology but the disk sub-systems are lacking. There is
one hot-swap backplane that all the drives share (with...
|
by: Rob |
last post by:
Hello,
I've a couple of questions on setting up my lovely new server... I've
decided on R1 (2*36GB) for the OS, R1 (2*73GB) primarily for the Log
Files and R5 (5*73GB) for the Data files.
I was...
|
by: pfemat |
last post by:
Hi there,
i am doing some heavy computations whose result i want to save
to harddisk. the results are in an long array named screen
and i thought of doing
char *tmp =...
|
by: Shane Wright |
last post by:
Hi,
I've been trying to spec a new server for my company's database for a
few weeks and one of the biggest problems I've had is trying to find
meaningful performance information about how...
|
by: jwgoerlich |
last post by:
What is the fastest way of writing a Byte array to disk? I have a 512
MB array in memory. I am writing to a 10K RPM drive, and have ample CPU
and RAM. I need to write as much data as possible, as...
|
by: Tom |
last post by:
I'd greatly appreciate advice and code snippets on how to create a ram
disk within a C/C++ program.
I also need to be able to determine the free space.
Thanks in advance for any help.
|
by: Nishant Saini |
last post by:
Dear All,
We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having...
|
by: atlaste |
last post by:
Hi,
I'm currently developing an application that uses a lot of
computational power, disk access and memory caching (to be more exact:
an information retrieval platform). In these kind of...
|
by: George2 |
last post by:
Hello everyone,
I have several physical file and I want to use file map
(MapViewOfFileEx) to map the file into memory to improve performance.
Each file is about several hundred M bytes. All...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |