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

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

Rate This
  • Comments 1

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 SizeDiscoveryCleansingSSIS CleansingMatching
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

 

 

Leave a Comment
  • Please add 5 and 6 and type the answer here:
  • Post
  • Hi

    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?

    Thanks

    Michelle

Page 1 of 1 (1 items)