June 7, 2011 at 8:44 am
I am trying to quantify performance differences of using one collation over another, specifically Latin1_General_BIN vs. SQL_Latin1_General_CP1_CI_AS. The former should be faster since it uses a binary sort, but does anyone know how I can explicitly quantify that? Possibly a query that would reveal the differences in duration or something to that effect?
Thanks,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
June 7, 2011 at 9:39 am
Basically, I'd set up two, identical databases with the two different collations and then run a set of queries against each database, one at a time, capturing a full set of performance metrics and query execution times and compare the results. I'd be surprised if you saw a radically different performance from one collation to the next, but it's a set of test data I'd be interested in seeing. Just make sure that you configure the loads in the same way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply