SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Full Text Index on separate Drive
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlmyworld
Starting Member

Australia
38 Posts

Posted - 07/13/2012 :  00:59:19  Show Profile  Reply with Quote
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 has
1) 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 has
1) 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

Australia
38 Posts

Posted - 07/17/2012 :  00:12:54  Show Profile  Reply with Quote
Is there any comment on above post??
Go to Top of Page

lionofdezert
Aged Yak Warrior

Pakistan
885 Posts

Posted - 07/17/2012 :  03:00:30  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
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/

Edited by - lionofdezert on 07/17/2012 03:03:13
Go to Top of Page

sqlmyworld
Starting Member

Australia
38 Posts

Posted - 07/18/2012 :  22:23:45  Show Profile  Reply with Quote
Aasim, thanks for your reply.

I will wait for Tara Kizer's reply.
Go to Top of Page

sqlmyworld
Starting Member

Australia
38 Posts

Posted - 07/26/2012 :  00:02:58  Show Profile  Reply with Quote
Tara, Do you have any comment on above post?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000