This post is more than 5 years old
2 Posts
0
14843
July 29th, 2015 00:00
OME Remote Database Enables AUTO_SHRINK
When installing OME 2.0.1 I specified a remote database on a 2012 SQL server. It has been working fine but recently some monitoring set up on the SQL server has sent a warning the database needs to be checked as AUTO_SHRINK is on and Microsoft best practice is to turn this "feature" off.
Will disabling AUTO_SHRINK have any impact on OME?
Thanks.
-Todd
No Events found!
DELL-Rob C
2 Intern
•
2.8K Posts
0
July 29th, 2015 10:00
Hi Todd, thanks for the post.
Changing that setting will not have an impact on OME.
OME run periodic maintenance (see the OME preferences/settings) and takes care of database optimizations that are relevant for OME performance.
Regards,
Rob
delltechcenter.com/ome
Todd.Thornhill
2 Posts
0
July 29th, 2015 23:00
Cheers Rob, Thanks for the confirmation.
Please pass this on to the dev guys to disable this "feature" at install time in the next release.
Thanks,
-Todd
DELL-Rob C
2 Intern
•
2.8K Posts
0
July 30th, 2015 09:00
thanks Todd. Sending along.
Regards,
Rob