Solved!
Go to SolutionTT
Todd.Thornhill
2 Posts
0
14908
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
Todd.Thornhill
2 Posts
1217
0
Posted 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
4 Apprentice
•
2843 Posts
1217
0
Posted July 30th, 2015 09:00
thanks Todd. Sending along.
Regards,
Rob
DELL-Rob C
4 Apprentice
•
2843 Posts
1217
0
Posted 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