Stripe disk for more perfomance?

JanMJanM Member Posts: 15
edited 2008-10-10 in SQL Performance
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

Comments

  • SavatageSavatage Member Posts: 7,142
    more disks mean more heads reading & writing which in turn brings more performance.

    Are you having performance problems? SQL or Native?
  • JanMJanM Member Posts: 15
    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?
  • garakgarak Member Posts: 3,263
    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
    Do you make it right, it works too!
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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
    David Singleton
Sign In or Register to comment.