Statistics migration


Job details

Name: Statistics migration
Platform: Sqlserver
Category: Compliance
Premium package: Migration EM12 to CC
Description: Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC.
Long description: Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC.
Version: 1.4
Default schedule: 0 16 1 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005′ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
copy statistics NO If set to YES the procedure will copy history data from dbWatch 12 engine to dbWatch CC engine.
dbWatch12 engine AUTO Name of dbWatch 12 engine to copy statistics from. If set to AUTO (default value) the procedure will find automatically the last in use dbWatch engine.

Job Summary

SELECT * FROM dbw_statistics_migration_info;
SELECT * FROM dbw_migration_db_info;
SELECT * FROM dbw_migration_checkhistrcc;

Key Operations

Dependencies Overview

Dependency Object Cleanup on Fail Description
dbw_statistics_migration_proc True Main procedure for the migration process.
dbw_statistics_migration_info True Information table for migration data details.
dbw_migration_db_info True Stores last task execution details.
dbw_migration_dml True Contains DML operations for migration.
dbw_migration_param12 True Parameters from dbWatch 12 for migration.
dbw_migration_paramcc True Parameters needed for migration in dbWatch CC.
dbw_migration_checkhistr12 True History of alerts to migrate from version 12.
dbw_migration_checkhistrcc True History of alerts that need to be migrated to CC.

Migration Implementation Details

Reporting and Monitoring

Job Scheduling and Execution