Error when installing LiteSpeed:
"The SQL Server option 'Lightweight pooling' is enabled!
This option cannot be set when using SQL Litespeed.
Please disable this option, or use the SQL Litespeed command line"
The lightweight pooling option on SQL Server is set to 1.
The lightweight pooling option on SQL Server provides a mean of reducing the system overhead.
Lightweight pooling can provide better throughput by performing the context switching inline, thus helping to reduce user/kernel ring transitions; however, LiteSpeed is not supported when Lightweight pooling is enabled (value = 1).
Setting lightweight pooling to 1 causes Microsoft SQL Server to switch to fiber mode scheduling. The default value for this option is 0.
WORKAROUND:
The lightweight pooling option is an advanced option. Please contact the SQL Server Administrator prior to editing this configuration.
If you are using the sp_configure system stored procedure to change the setting, you can change lightweight pooling only when show advanced options is set to 1. The setting takes effect after the server is restarted.
To configure it:
sp_configure 'lightweight pooling', 0
go
RECONFIGURE WITH OVERRIDE
go
Restart SQL Server services
NOTE:
Lightweight pooling is not supported for Microsoft Windows 2000 and Microsoft Windows XP. Windows Server 2003 provides full support for lightweight pooling.
