473,403 Members | 2,222 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Help with file placement please...

Hello All,

I am looking at the performance of our production database. It is
40gb, and growing reasonably fast. It is placed in one file group on a
RAID-5 array. The array is made up of 20 (or so) 9gb disks. The data,
the indexes and the transaction log are all on the "one logical disk".

My question then, is, would it be better to move the transaction log
onto a separate device (with Raid-1), and then separate out the
indexes and the data and to place them onto separate devices (ie.
split the raid disks into 2 new drives). Or would it be better to
place the table into a larger number of smaller filegroups effectively
split across the raid device and to (strategically) place different
tables into the new logical disks. Does this make sense?

Or, do I just leave everything as it is?

Cheers
Mike
Jul 20 '05 #1
1 1447

"Mike Hibbert" <mi**********@zurich.com> wrote in message
news:ea**************************@posting.google.c om...
Hello All,

I am looking at the performance of our production database. It is
40gb, and growing reasonably fast. It is placed in one file group on a
RAID-5 array. The array is made up of 20 (or so) 9gb disks. The data,
the indexes and the transaction log are all on the "one logical disk".

My question then, is, would it be better to move the transaction log
onto a separate device (with Raid-1), and then separate out the
indexes and the data and to place them onto separate devices (ie.
split the raid disks into 2 new drives). Or would it be better to
place the table into a larger number of smaller filegroups effectively
split across the raid device and to (strategically) place different
tables into the new logical disks. Does this make sense?
Move your logs to a separate device. That's the best single thing you can
do for peformance here.

As for a larger number of smaller filegroups, under SQL 2000 that won't gain
you much performance-wise.

Though there may be reasons to do so from a maintenance POV (dependin on
your needs.)

Or, do I just leave everything as it is?

Cheers
Mike

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: radha | last post by:
Hai all, My problem not just releated to sql. My problem is releated to good logic. I should not this type of questions hear. But just i am trying. If any body gave suggestions, or help i am...
3
by: Joey Martin | last post by:
Please, please help with me with this code. I thought I had it figured out, but no such luck. I have two tables, raceresultsview and jockeyselections. In jockeyselections, I have jockey names...
23
by: Giancarlo Niccolai | last post by:
Hello all. I have peeked through the FAQ and all relevant links, and also through Stroustrup book, but I have not been able to find an answer, so I have to post here as a last resort. It...
7
by: x muzuo | last post by:
Hi guys, I have got a prob of javascript form validation which just doesnt work with my ASP code. Can any one help me out please. Here is the code: {////<<head> <title>IIBO Submit Page</title>...
2
by: thx606 | last post by:
Hello, I'm having some trouble with my code below. One of my If statements causes the code not to work. If I take the If Statement out it runs fine. I highlighted the area that I'm having...
15
by: mangesh | last post by:
This code is from c++ faq in section 11 : void someCode() { char memory; void* p = memory; Fred* f = new(p) Fred(); f->~Fred(); // Explicitly call the destructor for the placed object }
15
by: LuB | last post by:
I am constantly creating and destroying a singular object used within a class I wrote. To save a bit of time, I am considering using 'placement new'. I guess we could also debate this decision -...
9
by: karthikbalaguru | last post by:
Hi, I find that articles stating that 'placement new' constructs an object on a pre-allocated buffer and so takes less time. Actually, we have to consider the allocation of the buffer and then...
15
by: rhino | last post by:
I've put together a prototype of two-tiered CSS tabs that works really well in IE6, IE7, and FF2. It also works very well in Opera 9.27 _except_ that the placement of the lower tier of tabs is...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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
0
BarryA
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...
1
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...
0
marktang
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,...
0
Oralloy
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.