We are seeing an issue with our SQL 2012 tempdb folder reaching enormous sizes (691GB) which in turn we are relating to the server maxing the available RAM. Performance degraded to the point of production machinery dropping connections to the SQL server due to timeouts.
I was able to reboot the server which dumped the cache I'm guessing and everything is working properly for now.
How can we identify what is causing the tempdb to grow so big?
How do we eliminate this issue from happening again?
By default, is there not a default aging for the data in the tempdb?