How do you use cloud databases? Take the survey.
Monitoring tempdb space
Please excuse me as I am not a DBA. I am responsible for a data warehouse, and our production system has gone "down" periodically due to tempdb filling up. I asked our DBAs to add me to the low space alert emails and received the following response:
From SQL Monitor: "This alert is disabled by default on [master], [model], [msdb] and [tempdb] as they are generally MBs in size and in most scenarios don't grow significantly, and on log files and [tempdb] as their growth patterns are not typically predictable based on historic growth." So, I cannot add you to the alert.
I see two types of alerts configured: the standard "Disk space" for which notifications are enabled, and a custom alert "Database free space below the preferred threshold" for which notifications are not enabled. I'm not sure what the quoted text is referring to but I would assume the standard alert. I see several alerts triggered in the past for the 2nd (custom) alert, including some for msdb; I see none for the standard disk space alert.
Our tempdb sits on a dedicated 768GB flash drive, although it is not currently configured to fill up the entire disk.
Questions: Can alerts be configured for tempdb? If so, which type of alert would be the best?
0 · Share on Twitter