I have a SQL Server 2008 R2 Standard Edition database for which I have configured the ROWS
(.mdf) database file with autogrowth ON
and set to max size to 10GB.
After a while, I get an alert that my tempdb log has filled a drive. I figure that my database's size is stuck on the limit at 9990MB or something, unable to extend any further.
Are those two things possibly related? Would the database, being unable to expand, store its transactions in tempdb?
What happens when a database ROWS
file gets filled and someone keeps adding data to it?
The data was coming from SQL Server performance data monitoring: