Event ID - 8149

Event Id8149
SourceMSSQLServer
DescriptionOLE Automation objects are not supported in fiber mode.
Event InformationCAUSE:
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 LinksMicrosoft 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.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.