Suggestion : new analysis/alerts

kevriley

Would it be possible to capture the data size of a database , as well as the data file size.

Then you could alert when a database is growing close to it's file size.

Also alert when file growth happens (auto or manual)

Certainly I would want to know if a file has been shrunk. I haven't got auto shrink on (who would), but that wouldn't stop someone manually running a shrink

Chris Spencer

Hi Kevan

I have previously raised SRP-3078 after a similar request for an alert like this (except it was for log file usage rather than data file). I'll add this particular request to that.

I believe the data size is captured and can be seen in the Cluster_SqlServer_Database_Storage_StableSamples_View view.

Regards
Chris