We have an OLTP database (running SQL Server 2008 R2) that has 6 tempdb files.
All of them have an Autogrowth by 10%, restricted growth to 10000mb. At one point, someone changed one of the growths to restrict by 120000mb which caused that tempdb file to grow exponentially larger than the others. We are trying to track down when this change could have occurred.
Is it possible to see, either, when a setting was changed or a history of tempdb growth?
One issue is that the issue has been fixed and the tempdb file is back down to normal size.