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
