%3CLINGO-SUB%20id%3D%22lingo-sub-388077%22%20slang%3D%22en-US%22%3ESignificant%20Performance%20Improvements%20in%20DQS%20with%20the%20Cumulative%20Update%201%20(CU1)%20Release%20for%20SQL%20Server%202012%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388077%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Apr%2017%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EDQS%20performance%26nbsp%3Bhas%20significantly%26nbsp%3Bimproved%20with%20the%20release%20of%20Cumulative%20Update%201%20(CU1)%20for%20SQL%20Server%202012.%20The%20latest%20%3CEM%3E%20DQS%20Performance%20Best%20Practices%20Guide%20%3C%2FEM%3E%20with%20the%20updated%20performance%20numbers%26nbsp%3Band%20other%20useful%20information%20is%26nbsp%3Bnow%20available%20on%20the%20Microsoft%20Download%20Center%3A%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fen%2Fdetails.aspx%3Fid%3D29075%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fen%2Fdetails.aspx%3Fid%3D29075%20%3C%2FA%3E%20.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EBelow%20are%20the%20comparative%20DQS%20performance%20numbers%20between%20the%20SQL%20Server%202012%20RTM%20and%20CU1%20releases%3A%3C%2FP%3E%3CBR%20%2F%3E%3CTABLE%3E%0A%20%20%20%3CTBODY%3E%3CTR%3E%3CSTRONG%3EData%20Size%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20Discovery%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20Cleansing%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20SSIS%20Cleansing%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20Matching%3C%2FSTRONG%3E%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20RTM%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20CU1%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20RTM%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20CU1%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20RTM%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20CU1%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20RTM%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20CU1%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%2010K%20records%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1%20minute%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%26lt%3B1%20minute%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1%20minute%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%26lt%3B1%20minute%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E2-5%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%26lt%3B1%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1%20minute%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%26lt%3B1%20minute%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%20100K%20records%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E5-10%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E2-4%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E2-7%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1.5-5%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E40-75%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E10-20%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E5-10%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1-2%20minutes%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CSTRONG%3E%201M%20records%20%3C%2FSTRONG%3E%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1.5-3%20hours%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E30-75%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E0.5-1.5%20hours%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E25-75%20minutes%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E7-12%20hours%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E2-3.5%20hours%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E1-4%20hours%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E15-60%20minutes%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%3C%2FTBODY%3E%3C%2FTABLE%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EGo%20update%20your%20SQL%20Server%202012%20by%20installing%20the%26nbsp%3BCU1%20release%20from%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2679368%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2679368.%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EAlso%2C%20do%20not%20forget%20to%20perform%20the%20additional%20steps%20mentioned%20in%20this%20article%20after%20installing%20the%20CU1%20release%20to%20ensure%20that%20you%20can%20continue%20to%20use%20DQS%20after%20the%20CU1%20installation%3A%20%3CA%20href%3D%22http%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F8442.upgrade-dqs-installing-cumulative-updates-or-hotfix-patches-on-data-quality-services-en-us.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Upgrade%20DQS%3A%20Installing%20Cumulative%20Updates%20or%20Hotfix%20Patches%20on%20Data%20Quality%20Services%20%3C%2FA%3E%20.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E-%20DQS%20Team%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-388077%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2017%2C%202012%20DQS%20performance%26nbsp%3Bhas%20significantly%26nbsp%3Bimproved%20with%20the%20release%20of%20Cumulative%20Update%201%20(CU1)%20for%20SQL%20Server%202012.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecu1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20quality%20services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edqs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eperformance%20enhancements%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql%20server%202012%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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