Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ereader
Yak Posting Veteran
50 Posts |
 Posted - 2003-01-31 : 05:22:02
|
| hi allwe have a database going to be read intensive after replicating from the real time OLTP everydayHow filegroups will help us and is there is an problem in implementing RAID levels for backing up the databaseon a Compaq proliant seriesThanks |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-31 : 05:50:11
|
| From bol:Filegroups allow files to be grouped together for administrative and data allocation/placement purposes. For example, three files (Data1.ndf, Data2.ndf, and Data3.ndf) can be created on three disk drives, respectively, and assigned to the filegroup fgroup1. A table can then be created specifically on the filegroup fgroup1. Queries for data from the table will be spread across the three disks, thereby improving performance. The same performance improvement can be accomplished with a single file created on a RAID (redundant array of independent disks) stripe set. Files and filegroups, however, allow you to easily add new files on new disks. Additionally, if your database exceeds the maximum size for a single Microsoft Windows NT¢ç file, you can use secondary data files to allow your database to continue to grow.Expect the UnExpected |
 |
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2003-01-31 : 06:12:46
|
quote:
Expect the UnExpected
thanks for ur response What u mean by disk drives here C: D: E:or seperate physical drives for the filegroups like Disk1, Disk2 if i have two partition on my drive C: and D:what should i consider for the further performance point of viewEdited by - eReader on 01/31/2003 06:14:10 |
|
|
|
|
|
|
Filegroups performance