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. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.