Suggestion : new analysis/alerts

kevrileykevriley Preston, UKPosts: 129 Gold 1
edited January 18, 2011 8:46AM in SQL Monitor Previous Versions
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

Comments

  • 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
    Chris Spencer
    Test Engineer
    Red Gate
Sign In or Register to comment.