Performance issues after installing the Application and Change Control extension

Technical Articles ID: KB90092
Last Modified: 12/11/2019

Environment

McAfee Application and Change Control (MACC) 8.0.x - 8.1.x
McAfee ePolicy Orchestrator (ePO) 5.9.x

Microsoft SQL Server (SQL)

Problem

SQL and ePO experience performance degradation when queries or data retrieval requests are made. This performance degradation begins after you install the MACC extension.

Cause

The application sets the sendStringParametersAsUnicode property to "false" and uses a non-national character method to access server-side Unicode data types. Non-national characters such as yoNCHAR, NVARCHAR, and NTEXT are used. This action can result in data loss if database collation does not support characters in the String parameters passed by the non-national character method.

Solution

This issue is resolved in the MACC 8.1.1 extension update. Database performance is now optimized. For further information, see the MACC 8.1.1 Release Notes.

Workaround

The attached files correct data type issues that cause performance degradation. Follow the steps below when working with the SQL script files attached to this article:

Stop all ePO services.
Run the get_column_type_from_scor_tables.sql on the ePO database.

If no results are returned, stop. This article does not address your issue.
If results are returned, run SQL_Performance_Data_Type_Issues.sql to improve performance.

Run get_column_type_from_scor_tables.sql on the ePO database and verify that no results are returned.
Restart the ePO services.

NOTE: Make sure that you have backed up your database before you apply the SQL script.

Attachment 1

get_column_type_from_scor_table.sql
245Bytes • < 1 minute @ broadband

Attachment 2

SQL_Performance_Data_Type_Issues.sql
42K • < 1 minute @ broadband

Affected Products

Application and Change Control 8.1.x
Application and Change Control 8.0.x

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Portuguese Brasileiro

Knowledge Center

Performance issues after installing the Application and Change Control extension

Environment

Problem

Cause

Solution

Workaround

Attachment 1

Attachment 2

Affected Products

Languages:

Title

Title

Knowledge Center

Performance issues after installing the Application and Change Control extension

Environment

Problem

Cause

Solution

Workaround

Attachment 1

Attachment 2

Affected Products

Languages:

Choose your region

Title

Title