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 |
|
JokerOfACoder
Starting Member
18 Posts |
 Posted - 2007-05-14 : 00:20:07
|
| Is it possible to partition the index or the data file into multiple files and place it across multiple disks for IO write and read speed WITHOUT using RAID?I'm expecting 6 tables with 20-40 mill data that will be queried by INDEXES (integral) constantly (8 queries at a time). I think if I can partition it somehow, it will be faster. By partition, i don't want to create extra tables...too much maintance. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-05-14 : 00:26:47
|
| You can create filegroups or multiple filegroups to hold the data and indexes. You can create one or more files in each filegroup and place the files on multiple disks.You should read about filegroups and files in SQL Server Books Online.CODO ERGO SUM |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 10:06:54
|
| Patitioning table and index (not just put table on multiple files) will give you extra performance gain. |
|
|
|
|
|
|
Partioning Large tables