December 8, 2014 at 11:04 am
I am with a dilema in using SORT_IN_TEMPDB in my indexes maintenance.
It is because I have multiple tempdb files (SQL Server 2008 R2), and I did not find any post in the internet with this specific situation.
I am sure about the pros of using SORT_IN_TEMPDB and I am also sure that I improve the performance using multiple tempdb files.
Is there any disadvantage of using both together ?
December 9, 2014 at 5:44 am
Assuming you've configured the multiple files appropriately (see all the blog posts over at SQLSkills.com on how to do this), no, there is no negative impact combining these two. If you set up tempdb appropriately, you're helping SQL Server manage tempdb. Anything, everything, that goes into tempdb from that point, gets that better management.
"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