How can we help you today? How can we help you today?

Suggestion : new analysis/alerts

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
kevriley
0

Comments

1 comment

Sort by
  • 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
    Chris Spencer
    0

Add comment

Please sign in to leave a comment.