Brand New
Here are new sys.configuration entries in SQL Server 2022:
+------------------------------------+-------------------------------------------------------------------------------------+ | name | description | +------------------------------------+-------------------------------------------------------------------------------------+ | Data processed daily limit in TB | SQL On-demand data processed daily limit in TB | | Data processed weekly limit in TB | SQL On-demand data processed weekly limit in TB | | Data processed monthly limit in TB | SQL On-demand data processed monthly limit in TB | | ADR Cleaner Thread Count | Max number of threads ADR cleaner can assign. | | backup compression algorithm | Configure backup compression algorithm | | hardware offload config | Offload processing to specialized hardware | | suppress recovery model errors | Return warning instead of error for unsupported ALTER DATABASE SET RECOVERY command | | openrowset auto_create_statistics | Enable or disable auto create statistics for openrowset sources. | +------------------------------------+-------------------------------------------------------------------------------------+
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.