Significant Performance Improvements in DQS with the Cumulative Update 1 (CU1) Release for SQL Server 2012
Published Mar 25 2019 03:32 PM 189 Views
Not applicable
First published on MSDN on Apr 17, 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

Version history
Last update:
‎Mar 25 2019 03:32 PM
Updated by: