How can I check whether I can downgrade from SQL Server Enterprise 2016 to SQL Server Standard?

Eric Mamet (MSDN) 6 Reputation points
2021-01-20T13:13:43.787+00:00

I have a SQL Server Enterprise license for a system which I "think" does not need that.

Is there a way to check that I am not using features only available in SQL Server Enterprise?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,895 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Shashank Singh 6,246 Reputation points
    2021-01-20T14:17:21.65+00:00

    Is there a way to check that I am not using features only available in SQL Server Enterprise?

    Yes, please run below query in all the user databases. If it returns a row this means for that database, the mentioned feature in the output if bring used.

    select * from sys.dm_db_persisted_sku_features

    2 people found this answer helpful.

  2. Eric Mamet (MSDN) 6 Reputation points
    2021-01-22T16:38:48.667+00:00

    It seems very useful and it reports nothing on the server I want to downgrade.

    However, it reports something on a server that currently runs SQL Server Standard...?

    SELECT @@VERSION;  
      
    select * from sys.dm_db_persisted_sku_features;  
    

    Gives me this result...

    59637-sql-server-downgrade.png

    Should I be worried?

    Thanks