MS-SQL Server - Lightweight Pooling & New Standard Edition

Lightweight Pooling & New Standard Edition

Lightweight Pooling.
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/lightweight-pooling-server-configuration-option?view=sql-server-ver16

2022 Standard Edition
https://www.microsoft.com/en-in/d/sql-server-standard-2022/dg7gmgf0m80j?activetab=pivot:overviewtab

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver16

Additionally,

Trace Flag 634
Disables the background columnstore compression task. SQL Server periodically runs the Tuple Mover background task that compresses columnstore index rowgroups with uncompressed data, one such rowgroup at a time.

Columnstore compression improves query performance but also consumes system resources. You can control the timing of columnstore compression manually, by disabling the background compression task with Trace Flag 634, and then explicitly invoking ALTER INDEX...REORGANIZE or ALTER INDEX...REBUILD at the time of your choice.

Database Errors...

Any query will be considered.

T. Amit Vaid S.