SQL 2008 R2 - Identify used Enterprise Features.

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.

more ▼

asked Mar 22, 2013 at 10:44 AM in Default

avatar image

4.5k 13 18 22

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Mar 22, 2013 at 12:51 PM

avatar image

Usman Butt
14.9k 6 13 21

I started listing all enterprise features and thinking about creating a script. But since this is really a special one time gig I threw out the question here to maybe save some time.

This is a "developer owned" server that I inherited and I will rely on their documentation including some manual double checking.

Thanks Usman for the input.

Mar 22, 2013 at 01:12 PM raadee
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 22, 2013 at 01:06 PM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

It's more of a case of helping out, the responsibility is not on me. Thank's for the sys.dm_db_persisted_sku_features tip.

Mar 22, 2013 at 02:13 PM raadee
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 22, 2013 at 10:44 AM

Seen: 1858 times

Last Updated: Mar 22, 2013 at 02:13 PM

Copyright 2018 Redgate Software. Privacy Policy