New System Configurations In SQL Server 2022

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 on 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.