Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: data/log/master/tempdb allocation

    Hi,

    my w2k server has these disks

    2 HD's 18GB each (mirrored and have OS installed, I cant change this)
    4 HD's 72GB each (empty as of now)

    How would you allocate data/log/master/tempd given:

    data: 120GB
    log: 1.5GB
    tempdb: 1GB (atleast)

    The data will be 100% static. So, the 4HD's 72GB each will NOT be mirrored or any raid or anything, since in case of any crash we will simply replace the HD's and restore from a working backup.

    So..what would you guys do and why ?

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    depending the speed of your disks.

    Normally,
    - master device in a disk
    - log devices in an other disk, mirrored if possible (you can use the Sybase mirroring)
    - tempdb device in a fast disk
    - data in other disks

    Tips : create a specific index segment for the nonlustered indexes, and put it in an other disk

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Thanks fadace,

    We've decided to put the 4 big disks in one Raid5 config and simply put everything inside of this array

    Hopefully it'll work out ok - as previously mentioned it'll be mostly *read only* except for some temptable stuff.

  4. #4
    Join Date
    Feb 2004
    Posts
    2
    Originally posted by fadace
    depending the speed of your disks.

    Normally,
    - master device in a disk
    - log devices in an other disk, mirrored if possible (you can use the Sybase mirroring)
    - tempdb device in a fast disk
    - data in other disks

    Tips : create a specific index segment for the nonlustered indexes, and put it in an other disk

    I have created the db with wrong datafile logfile location..I would
    like to change the locaion of the logfile ..How can i do that

    Pl guide me

    Suresh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •