It was my first day as the newly hired database administrator. My name is Sam, and I was ready for a gentle start — maybe some HR orientation, a fresh coffee, and a peek at the shiny new monitoring dashboards. But databases have a way of laughing at your plans.
Just as I found my seat, Manager Mike popped up with a worried look. “Sam, I know it’s your first day, but our production DBA is out on emergency leave. The customer’s app is down — can you take a quick look?”
So much for easing into the role.
I logged into the server, half-expecting it to be something small. But the error log told a different story. It was full of “could not allocate space” errors. TempDB had filled up overnight, and the system was practically choking.
I opened SSMS and checked the tempdb settings — someone had set the autogrowth to 1MB increments, with a maximum file size of 100 GB. Meanwhile, the TempDrive still had 70% free space!


