Sample Header Ad - 728x90

Abnormal behavior in TempdB SQL Server 2019

2 votes
1 answer
256 views
enter image description hereWe have recently migrated from a version of SQL Server 2014 to a SQL Server 2019 CU 26. enter image description hereenter image description here In all our tests everything went well before performing the migration but when we made the move to production we began to have serious problems with the TempDB contention. Many processes that used tempdb blocked each other and the entire system was very slow. We have uninstalled CU 26 from SQL Server 2019 and we are with SQL Server 2019 RTM, in this case the SQL is behaving in a better way, it shows me that it is already using the TempDB datafiles and it shows me better behavior but still I have performance problems. The production database uses TempDB in almost all its processes, since it is impossible for me to rollback to the version of SQL Server 2014, is there a way for SQL to treat TempDB as it did in version 2014 when it is in a SQL Server 2019? The database engine has 12 TempDB datafiles.
Asked by Jose Navarro (21 rep)
Jul 17, 2024, 02:43 AM
Last activity: Jul 17, 2024, 07:25 PM