Can You Actually Downgrade to Standard Edition? Ask the Database First
Since SQL Server 2016 SP1, sys.dm_db_persisted_sku_features over-reports edition features. How to read it before downgrading to Standard.
Performance Counters Over Time: Making sys.dm_os_performance_counters Tell the Truth
Run this query on any SQL Server and look at the number it gives you for Batch Requests/sec:
|
1 2 3 4 5 6 7 |
SELECT [counter_name] , [cntr_value] FROM [sys].[dm_os_performance_counters] WHERE [counter_name] = N'Batch Requests/sec'; |
On a server that has been up for a few weeks you will get something like…