Threads vs. fibers in MS SQL 7.greenspun.com : 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
Igor,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,
Eric
-- Anonymous, March 14, 2000