Post reply

.ndf size alert

  • March 15, 2012 at 3:05 am

    #257950

    Hi,

    Is there any way of getting an alert when an NDF file reaches a certain % of free space? We have an issue where one of our databases doesn't like to grow its NDF files (which in itself is a different issue) properly, so we get users being kicked out and unable to access the database. Is there a way of getting an alert so that if an NDF reaches a certain size or % free space, we can go in and bump up the file size?

    I've had a look at performance monitor, but that only seems to monitor the whole database size, not the individual NDF files.

    Thanks

  • March 15, 2012 at 3:10 am

    #1459690

    you could create a policy against the data file facet for the avilable space properties and have it alert you via email

    you will need db mail setting up and SQL agent alert system set to use DBMail

  • March 15, 2012 at 3:18 am

    #1459693

    Thanks for that - I'll give that a whirl

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply