Sorry of the newbie question, but I'd thought I'd seek the opinion of you gurus.
I have tempdb on a production DB Server which I suspect is quite heavily used.
According to the Disk Usage report the Data Files Space Usage show as 100% Unallocated. Which is seem a bit strange.
Also prior to me increasing the disk space on the drive where the tempdb.mdf sits. Its a strange thing. Somehow someone has initial Size of the tempdb.mdf file to be 71GB on a drive that was only 70GB.
This came to my attention that the drive only had 10MB free until I increased it.
The disk usage report on the DR sql Mirror for temp seems "fine" with the percentage distributed among Index, Unallocated, data and Unused.
What's your thoughts about tempdb in a production DB server being 100% unallocated, does that seem strange? Would I plan a restart of sql server to recreate tempdb?