| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
| Created: | Tue Aug 23 1994 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
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.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 361.1 | CSC32::HOEPNER | A closed mouth gathers no feet | Mon Apr 14 1997 08:12 | 11 | |
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.2 | EXCENT::MCCRAW | Tue Apr 15 1997 05:16 | 4 | ||
thanks, I think i'll just stick with RAID.
Pete
| |||||