FAQ - Server Install

Question
Supported SQL Server settings and contact support message
Answer

If certain database settings become changed, it may lead to Ava performing in a sub optimal way. Ava currently supports all editions of SQL 2005, SQL 2008, SQL 2008R2 and SQL 2012. Depending on the install route your server has taken, there are now variations in settings that occur because of installation in different environments.

If any non optimum setting are detected then Ava PA will display a message when it starts. The following is an example, the exact message may change.

Microsof SQL server Management Studio message.png

Please arrange a support call.

In SQL Server Management Studio if you right click on the (relevant) database node

Microsof SQL server Management Studio.png

On the options tab:

Microsof SQL server Management Studio 2.png

The following settings are supported:

If you do not have a backup of log files, then recovery model must be set to simple.

The compatibility level must be 90, 100 or 110

Auto close should be false

Auto create statistics should be true

Auto shrink should be false

Auto update statistics should be true

Please do not change any other settings without consulting Ava support.

If you found this information useful, please share it!


This FAQ was last updated on Wednesday, September 30, 2015

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...