Troubleshooting
Problem
After upgrading content store to SQL server 2014 in launching studios as well as folder navigation performance decreases.
Symptom
Users see delays navigating Cognos connection folders (up to 20 seconds), as well as launching studios
Cause
With the new changes in SQL Server 2014, a setting change has been made by default to not use indexes during standard query rendering.
Resolving The Problem
To revert the default behavior to SQL 2012:
- Open SQL Server 2014 Management Studio
- Right click on the Content Store Database and select Properties.
- Under 'select a page' dialogue, click on Options.
- Change the value in compatibility level drop down to 'SQL Server 2012 (110)'.
- Starting with SQL Server 2016 it's possible to change only cardinality estimation while keeping all other improvements in place. And you can set it at database level (no need to change entire server configuration).
To set it, db admin needs to execute the following command:
ALTER DATABASE SCOPED CONFIGURATION
SET LEGACY_CARDINALITY_ESTIMATION = ON;
Related Information
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Query Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN5vAAG","label":"Installation and Configuration->Content Store"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
16 November 2021
UID
swg21971250