Create 500MB temp 1171 seconds 1544 seconds 24.16% table containing LOB data and cursor through all rows for a string value Create a populate 3 706 seconds 896 seconds 21.21% separate 1200MB Temp Tables Create 200MB table and 53 seconds 103 seconds 48.55% use to populate two 225MB LOB tables via JOIN then SELECT Create 256MB table and 462 seconds 575 seconds 19.66% use to populate two 200MB LOB tables via JOIN then SELECT Create 256MB table and 548 seconds 576 seconds 4.87% use to populate two 350MB LOB tables via JOIN then SELECT Disk Metric Fusion-IO SAS Performance Delta Avg. Logical Disk .09 12.36 99.28% Length (Total) Avg. Logical Disk Queue 7.31 276.13 97.36% Length (initial 1000 seconds) Avg. Logical Disk Queue 0.01 1.66 99.40% Length (remaining seconds) Cumulative seconds 90 300 70.00% where avg disk queue length exceeded 32
Create 500MB temp table containing LOB data and cursor through all rows for a string value 1171 seconds 1544 seconds 24.16% Create a populate 3 separate 1200MB Temp Tables 706 seconds 896 seconds 21.21% Create 200MB table and use to populate two 225MB LOB tables via JOIN then SELECT 53 seconds 103 seconds 48.55% Create 256MB table and use to populate two 200MB LOB tables via JOIN then SELECT 462 seconds 575 seconds 19.66% Create 256MB table and use to populate two 350MB LOB tables via JOIN then SELECT 548 seconds 576 seconds 4.87% Disk Metric Fusion-IO SAS Performance Delta Avg. Logical Disk Length (Total) .09 12.36 99.28% Avg. Logical Disk Queue Length (initial 1000 seconds) 7.31 276.13 97.36% Avg. Logical Disk Queue Length (remaining seconds) 0.01 1.66 99.40% Cumulative seconds where avg disk queue length exceeded 32 90 300 70.00%