MS SQL Limitations
SQL Server 2019 Pricing
Editions | Open no level price (US$) | Licensing model | Channel availability |
Enterprise | $13, 748[1] | 2 core pack | Volume licensing, hosting |
Standard - per core | $3,586[1] | 2 core pack | Volume licensing, hosting |
Standard - server | $899[1] | Server[2] | Volume licensing, hosting |
Standard - CAL | $209 | CAL | Volume licensing, hosting |
Developer | Free | Per user | |
Web | See your hosting partner for pricing | Not applicable | Hosting only |
Express | Free | Not applicable |
Deprecated database engine features
MS SQL Server 2019 does not deprecate any features beyond those deprecated in the earlier releases. MS SQL Server objects and counters are used by the System Monitor to monitor the performance of SQL Server instances.
The dynamic view sys.dm_os_performance_counters
(Transact-SQL) provides all counters generated by SQL Server.
You can execute the following query to view the deprecated counters.
SELECT * FROM SYS.dm_os_performance_countersWHERE object_name = 'SQLServer:Deprecated Features';
- Build apps and APIs 10x faster
- Built-in authorization and caching
- 8x more performant than hand-rolled APIs