Database Auto Close

Having SQL Server's auto close option turned on means that when it detects little activity, it will close connections to minimize computer resources. This is not advised for use on production systems since the overhead of re-establishing those connections can have a performance impact.

Suggested Action

Auto close should be disabled.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.