Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended strategy is to create multiple data files, one per CPU core (logical processor), but not more than 8. Those files should be equal in size and with the same autogrowth settings. In past, this had toContinue reading “SQL Server 2016: configure TempDB during installation”
Monthly Archives: January 2016
My 2015 SQL Events
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.