Significant Performance Improvements in DQS with the Cumulative Update 1 (CU1) Release for SQL Server 2012

DQS performance has significantly improved with the release of Cumulative Update 1 (CU1) for SQL Server 2012. The latest DQS Performance Best Practices Guide with the updated performance numbers and other useful information is now available on the Microsoft Download Center:

Below are the comparative DQS performance numbers between the SQL Server 2012 RTM and CU1 releases:

Data Size Discovery Cleansing SSIS Cleansing Matching
10K records 1 minute <1 minute 1 minute <1 minute 2-5 minutes <1 minutes 1 minute <1 minute
100K records 5-10 minutes 2-4 minutes 2-7 minutes 1.5-5 minutes 40-75 minutes 10-20 minutes 5-10 minutes 1-2 minutes
1M records 1.5-3 hours 30-75 minutes 0.5-1.5 hours 25-75 minutes 7-12 hours 2-3.5 hours 1-4 hours 15-60 minutes


Go update your SQL Server 2012 by installing the CU1 release from 

Also, do not forget to perform the additional steps mentioned in this article after installing the CU1 release to ensure that you can continue to use DQS after the CU1 installation: Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services.

– DQS Team



Comments (2)

  1. Michelle says:


    I've installed CU1 on the machine where I have both DQS Server and DQS client and all works well.

    I have a problem however on a workstation machine that has only DQS client installed.  After installing CU1, I'm getting funny application errors, such as "sequence contains no matching element" when trying to export a project result or an issue with parallel task processing in a data cleansing project.

    I took a wild stab and installed CU1 on the workstation machine as well but it didn't work.

    I thought about upgrading DLLs but cant find the dqsinstaller.exe application on the workstation machine.

    Any ideas?



  2. rango says:

    What is the Expected performance if we have like

    20 Domains with 5 of them having Regular Expression in it

    Composite domain with 6 internal IF Then Rules

    Running for 1 Million on 16 GB Ram Machine