mrixon

Deleting QOS Metrics

Discussion created by mrixon on Aug 13, 2009
Latest reply on Aug 13, 2009 by mrixon
Hi,
I have an install that set the days to keep raw data to 360 (default) and 8 months later I am trying to shrink it. I set the days to keep raw data back to 60. The database is 62GB before and there is 46GB free.  The nightly maintenance operation failed and most of the free space was consumed, which is likely why it failed. The DB grew to 82GB and the LDF file was 24GB. It went into recovery mode and I had to shrink it manually. Does anyone know how much free space you need to complete this process? Equal to the size of the existing DB? Is there a SQL setting I missed to keep the LDF file smaller?

Thanks,
Mike

Outcomes