Is this necessary to keep 'AutoClose' = 'On' on YF Reports DB

Mansi Sharma shared this question ago

Answered

Team YF,

We have AutoClose = "On" on reports DB while in various places on web - i read this is not good practice to keep AutoClose = On for data bases (same had been reported from our client)

http://sqlmag.com/blog/worst-practice-allowing-autoclose-sql-server-databases

My questions are :

1. Is there any specific reason, we have AutoClose = "On" for YF reports DB which can effect YF functionality?

2. Can i turn AutoClose to OFF on our production environment ?

Please let me know asap as.

Thanks,

Mansi Sharma.

The same question

Replies (1)

Mahesh Thatipamula ●

Hi Mansi,

Thanks for posting your question.

I did some research on your question and found some useful information, hope this helps.

d36c27ea58d255652b884d517083dff1

Cited from https://technet.microsoft.com/en-us/library/ms190249(v=sql.105).aspx

Auto_close value is not set by Yellowfin and it is done by default depending on your database or your database administrator.

I have checked on my system and the value is set as "False" for Auto_close.

I believe it doesn't effect Yellowfin functionality, Yes you can turn it off, but decision is to be taken by your Database administrator depending on your environmental requirements.

Please let me know if you have any questions.

Thanks

Mahe

Reply URL

Mansi Sharma ●

Thanks a lot Mahe, this really helped.

URL

Mahesh Thatipamula ●

Cheers, Thanks for letting us know.

URL