Stripe disk for more perfomance?

JanM

Hi
We have a 40GB db and some 75GB disk with RAID 1. The file is small enough for one pair and it grows not much. Should we stripe other 75GB pairs to spread the data over? Does it bring more performance or is it negative while large tables are splitted up?

Thanks for a tip
Jan

Savatage

more disks mean more heads reading & writing which in turn brings more performance.

Are you having performance problems? SQL or Native?

JanM

We will move a native to sql and want avoid performance problems. As seen with other clients sql server is not that optimized but other clients used there old machine with loads from other applications. Now we can start with a new machine and setup the hole thing on the green field. We have 12 disk means 6 RAID 1:
1. master, model, msdb, tempdb
2. log
3. db stripe over 3 pairs
Now we are thinking if tempdb should have a separate pair and db stripe reduzed to only 2 pairs. We have no idea how much load tempdb with NAV will have or how you sad for the db more disk is allways the right way?

garak

more disk are better than one disk. It's equal if you use native or sql.

Search the forum for RAID to find all posts about these theme (like this post)

Regards

David_Singleton

JanM wrote:

We will move a native to sql and want avoid performance problems.

Take a read of these articles I wrote some time ago, it may help.


Planning a move from NAV native to SQL - Dynamics

Converting NAV C/SIDE database to SQL - Dynamics