Threads vs. fibers in MS SQL 7. : LUSENET : SQL Server Database Administration : One Thread

Does anyone has experience in using fibers instead of threads? Does it relay increase performance? Thanks

-- Anonymous, March 14, 2000



If your overall CPU utilization is more than 70%-80% (across all CPUs) you may see some improvement using fibers. Benchmark testing in saturated environments shows that use of fibers (that is, lightweight pooling = 1 in sp_configure) provides a 7 to 10% increase in throughput.

This is what TPC-C folks all use on SQL 7.0, so it might also work for you.

Good Luck,


-- Anonymous, March 14, 2000

Moderation questions? read the FAQ