Highlighted
Todd.Thornhill
1 Copper

OME Remote Database Enables AUTO_SHRINK

Jump to solution

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions

RE: OME Remote Database Enables AUTO_SHRINK

Jump to solution

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

DELL-Rob C
Social Media Support
#IWork4Dell

0 Kudos
3 Replies

RE: OME Remote Database Enables AUTO_SHRINK

Jump to solution

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

DELL-Rob C
Social Media Support
#IWork4Dell

0 Kudos
Todd.Thornhill
1 Copper

RE: OME Remote Database Enables AUTO_SHRINK

Jump to solution

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

0 Kudos

RE: OME Remote Database Enables AUTO_SHRINK

Jump to solution

thanks Todd. Sending along.

Regards,

Rob

DELL-Rob C
Social Media Support
#IWork4Dell

0 Kudos