| Event Id | 8149 |
| Source | MSSQLServer |
| Description | OLE Automation objects are not supported in fiber mode. |
| Event Information | CAUSE: Fiber mode, also known as lightweight pooling, is not a supported SQL Server configuration option if you use OLE Automation objects. By default, SQL Server uses one thread per active SPID or user process. These threads work in a pooled configuration to keep the number of threads manageable. The advanced configuration option lightweight pooling (which is sometimes referred to as "fiber mode") uses Windows NT "fiber" support to handle several execution contexts with a single thread. You do not need to use fiber mode except in very rare circumstances. Lightweight pooling is only even potentially useful if all of the following conditions are met. You still must determine if it is actually useful through careful controlled testing: Large multiprocessor servers are in use. All servers are running at or near maximum capacity. A lot of context switching occurs (greater than 20,000 per second). RESOLUTION: Turn off the lightweight pooling option. 1. exec sp_configure show advanced, 1 2. RECONFIGURE 3. exec sp_configure lightweight pooling, 0 3. RECONFIGURE WITH OVERRIDE The setting takes effect after stopping and restarting the SQL Server instance. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 8149 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.