Inordinately High CPU utilization on SQL server housing Control Compliance Suite (CCS) databases

Products

• Control Compliance Suite Windows

Cause

Compatibility mode on SQL server is incorrectly set.

 

Environment

CCS 11.x and 12.x

 

Resolution

Control Compliance Suite requires an SQL database compatibility mode level of 100.

Use SQL Management Studio to connect to the SQL server(s) that house the CSM_DB and CSM_Reports databases.  Go to the Properties on the Database and the advanced settings where you can change the compatibility mode to level 100 (SQL 2008 R2 level).

Changing this setting and restarting the SQL server services should result in CPU utilization reductions.