Post reply

Creating an FTI index on a seperate server for extra performance - how to do this ?

  • October 4, 2011 at 7:53 am

    #390538

    Does anyone have any experience in creating an FTI index on a seperate server, for extra performance?

    Just to clarify, one server runs the main DB and a seperate server runs just the FTI index.

    Is it possible to use common words in a preloaded, indexed table, instead of always creating a new temp indexed table?

    Thanks

  • October 4, 2011 at 8:15 am

    #1390157

    isuckatsql (10/4/2011)

    Does anyone have any experience in creating an FTI index on a seperate server, for extra performance?

    Just to clarify, one server runs the main DB and a separate server runs just the FTI index.

    Is it possible to use common words in a preloaded, indexed table, instead of always creating a new temp indexed table?

    Thanks

    I hope FTI stands for Full Text Indexes (sorry, just to be sure).

    As per MS recommendation (BOL): "Put the logs, database files, and full-text catalogs on separate disks. Buying faster disks and using RAID can also help improve indexing performance."

    I did this before (I mean separate disks) and it helped. But frankly not sure why do you need "separate server" for this purpose?

  • October 4, 2011 at 8:30 am

    #1390166

    I am using seperate RAID for the TempDB (Raid0), Logs(Raid1), Data(Raid10) and Program files(Raid1).

    I read in one of the MS technet forums, that you can put the Full text index on a dedicated server for extra performance, i'm just not sure how to tie it into the SQL query.

    Thanks

  • October 4, 2011 at 9:54 am

    #1390230

    isuckatsql (10/4/2011)

    I am using sperate RAID for the TempDB (Raid0), Logs(Raid1), Data(Raid10) and Program files(Raid1).

    I read in one of the MS technet forums, that you can put the Full text index on a dedicated server for extra performance, i'm just not sure how to tie it into the SQL query.

    Thanks

    Just curious (as working a lot with FTS)- are you sure that "one of the MS technet forums" discussed FTS on 2008 (not 2005) as there is big difference (certainly you know about it) between these 2 versions?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply