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:
|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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.