Restricted Enterprise edition features (2000)
Job details
| Name: | Restricted Enterprise edition features (2000) |
| 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 = ‘2000′ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’] |
Parameters
| Name | Default value | Description |
|---|
Job Summary
- Purpose: The purpose of this job is to identify and report the use of SQL Server features that are restricted to the Enterprise or Developer editions in databases operating under SQL Server 2000 edition.
- Why: This job is critical as it helps in compliance and optimization of SQL Server features in different editions. Use of enterprise features in non-enterprise environments can lead to violations of licensing agreements or result in unplanned upgrade costs.
- Manual checking: You can check this manually in the SQL Server database through the following SQL commands:
SELECT * FROM dbw_restricted_features_tabJob Details
This section breaks down the key components and functionalities of the dbWatch job.
Task Description and Dependencies
The task, “Restricted Enterprise edition features (2000)”, aims to detect any restricted features being used in SQL Server instances that are not categorized under Enterprise or Developer editions. It specifically targets SQL Server 2000 instances.
- Dependencies:
- This task depends on itself and an additional table, “dbw_restricted_features_tab”, which holds the data about databases using restricted features.
- There is a contingency in place to clean up on failure, ensuring the integrity and cleanliness of data in case the task does not execute as expected.
Database Implementations
The database implementation section contains SQL scripts required to support the task execution:
- Tables and Procedures:
- A table creation script for “dbw_restricted_features_tab” which includes columns for database name, feature name, and feature count.
- A stored procedure named “dbw_restricted_features_2000″ builds and queries dynamic SQL statements to populate the “dbw_restricted_features_tab” based on feature usage indicators.
Report Generation
The task is linked to a reporting template that details how the output should be formatted and what information should be included:
- Report Title: “Restricted features”
- Details included in the report:
- The report comprises a presentation section titled “Restricted Enterprise edition features in use”, which displays a table containing the names of databases, the features in use, and a count of these features.
- The table is generated by “select * from dbw_restricted_features_tab” SQL command.
Scheduling
- Recommended default scheduling for the job is configured to run once each day at 6 minutes past 6 AM.
- The reporting template is set to refresh every hour.
Version and Provider
- Version: 1.1
- Provided by: dbwatch.no
This structured, automated monitoring process serves to assist database administrators in managing SQL Server 2000 instances effectively, ensuring compliance with SQL Server edition capabilities and license restrictions.