An article Data files: To Autogrow Or Not To Autogrow? recommends NOT to rely on auto-grow, because it causing delays in unplanned times.We should mtonitor database files(both data and log), and if they close to max capacity, manually increase the size.
However it doesn't give references, how to monitor the free space inside databases.
I've tried to look how to do it.
It can be done manually using execute sp_spaceused
for the database in question or
(can be downloaded from
posted @ Sunday, September 30, 2012 11:44 AM