Hi All,
We have recently encountered an issue within the last month or so where the tempdb system database has been growing exponentially on the server with our production impresario database on it. This has been causing problems when it gets up to 80 or more GBs.
First off, there is only about 10 MB of data in the db currently. I looked through the knowledge base and found info on where to put the database when you first set everything up, but that is not the problem. I feel like something is not quite setup the way it should be and I cannot restart the server during the middle of the day to get it to shrink.
Any help or expertise would be welcomed.
Something is causing it to grow, and it will not shrink by itself. In the db properties, you should be able to see how much Space Available there is, usually almost all of it in the caseof TempDB. If there is a danger of disks filling up, etc., TempDB can be shrunk without a restart.
Re: growth, your Autogrowth settings (db properties -> Files) might be set too high.
For all the gory details re: TempDB, please see:
https://msdn.microsoft.com/en-us/library/ms345368(v=sql.105).aspx