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

Published Mar 25 2019 03:32 PM 143 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: http://www.microsoft.com/download/en/details.aspx?id=29075 .


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


Data Size Discovery Cleansing SSIS Cleansing Matching
RTM CU1 RTM CU1 RTM CU1 RTM CU1
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 http://support.microsoft.com/kb/2679368.


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: