From what I understand the system database is used to hold temporary tables, intermediate results and other temporary information.
On one of my database instances I have a tempdb that is seems very large (30GB). This database has not been modified (as in "last modified date" on the mdf file) in over a week. Is it normal to have the temp db remain that large for that long of a period? It seems to me that it should be updating fairly often and returning space that it is using fairly quickly...
Am I way off here or is SQL Server doing something weird?
FYI: This is a SharePoint 2010 database, not sure if that makes a difference.
Martin, your query returns the following:
usr_obj_kb|internal_obj_kb| version_store_kb| freespace_kb | mixedextent_kb 6272 |1984 | 64 | 30418048 | 4416