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:
| 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: http://social.technet.microsoft.com/wiki/contents/articles/8442.upgrade-dqs-installing-cumulative-updates-or-hotfix-patches-on-data-quality-services-en-us.aspx .
- DQS Team
