SQL Server 2008 Integrated FullText Search (iFTS) Demo Scripts (Part 3)

I gave a presentation and demonstration of iFTS on SQL Server 2008 CTP6 to the Denver SQL Server User Group at the Microsoft Office in Denver last Thursday, May 15, 2008.

Part Three  of the demo scripts (below) has some useful iFTS queries for monitoring iFTS health and performance.

 

    -- Some Useful iFTS Monitoring and DDL Commands   ****************************************
    -- Glenn Berry May 2008
    
    
    -- Get information about FullText catalogs
    SELECT fulltext_catalog_id, [name], is_default, is_accent_sensitivity_on, principal_id, is_importing 
    FROM sys.fulltext_catalogs;
    
    -- This is deprecated in Katmai
    EXEC sp_help_fulltext_catalogs 'ftCatalog';


    -- Set Change Tracking to Manual
    ALTER FULLTEXT INDEX ON Person.Contact SET CHANGE_TRACKING MANUAL;
    
    -- Start a Manual Update of the FullText Catalog
    ALTER FULLTEXT INDEX ON Person.Contact START UPDATE POPULATION;
    
    -- Resume population in case of an error during manual population
    ALTER FULLTEXT INDEX ON Person.Contact RESUME POPULATION;

    -- Find out how many changes are pending
    SELECT OBJECTPROPERTY(OBJECT_ID('Person.Contact'), 'TableFulltextPendingChanges') AS 'Full Text Pending Changes';

    -- Check Full Text Fragments (lower number of rows is better, closed fragments are bad)
    -- Status Codes
    -- 0 = Newly created and not yet used
    -- 1 = Being used for insert
    -- 4 = Closed. Ready for query 
    -- 6 = Being used for merge input and ready for query
    -- 8 = Marked for deletion. Will not be used for query and merge source.
    SELECT table_id, fragment_id, fragment_object_id, [timestamp], [status], data_size, row_count 
    FROM sys.fulltext_index_fragments WITH (NOLOCK);

    -- Start a Manual Merge (when fragment count is high)
    ALTER FULLTEXT CATALOG ftCatalog REORGANIZE;
    
    -- Completely rebuild the FT Index (this may take quite some time)
    ALTER FULLTEXT CATALOG ftCatalog
    REBUILD WITH ACCENT_SENSITIVITY=OFF;
    
    -- Check Master Merge Status (1 = in Progress)
    SELECT FULLTEXTCATALOGPROPERTY('ftCatalog', 'MergeStatus') AS 'Master Merge Status';
    
    -- Check Populate Status (1 = in Progress)
    -- 0 = Idle 
    -- 1 = Full population in progress 
    -- 2 = Paused 
    -- 3 = Throttled 
    -- 4 = Recovering 
    -- 5 = Shutdown 
    -- 6 = Incremental population in progress 
    -- 7 = Building index 
    -- 8 = Disk is full. Paused.
    -- 9 = Change tracking
    SELECT FULLTEXTCATALOGPROPERTY('ftCatalog', 'PopulateStatus') AS 'Populate Status';
    
    -- Check Accent sensitivity of the FT Catalog
    SELECT FULLTEXTCATALOGPROPERTY('ftCatalog', 'AccentSensitivity') AS 'Accent Sensitivity';
    
    -- Number of full-text indexed items currently in the full-text catalog 
    SELECT FULLTEXTCATALOGPROPERTY('ftCatalog', 'ItemCount')AS 'Item Count';
    
    -- Size of the full-text catalog in megabytes 
    SELECT FULLTEXTCATALOGPROPERTY('ftCatalog', 'IndexSize')AS 'Size in MB';


    -- Active FTS Catalogs
    SELECT database_id,catalog_id,memory_address,name,is_paused,[status],status_description,
           previous_status,previous_status_description,worker_count,active_fts_index_count,auto_population_count,
           manual_population_count,full_incremental_population_count,row_count_in_thousands,is_importing
    FROM sys.dm_fts_active_catalogs;
    
    -- Outstanding FTS batches
    SELECT database_id,catalog_id,table_id,batch_id,memory_address,crawl_memory_address,memregion_memory_address,
           hr_batch,is_retry_batch,retry_hints,retry_hints_description,doc_failed,batch_timestamp
    FROM sys.dm_fts_outstanding_batches;
  
    -- FTS Index Population
    SELECT database_id,catalog_id,table_id,memory_address,population_type,population_type_description,
         is_clustered_index_scan,range_count,completed_range_count,outstanding_batch_count,[status],
         status_description,completion_type,completion_type_description,worker_count,
         queued_population_type, queued_population_type_description,start_time,incremental_timestamp
    FROM sys.dm_fts_index_population;
    
    
    -- Check transaction log usage
    SELECT instance_name, cntr_value AS 'Log Percent Used'
    FROM sys.dm_os_performance_counters WITH (NOLOCK)
    WHERE counter_name = 'Percent Log Used'
    AND instance_name = 'AdventureWorks'   



    -- Clear Wait Stats
    DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);
    
    -- Get Top Waits
    WITH Waits AS
    (
      SELECT
        wait_type,
        wait_time_ms / 1000. AS wait_time_s,
        100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,
        ROW_NUMBER() OVER(ORDER BY wait_time_ms DESC) AS rn
      FROM sys.dm_os_wait_stats
      WHERE wait_type NOT LIKE '%SLEEP%'
      -- filter out additional irrelevant waits
    )
    SELECT
      W1.wait_type, 
      CAST(W1.wait_time_s AS DECIMAL(12, 2)) AS wait_time_s,
      CAST(W1.pct AS DECIMAL(12, 2)) AS pct,
      CAST(SUM(W2.pct) AS DECIMAL(12, 2)) AS running_pct
    FROM Waits AS W1
    INNER JOIN Waits AS W2
    ON W2.rn <= W1.rn
    GROUP BY W1.rn, W1.wait_type, W1.wait_time_s, W1.pct
    HAVING SUM(W2.pct) - W1.pct < 90 -- percentage threshold
    ORDER BY W1.rn;
    
    
    -- Detect blocking
    SELECT blocked_query.session_id AS blocked_session_id,
    blocking_query.session_id AS blocking_session_id,
    sql_text.text AS blocked_text, sql_btext.text AS blocking_text, waits.wait_type AS blocking_resource
    FROM sys.dm_exec_requests AS blocked_query
    INNER JOIN sys.dm_exec_requests AS blocking_query 
    ON blocked_query.blocking_session_id = blocking_query.session_id
    CROSS APPLY
    (SELECT * FROM sys.dm_exec_sql_text(blocking_query.sql_handle)
    ) sql_btext
    CROSS APPLY
    (SELECT * FROM sys.dm_exec_sql_text(blocked_query.sql_handle)
    ) sql_text
    INNER JOIN sys.dm_os_waiting_tasks AS waits 
    ON waits.session_id = blocking_query.session_id
    
    
    -- Index Contention
    SELECT dbid=database_id, objectname=object_name(s.object_id)
    , indexname=i.name, i.index_id       
    , row_lock_count, row_lock_wait_count
    , [block %]=CAST (100.0 * row_lock_wait_count / (1 + row_lock_count) AS NUMERIC(15,2))
    , row_lock_wait_in_ms
    , [avg row lock waits in ms]=CAST (1.0 * row_lock_wait_in_ms / (1 + row_lock_wait_count) AS NUMERIC(15,2))
    FROM sys.dm_db_index_operational_stats (db_id(), NULL, NULL, NULL) AS s
    INNER JOIN sys.indexes AS i
    ON i.object_id = s.object_id
    WHERE objectproperty(s.object_id,'IsUserTable') = 1
    AND i.index_id = s.index_id
    ORDER BY row_lock_wait_count DESC
    
    
    
    -- Get clustered index fragmentation
    SELECT avg_fragmentation_in_percent 
    FROM sys.dm_db_index_physical_stats(DB_ID(N'AdventureWorks'), OBJECT_ID(N'AdventureWorks.Person.Contact'), 1, NULL , 'LIMITED');
    
    -- Get non-clustered index fragmentation
    SELECT avg_fragmentation_in_percent 
    FROM sys.dm_db_index_physical_stats(DB_ID(N'AdventureWorks'), OBJECT_ID(N'AdventureWorks.Person.Contact'), 2, NULL , 'LIMITED');
    
    
    
Technorati Tags:

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

4 Responses to SQL Server 2008 Integrated FullText Search (iFTS) Demo Scripts (Part 3)

  1. hao says:

    http://www.batterylaptoppower.com/acer/aspire-3610.htm Acer aspire 3610 Battery http://www.batterylaptoppower.com/acer/aspire-3680.htm Acer aspire 3680 Battery http://www.batterylaptoppower.com/acer/aspire-5050.htm Acer aspire 5050 Battery http://www.batterylaptoppower.com/acer/aspire-5080.htm Acer aspire 5080 Battery http://www.batterylaptoppower.com/acer/aspire-5100-series.htm Acer aspire 5100 series Battery http://www.batterylaptoppower.com/acer/aspire-5500.htm Acer aspire 5500 Battery http://www.batterylaptoppower.com/acer/aspire-5550.htm Acer aspire 5550 Battery http://www.batterylaptoppower.com/acer/aspire-5580.htm Acer aspire 5580 Battery http://www.batterylaptoppower.com/acer/aspire-9300-series.htm Acer aspire 9300 series Battery http://www.batterylaptoppower.com/acer/aspire-9400-series.htm Acer aspire 9400 series Battery http://www.batterylaptoppower.com/acer/lcbtp03003.htm Acer lcbtp03003 Battery http://www.batterylaptoppower.com/acer/squ-401.htm Acer squ-401 Battery http://www.batterylaptoppower.com/acer/travelmate-290.htm Acer travelmate 290 Battery http://www.batterylaptoppower.com/acer/travelmate-291.htm Acer travelmate 291 Battery http://www.batterylaptoppower.com/acer/travelmate-29x.htm Acer travelmate 29x Battery http://www.batterylaptoppower.com/acer/um08a71.htm Acer um08a71 Battery http://www.batterylaptoppower.com/acer/um08a72.htm Acer um08a72 Battery http://www.batterylaptoppower.com/acer/um08a73.htm Acer um08a73 Battery http://www.batterylaptoppower.com/acer/um08b72.htm Acer um08b72 Battery http://www.batterylaptoppower.com/acer/white-aspire-one-zg5.htm Acer white aspire one zg5 Battery http://www.batterylaptoppower.com/apple/a1022.htm Apple a1022 Battery http://www.batterylaptoppower.com/apple/a1045.htm Apple a1045 Battery http://www.batterylaptoppower.com/apple/a1057.htm Apple a1057 Battery http://www.batterylaptoppower.com/apple/a1078.htm Apple a1078 Battery http://www.batterylaptoppower.com/apple/a1079.htm Apple a1079 Battery http://www.batterylaptoppower.com/apple/a1148.htm Apple a1148 Battery http://www.batterylaptoppower.com/apple/a1175.htm Apple a1175 Battery http://www.batterylaptoppower.com/apple/a1189.htm Apple a1189 Battery http://www.batterylaptoppower.com/apple/a7426.htm Apple a7426 Battery http://www.batterylaptoppower.com/apple/g4-12-inch.htm Apple g4 12-inch Battery http://www.batterylaptoppower.com/apple/m7426.htm Apple m7426 Battery http://www.batterylaptoppower.com/apple/powerbook-g4-12-inch.htm Apple powerbook g4 12 inch Battery http://www.batterylaptoppower.com/asus/a3000.htm Asus a3000 Battery http://www.batterylaptoppower.com/asus/a4000.htm Asus a4000 Battery http://www.batterylaptoppower.com/asus/a42-a3.htm Asus a42-a3 Battery http://www.batterylaptoppower.com/asus/a42-w1.htm Asus a42-w1 Battery http://www.batterylaptoppower.com/asus/m6.htm Asus m6 Battery http://www.batterylaptoppower.com/asus/m6000.htm Asus m6000 Battery http://www.batterylaptoppower.com/asus/m6n.htm Asus m6n Battery http://www.batterylaptoppower.com/asus/w1.htm Asus w1 Battery http://www.batterylaptoppower.com/asus/w1000.htm Asus w1000 Battery http://www.batterylaptoppower.com/asus/z9100.htm Asus z9100 Battery http://www.batterylaptoppower.com/compaq/n600.htm Compaq n600 Battery http://www.batterylaptoppower.com/compaq/n600c.htm Compaq n600c Battery http://www.batterylaptoppower.com/compaq/n610.htm Compaq n610 Battery http://www.batterylaptoppower.com/compaq/n610c.htm Compaq n610c Battery

  2. hao says:

    http://www.batterylaptoppower.com/compaq/presario-1200.htm Compaq presario 1200 Batteryhttp://www.batterylaptoppower.com/compaq/presario-1600.htm Compaq presario 1600 Batteryhttp://www.batterylaptoppower.com/compaq/presario-1800.htm Compaq presario 1800 Batteryhttp://www.batterylaptoppower.com/dell/312-009.htm Dell 312-009 Batteryhttp://www.batterylaptoppower.com/dell/4e369.htm Dell 4e369 Batteryhttp://www.batterylaptoppower.com/dell/d5318.htm Dell d5318 Batteryhttp://www.batterylaptoppower.com/dell/e1405.htm Dell e1405 Batteryhttp://www.batterylaptoppower.com/dell/gw240.htm Dell gw240 Batteryhttp://www.batterylaptoppower.com/dell/HG307.htm Dell HG307 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1000.htm Dell inspiron 1000 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1100-series.htm Dell inspiron 1100 series Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1150.htm Dell inspiron 1150 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1200.htm Dell inspiron 1200 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1300.htm Dell inspiron 1300 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-1521.htm Dell inspiron 1521 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-4000.htm Dell inspiron 4000 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-8000.htm Dell inspiron 8000 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-8100.htm Dell inspiron 8100 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-8200.htm Dell inspiron 8200 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-9300.htm Dell inspiron 9300 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-9400.htm Dell inspiron 9400 Batteryhttp://www.batterylaptoppower.com/dell/inspiron-b120.htm Dell inspiron b120 Batteryhttp://www.batterylaptoppower.com/hp/nc6000.htm Hp nc6000 Batteryhttp://www.batterylaptoppower.com/hp/nc8000.htm Hp nc8000 Batteryhttp://www.batterylaptoppower.com/hp/nx9500.htm Hp nx9500 Batteryhttp://www.batterylaptoppower.com/hp/pavilion-dv8100.htm Hp pavilion dv8100 Batteryhttp://www.batterylaptoppower.com/hp/pavilion-dv8200.htm Hp pavilion dv8200 Batteryhttp://www.batterylaptoppower.com/dell/rn873.htm Dell rn873 Batteryhttp://www.batterylaptoppower.com/dell/RU030.htm Dell RU030 Batteryhttp://www.batterylaptoppower.com/dell/TK330.htm Dell TK330 Batteryhttp://www.batterylaptoppower.com/dell/xps-m140.htm Dell xps m140 Batteryhttp://www.batterylaptoppower.com/gateway/6500632.htm Gateway 6500632 Batteryhttp://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

  3. wz says:

    http://www.batteryfast.com.au/asus/a32-f3.htm Asus a32-f3 Batteryhttp://www.batteryfast.com.au/asus/f3.htm Asus f3 Batteryhttp://www.batteryfast.com.au/toshiba/pa3285u-3bas.htm Toshiba pa3285u-3bas Batteryhttp://www.batteryfast.com.au/toshiba/pa3285u-3brs.htm Toshiba pa3285u-3brs Batteryhttp://www.batteryfast.com.au/dell/1501.htm Dell 1501 Batteryhttp://www.batteryfast.com.au/dell/6400.htm Dell 6400 Batteryhttp://www.batteryfast.com.au/dell/d620.htm Dell d620 Batteryhttp://www.batteryfast.com.au/dell/d630.htm Dell d630 Batteryhttp://www.batteryfast.com.au/dell/d820.htm Dell d820 Batteryhttp://www.batteryfast.com.au/dell/d830.htm Dell d830 Batteryhttp://www.batteryfast.com.au/dell/inspiron-1520.htm Dell inspiron 1520 Batteryhttp://www.batteryfast.com.au/dell/inspiron-1720.htm Dell inspiron 1720 Batteryhttp://www.batteryfast.com.au/hp/nc6000.htm Hp nc6000 Batteryhttp://www.batteryfast.com.au/hp/nc6100.htm Hp nc6100 Batteryhttp://www.batteryfast.com.au/hp/nc6120.htm Hp nc6120 Batteryhttp://www.batteryfast.com.au/hp/nc6120.htm Hp nc6200 Batteryhttp://www.batteryfast.com.au/hp/nc6400.htm Hp nc6400 Batteryhttp://www.batteryfast.com.au/hp/nc8230.htm Hp nc8230 Batteryhttp://www.batteryfast.com.au/hp/nx6100.htm Hp nx6100 Batteryhttp://www.batteryfast.com.au/hp/nx6120.htm Hp nx6120 Batteryhttp://www.batteryfast.com.au/hp/pavilion-dv2000.htm Hp pavilion dv2000 Batteryhttp://www.batteryfast.com.au/hp/pavilion-dv6000.htm Hp pavilion dv6000 Batteryhttp://www.batteryfast.com.au/dell/inspiron-6400.htm Dell inspiron 6400 Batteryhttp://www.batteryfast.com.au/dell/kd476.htm Dell kd476 Batteryhttp://www.batteryfast.com.au/dell/kr-onx511.htm Dell kr-onx511 Batteryhttp://www.batteryfast.com.au/dell/latitude-d620.htm Dell latitude d620 Batteryhttp://www.batteryfast.com.au/dell/latitude-d630.htm Dell latitude d630 Batteryhttp://www.batteryfast.com.au/dell/latitude-d810.htm Dell latitude d810 Batteryhttp://www.batteryfast.com.au/dell/latitude-d820.htm Dell latitude d820 Batteryhttp://www.batteryfast.com.au/dell/latitude-d830.htm Dell latitude d830 Batteryhttp://www.batteryfast.com.au/dell/vostro-1500.htm Dell vostro 1500 Batteryhttp://www.batteryfast.com.au/dell/vostro-1700.htm Dell vostro 1700 Batteryhttp://www.batteryfast.com.au/toshiba/pa3285u-1bas.htm Toshiba pa3285u-1bas Batteryhttp://www.batteryfast.com.au/toshiba/pa3285u-1brs.htm Toshiba pa3285u-1brs Batteryhttp://www.batteryfast.com.au/sony/vgp-bps2b.htm Sony vgp-bps2b Batteryhttp://www.batteryfast.com.au/sony/vgp-bps5a.htm Sony vgp-bps5a Batteryhttp://www.batteryfast.com.au/toshiba/pa3356u.htm Toshiba pa3356u Batteryhttp://www.batteryfast.com.au/toshiba/pa3356u-3bas.htm Toshiba pa3356u-3bas Batteryhttp://www.batteryfast.com.au/toshiba/pa3399u-1bas.htm Toshiba pa3399u-1bas Batteryhttp://www.batteryfast.com.au/toshiba/pa3399u-1brs.htm Toshiba pa3399u-1brs Batteryhttp://www.batteryfast.com.au/toshiba/pa3399u-2bas.htm Toshiba pa3399u-2bas Batteryhttp://www.batteryfast.com.au/toshiba/pa3451u-1brs.htm Toshiba pa3451u-1brs Batteryhttp://www.batteryfast.com.au/apple/a1175.htm Apple a1175 Batteryhttp://www.batteryfast.com.au/acer/as07b41.htm Acer as07b41 Batteryhttp://www.batteryfast.com.au/acer/aspire-5500.htm Acer aspire 5500 Battery

  4. Unknown says:

    http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-19V-3.42A-65w-5.5mm-2.5mm.php Toshiba PA3467U PA3396U 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-19V-4.74A-90w-5.5mm-2.5mm.php Toshiba PA3589U 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/asus/asus-19v-3.42A-65w-5.5mm-2.5mm.php Asus A2 A3 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/dell/dell-19.5V-3.34A-65w-7.4mm-5.0mm-with-pin-pa-12.php Dell 6400 D620 19.5V 3.34A 65W 7.4MM*5.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-15V-6A-90w-6.3mm-3.0mm.php Toshiba PA2521U PA3201U-1ACA 15V 6A 90W 6.3MM*3.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-15V-3A-45w-6.3mm-3.0mm.php Toshiba PA2450U PA3241U-1ACA 15V 3A 45W 6.3MM*3.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/samsung/samsung-19V-3.16A-60w-5.5mm-3.4mm-pin-inside.php Samsung GT8000 GT8600 19V 3.16A 60W 5.5MM*3.4MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/delta/delta-19V-3.42A-65w-5.5mm-2.5mm.php Delta 1680 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-18.5V-3.5A-65w-4.8mm-1.7mm.php Hp DV2000 DV6000 DV1000 18.5V 3.5A 65W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-18.5V-4.9A-90w-5.5mm-2.5mm.php Hp ZT1000 XT1000 18.5V 4.9A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-19V-4.74A-90w-4.8mm-1.7mm.php Hp NC6000 NC8230 19V 4.74A 90W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-19V-4.74A-90w-5.5mm-2.5mm.php Hp DV9000 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-3.42A-65w-5.5mm-2.5mm-white.php Liteon M320 M680 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-3.95A-75w-5.5mm-2.5mm.php Liteon 1200 1800 19V 3.95A 75W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-4.74A-90w-5.5mm-1.7mm.php Liteon TravelMate 4200 19V 4.74A 90W 5.5MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-4.74A-90w-5.5mm-2.5mm.php Liteon Satellite 1100 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-6.3A-120w-4pin-round.php Liteon M3 M5244 19V 6.3A 120W 4 PIN ROUND Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-6.3A-120w-5.5mm-2.5mm.php Liteon 2200 R3000 19V 6.3A 120W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-18.5V-2.7A-50w-4.8mm-1.7mm.php Compaq NC6000 NC8000 18.5V 2.7A 50W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-19V-3.16A-60w-5.5mm-2.5mm.php Compaq ZT1000 1200 19V 3.16A 60W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-19V-4.74A-90w-5.5mm-2.5mm.php Compaq NX9000 DV9000 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/sony/vgp-bpl9.htm sony vgp-bpl9 battery http://www.batterylaptoppower.com/sony/vgp-bps10.htm sony vgp-bps10 battery http://www.batterylaptoppower.com/sony/vgp-bps8.htm sony vgp-bps8 battery http://www.batterylaptoppower.com/sony/vgp-bps8a.htm sony vgp-bps8a battery http://www.batterylaptoppower.com/sony/vgp-bps9.htm sony vgp-bps9 battery http://www.batterylaptoppower.com/acer/aspire-one-zg5.htm Acer aspire one zg5 battery http://www.batterylaptoppower.com/toshiba/pa3399u-1brs.htm Toshiba pa3399u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2bas.htm Toshiba pa3399u-2bas Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2brs.htm Toshiba pa3399u-2brs Battery http://www.batterylaptoppower.com/toshiba/pa3465u-1brs.htm Toshiba pa3465u-1brs 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