I'm taking over dba responsibilities for the migration of an environment that the application owners are unable to give enough information on.

I need to comment on possibility of optimizing licensing cost. Having compared Enterprise and Standard edition features, the only concerns i have are for Database snapshots and TDE, both of which are only supported by Enterprise in SQL 2012.

There are snapshots in SSMS for some of the databases, but how do I know if the application is using them or not? My thoughts are that, if they are not being used then we could look at using Standard edition.

For TDE I can check that with sys.dm_database_encryption_keys.

Any thoughts to guide me will be appreciated please.

Thank you


1 Answer 1


Sql server 2012 will go out of support next year July 2022.

For more recent sql server edition key points are HA & DR features like AG.


Other good point are the index online rebuild feature, but also memory limit, read-ahead, partitions and data compression.

  • thanks for your response, that's helpful. Unfortunately at this point in time, we have to work with SQL 2012. Thanks again, all the same.
    – PTL_SQL
    Apr 29, 2021 at 2:25

Not the answer you're looking for? Browse other questions tagged or ask your own question.