This script will help you identify if you are using any Enterprise edition featuers or not, it cover majority of use case, it does not check each and every feature, but covers the most commonly used features.
**This script requires you to provide login with view server state,view any database and connect any database. It will retun 1 if any of the bellow Enterprise Edition features are being used. ** It checks following features:
- Database level features
- Read replicas of Availablity group
- Asynchronous Replica of Availablity group
- Resource Governor
- R extention
- Python extention
- Memory Optimized tempdb metadata
- more than 128G of memory
- more than 48 VCPU of CPU
- Asynchronous mirroring
**Note: Online index rebuild feature is commonly used Enterprise level feature, Please check your index jobs if you are using rebuild online index or not. Please note that it is the customers responsibility to make sure you are not using any enterprise features or not.