[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference amcucs::ms-sqlsvr

Title:Microsoft SQL Server Support
Notice:Please Registar, Note #11
Moderator:AMCUCS::BETTS
Created:Tue Aug 23 1994
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:382
Total number of notes:1233

361.0. "Segment or Not?" by EXCENT::MCCRAW () Fri Apr 11 1997 08:22

    
    I was looking for opinions on using segments in SQLserver 6.5. The MS
    documentation recommend's using RAID verse's segments. I guess i'm
    looking to duplicate the functionality of the Rdb storage areas,
    segments seem to be the closest thing. The database i'm working with 
    supports a revenue reporting application. Basically it has one very
    large table and several medium size tables. I would like to isolate the
    large table on a set off fast wide scsi disk's since it's the most active
    table.
    
    
    thanks,
    
    Peter
T.RTitleUserPersonal
Name
DateLines
361.1CSC32::HOEPNERA closed mouth gathers no feetMon Apr 14 1997 12:1211
    
    The only thing we have seen that is a concern with segmenting, is
    MAKE SURE YOU CAN RECOVER YOUR BACKUP.
    
    THere have been a couple of cases where we were able to restore 
    successfully a segmented database.
    
    Also for 'speed', consider hardware RAID 0+1 rather than RAID 5. 
    The performance is 10-20% better. 
    
    
361.2EXCENT::MCCRAWTue Apr 15 1997 09:164
    
    thanks, I think i'll just stick with RAID.
    
    Pete