SentryOne Team Blog (

Tag: tempdb

Paul White : SQL Server Temporary Object Caching

Paul White : SQL Server Temporary Object Caching

Paul White (@SQL_Kiwi) describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

Paul White : The Sort that Spills to Level 15,000

Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.

Investigate TempDB Like Sherlock Holmes

Richard Douglas (@SQLRich) shares the slides from his recent session at SQL Saturday Exeter, "Investigate TempDB Like Sherlock Holmes."

Instant File Initialization : Impact During Setup

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.

SQL Server 2016 : Getting tempdb a little more right

Aaron Bertrand (@AaronBertrand) explains how SQL Server 2016 improves tempdb configuration and performance, and how there is still room for improvement.