Improvements in Integrated FullText Search (iFTS) in SQL Server 2008 RC0

SQL Server 2008 RC0 was released to the public a couple of weeks ago, and we have been using it on a couple of Production servers for about three weeks. So far, I am pretty happy with RC0, especially compared with the February CTP (CTP6) that we were previously using.

We have RC0 running iFTS on a dedicated, standalone server (a Dell PowerEdge 1950 with one, quad-core Xeon 5450, 16GB of RAM, connected to our 3PAR S400 SAN). The FT Catalog is on a table with about 70 million rows of data that is very volatile (about 80-100 inserts/second and 70-90 deletes/second).

We have been doing quite a bit of testing on this server and I have noticed the following improvements in RC0:

We can have Auto Change Tracking enabled, and iFTS has absolutely no problem keeping up with our rate of data change.

So far, I have not had to do a single Master merge, and my FT Index fragment count has stayed very low.

In general, the amount of maintenance required to keep iFTS happy (Master merges, relational index reorganizations, etc), has been reduced to almost nothing.

With CTP6, I had to disable Auto Change Tracking (and have an Agent Job run a command to apply the pending updates) every five minutes. I also had to run nearly constant Master merges to keep the FT Index fragment count under control. I also had to spend a lot of server effort keeping the relational index fragmentation under control, and I had to be very careful that relational index reorganization jobs and FT Index Master merges never ran concurrently. It was a lot of administrative effort in CTP6, but this is dramatically improved in RC0 of SQL Server 2008.

 

Technorati Tags:
This entry was posted in SQL Server 2008. Bookmark the permalink.

2 Responses to Improvements in Integrated FullText Search (iFTS) in SQL Server 2008 RC0

  1. ez says:

    http://www.batteryfast.com.au/compaq/dv2000.htm Compaq dv2000 Battery http://www.batteryfast.com.au/compaq/dv2200.htm Compaq dv2200 Battery http://www.batteryfast.com.au/compaq/pavilion-dv2000.htm Compaq pavilion dv2000 Battery http://www.batteryfast.com.au/compaq/pavilion-dv6000.htm Compaq pavilion dv6000 Battery http://www.batteryfast.com.au/dell/d5318.htm Dell d5318 Battery http://www.batteryfast.com.au/dell/e1405.htm Dell e1405 Battery http://www.batteryfast.com.au/dell/gw240.htm Dell gw240 Battery http://www.batteryfast.com.au/dell/inspiron-630m.htm Dell inspiron 630m Battery http://www.batteryfast.com.au/dell/inspiron-640m.htm Dell inspiron 640m Battery http://www.batteryfast.com.au/dell/inspiron-8000.htm Dell inspiron 8000 Battery http://www.batteryfast.com.au/dell/inspiron-8100.htm Dell inspiron 8100 Battery http://www.batteryfast.com.au/dell/inspiron-8200.htm Dell inspiron 8200 Battery http://www.batteryfast.com.au/dell/m1210.htm Dell m1210 Battery http://www.batteryfast.com.au/dell/pu563.htm Dell pu563 Battery http://www.batteryfast.com.au/dell/rn873.htm Dell rn873 Battery http://www.batteryfast.com.au/dell/RU030.htm Dell RU030 Battery http://www.batteryfast.com.au/dell/td175.htm Dell td175 Battery http://www.batteryfast.com.au/dell/TK330.htm Dell TK330 Battery http://www.batteryfast.com.au/dell/w953g.htm Dell w953g Battery http://www.batteryfast.com.au/dell/WG317.htm Dell WG317 Battery http://www.batteryfast.com.au/gateway/m360.htm Gateway m360 Battery http://www.batteryfast.com.au/gateway/m460.htm Gateway m460 Battery http://www.batteryfast.com.au/gateway/m680.htm Gateway m680 Battery http://www.batteryfast.com.au/hp/dv9500.htm Hp dv9500 Battery http://www.batteryfast.com.au/hp/dv9600.htm Hp dv9600 Battery http://www.batteryfast.com.au/hp/dv9700.htm Hp dv9700 Battery http://www.batteryfast.com.au/gateway/8msb.htm Gateway 8msb Battery http://www.batteryfast.com.au/gateway/8msbg.htm Gateway 8msbg Battery http://www.batteryfast.com.au/hp/zt1000.htm Hp zt1000 Battery http://www.batteryfast.com.au/hp/zt3000.htm Hp zt3000 Battery http://www.batteryfast.com.au/ibm/02k6928.htm Ibm 02k6928 Battery http://www.batteryfast.com.au/ibm/02k7055.htm Ibm 02k7055 Battery http://www.batteryfast.com.au/ibm/02k7072.htm Ibm 02k7072 Battery http://www.batteryfast.com.au/ibm/thinkpad-r40.htm Ibm thinkpad r40 Battery http://www.batteryfast.com.au/ibm/thinkpad-t30.htm Ibm thinkpad t30 Battery http://www.batteryfast.com.au/laptop-ac-adapter/dell/inspiron-6400.htm Dell inspiron 6400 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d620.htm Dell latitude d620 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d630.htm Dell latitude d630 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d820.htm Dell latitude d820 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/d820.htm Dell d820 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/hp/dv4000.htm Hp dv4000 Adapter http://www.batteryfast.com.au/hp/pavilion-dv9700.htm HP pavilion dv9700 Battery http://www.batteryfast.com.au/hp/pavilion-dv9500.htm HP pavilion dv9500 Battery http://www.batteryfast.com.au/laptop-ac-adapter/liteon/presario-1200.htm Liteon presario 1200 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/liteon/presario-1600.htm Liteon presario 1600 Adapter

  2. ez says:

    http://www.batterylaptoppower.com/compaq/presario-1200.htm Compaq presario 1200 Battery http://www.batterylaptoppower.com/compaq/presario-1600.htm Compaq presario 1600 Battery http://www.batterylaptoppower.com/compaq/presario-1800.htm Compaq presario 1800 Battery http://www.batterylaptoppower.com/dell/312-009.htm Dell 312-009 Battery http://www.batterylaptoppower.com/dell/4e369.htm Dell 4e369 Battery http://www.batterylaptoppower.com/dell/d5318.htm Dell d5318 Battery http://www.batterylaptoppower.com/dell/e1405.htm Dell e1405 Battery http://www.batterylaptoppower.com/dell/gw240.htm Dell gw240 Battery http://www.batterylaptoppower.com/dell/HG307.htm Dell HG307 Battery http://www.batterylaptoppower.com/dell/inspiron-1000.htm Dell inspiron 1000 Battery http://www.batterylaptoppower.com/dell/inspiron-1100-series.htm Dell inspiron 1100 series Battery http://www.batterylaptoppower.com/dell/inspiron-1150.htm Dell inspiron 1150 Battery http://www.batterylaptoppower.com/dell/inspiron-1200.htm Dell inspiron 1200 Battery http://www.batterylaptoppower.com/dell/inspiron-1300.htm Dell inspiron 1300 Battery http://www.batterylaptoppower.com/dell/inspiron-1521.htm Dell inspiron 1521 Battery http://www.batterylaptoppower.com/dell/inspiron-4000.htm Dell inspiron 4000 Battery http://www.batterylaptoppower.com/dell/inspiron-8000.htm Dell inspiron 8000 Battery http://www.batterylaptoppower.com/dell/inspiron-8100.htm Dell inspiron 8100 Battery http://www.batterylaptoppower.com/dell/inspiron-8200.htm Dell inspiron 8200 Battery http://www.batterylaptoppower.com/dell/inspiron-9300.htm Dell inspiron 9300 Battery http://www.batterylaptoppower.com/dell/inspiron-9400.htm Dell inspiron 9400 Battery http://www.batterylaptoppower.com/dell/inspiron-b120.htm Dell inspiron b120 Battery http://www.batterylaptoppower.com/hp/nc6000.htm Hp nc6000 Battery http://www.batterylaptoppower.com/hp/nc8000.htm Hp nc8000 Battery http://www.batterylaptoppower.com/hp/nx9500.htm Hp nx9500 Battery http://www.batterylaptoppower.com/hp/pavilion-dv8100.htm Hp pavilion dv8100 Battery http://www.batterylaptoppower.com/hp/pavilion-dv8200.htm Hp pavilion dv8200 Battery http://www.batterylaptoppower.com/dell/rn873.htm Dell rn873 Battery http://www.batterylaptoppower.com/dell/RU030.htm Dell RU030 Battery http://www.batterylaptoppower.com/dell/TK330.htm Dell TK330 Battery http://www.batterylaptoppower.com/dell/xps-m140.htm Dell xps m140 Battery http://www.batterylaptoppower.com/gateway/6500632.htm Gateway 6500632 Battery http://www.batterylaptoppower.com/hp/500.htm Hp 500 Battery http://www.batterylaptoppower.com/hp/520.htm Hp 520 Battery http://www.batterylaptoppower.com/mitac/bp-8050(p).htm Mitac bp-8050(p) Battery http://www.batterylaptoppower.com/mitac/bp-8089p.htm Mitac bp-8089p Battery http://www.batterylaptoppower.com/ibm/thinkpad-t42.htm Ibm thinkpad t42 Battery http://www.batterylaptoppower.com/ibm/thinkpad-t60.htm Ibm thinkpad t60 Battery http://www.batterylaptoppower.com/ibm/thinkpad-x41.htm Ibm thinkpad x41 Battery http://www.batterylaptoppower.com/ibm/thinkpad-z60m.htm Ibm thinkpad z60m Battery http://www.batterylaptoppower.com/ibm/thinkpad-z60t.htm Ibm thinkpad z60t Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61e.htm Ibm thinkpad z61e Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61m.htm Ibm thinkpad z61m Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61t.htm Ibm thinkpad z61t Battery http://www.batterylaptoppower.com/mitac/8050.htm Mitac 8050 Battery

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s