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 |
|
sqlmyworld
Starting Member
38 Posts |
 Posted - 2012-07-13 : 00:59:19
|
| We have a database on SQL Server 2008 R2 which contains two Full text catalogs. DB Files exist on separate drive as per below information.Drive D has1) Main Data File - .mdf (size 80 GB)2) Secondary Data file - Catalog1.ndf (size 370 MB)2) another Secondary Data file - Catalog2.ndf (size 5 MB)Drive E has1) Log file - .ldf (Size 30 GB)Question - 1) Is it worth to put Index catelog files (two .ndf files) to separate drives let's say Drive F? Can I get performance improvement by doing this?2) Generally, should we put index files on separate drive while designing and allocating SQL drive specification?Thanks in Adv. |
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2012-07-17 : 00:12:54
|
| Is there any comment on above post?? |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-07-17 : 03:00:30
|
| 1) Yes, for our production servers, we have seprate drive for Index Cataloge files.2) Putting index on seprate files from data files, is not a common practice as it doesn't help to improve performance.3) You must care about TempDB, it should not be on C drive(Tara Kizer has much better in hand experience and could answer in more better way. Wait for her answer)--------------------------http://connectsql.blogspot.com/ |
|
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2012-07-18 : 22:23:45
|
| Aasim, thanks for your reply.I will wait for Tara Kizer's reply. |
|
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2012-07-26 : 00:02:58
|
| Tara, Do you have any comment on above post? |
|
|
|
|
|
|
Full Text Index on separate Drive