Installation of SQL Performance package

Requirements for installation

Adding the licence

If the database instance is using the DEMO licence type, you can skip this step, as it is already enabled.

Right click on an instance, choose Configure instance. If you pull down the Licence list, you must make sure a licence that includes the SQL Performance package is chosen. In this case, both Demo and SQL Performance Package is valid choices. After you have made your choices, click “Save” to save changes.

Additional steps for PostgreSQL

The SQL Performance package on PostgreSQL needs some additional steps.

First, make sure you have the following settings in the postgresql.conf file.
track_activity_query_size = 2048
shared_preload_libraries = ‘pg_stat_statements’
pg_stat_statements.track = all
pg_stat_statements.max = 10000

Also in the database instance, add the extension:
CREATE EXTENSION pg_stat_statements with schema public

Installing the SQL Performance package repository job

Once the correct licence is enabled, you can install the job that collects SQL performance data for the repository.

Right click on the instance name, and chose “Configure jobs”

Scroll down to the Performance group, and select the job “SQL statistics”. If it is not available, you have not enabled the correct licence, or the platform/version is not supported. Once selected, click “Install” to install it on that instance. You should get an OK popup. Close the popup and the “Manage jobs” view.

It should now be available in the Performance group on that instance. It will run automatically every 5 minutes by default, and can be triggered manually if you right click and choose “Run”. Allow it to gather data for some time, such as one day.