September 3, 2008 at 7:58 am
We have a DB that is 500GB in size.
Running on HP EVA with Clustered active/passive SQL Servers.
We are currently full text indexing 5 of the 500+ tables.
The problem is that 2 of the table are taking a very long time to do the incremental populations.
The first table only adds about 5000 records per day to a field that is full text index that has length of 100 varchar.
The second table adds 10000 records per day to 2 fields that are only 50 varchar each.
Anyone have any helpful hints?
September 4, 2008 at 11:07 am
Check the table fragmentation level(using DBCC showcontig). Are you sure its incremental rather than FULL one.
MJ
September 8, 2008 at 2:11 pm
Tables get reindex every Saturday night.
Yep, it says incremental, so I'm assuming it is.
September 9, 2008 at 9:32 am
I guess it was doing a "Full" index, as I didnt' have a timeStamp column on the tables.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply