**SQLServer Enterprise Edition features detection: **
SQL Server Enterprise Edition provides datacenter capabilities with high performance, unlimited virtualization and many business intelligence tools. Sometimes it is not easy to identify if you are using any Enterprise Edition features or not.
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 dbreader/select on master and ALTER ANY EVENT SESSION. It will retun 1 if any of the bellow Enterprise Edition features are being used. ** It checks following features:
- Database level features
- Online Index Rebuild used outside DB Maintenance plan
- 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.