Anybody got a script och easy method to identify Enterprise Features that are used in a instance?
Background, customer want's to downgrade from one Enterprise Server to two standard servers.
asked Mar 22, 2013 at 10:44 AM in Default
I guess the number of features and their usage makes so many combinations that it would be very hard to cover it fully. Yes, there could be some bunch of scripts which could help you cover some For e.g. If the count of the CPUs used are more than then Enterprise feature used otherwise not used. If the Memory in use is more than 64 GB then Enterprise else not etc. etc. So IMHO, if you can extract all the information against the features available in this BOL link Features Supported by the Editions of SQL Server 2008 R2 and start omitting/marking features against Standard/Enterprise editions, you will be able to cover it comprehensively. Last thing you want is to use some script and find out that an Enterprise feature is require after moving to Standard edition. Moreover, I think if you are going to have two servers, then testing your application/databases could be more easier as you can plan things better.
I know it would be a laborious work but sometimes there is no better alternative. Just my two cents.
answered Mar 22, 2013 at 12:51 PM
You are absolutely going to have to dig, and dig hard, to identify every possible use of enterprise features. And no, I don't know of any method that's going to automate that for you. You can get a little help from sys.dm_db_persisted_sku_features which will show you storage mechanisms that will prevent the shift. But you've still got to go through all the code and structures within the database.
answered Mar 22, 2013 at 01:06 PM
Grant Fritchey ♦♦