Restricted Enterprise edition features 2005


Job details

Name: Restricted Enterprise edition features 2005
Platform: Sqlserver
Category: Availability
Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server edition).
Long description:
Version: 1.1
Default schedule: 0 6 6 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version = ‘2005′ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’]

Parameters

Name Default value Description

Job Summary

select * from dbw_restricted_features_tab

Implementation Details

The SQL procedure involved in this job checks if the SQL Server edition is either Enterprise or Developer. It then iterates through each database, looking for specific features (VarDecimal storage and Partitioning) that are exclusive to these editions. It executes dynamic SQL commands specifically tailored to each database to check the usage of these features and consolidates this data into a table named “dbw_restricted_features_tab”.

Dependency

Job Execution Schedule

The default schedule set for this job is to run every day at 6:06 AM, which helps in daily monitoring of restricted feature usage across all checked databases.

Tables and Outputs

This job generates a report which includes:

Database Name Feature In Use Count of Feature Usage
db_name feature_name feature_count

This table lists all databases where restricted Enterprise edition features are in use, which is crucial for audit and compliance purposes.

Conclusion

The “Restricted Enterprise Edition Features 2005″ job is vital for organizations relying on SQL Server to ensure they are operating within the licensing agreements and utilizing the SQL Server capabilities efficiently across the right editions. This monitoring helps prevent potential legal issues from unauthorized use of restricted features and assists in the appropriate management of SQL Server resources.