ApplicationHA 6.1, ESXi 5.5 and SQL 2012 problems

Hi Lee,

What is the name of the customer?

Regarding the issue you are facing i.e. the service does not shutdown properly:

This is because the IMF feature was ON for the SQL Service monitoring agent of AppHA.

IMF feature helps an AppHA monitoring agent to detect the state change of the monitored component very quickly (almost instantly).

In this particular case:

SQL has a feature to restart SQL server (or SQL server agent) in case it stops unexpectedly.

We have made IMF compatible with this feature:

                If SQL IMF detects that SQL server has gone down it will read the SQL setting and restart service in case Auto restart is set to true.

And that's was happening here. The AppHA agent tries to restart the agent as soon as it detected that SQL service went down (while the service was still going down via the SCM).

To avoid this situation, you can disable the feature of SQL.

Steps to disable SQL auto restart:

1.Ensure SQL server and SQL Server Agent services are running

2.Launch SQL server management studio and connect to localhost

3.Expand localhost node and right click on “SQL Server Agent” node and select “Properties”

4.Uncheck the check boxes –

a.Auto restart SQL server if it stops unexpectedly

b.Auto restart SQL server Agent if it stops unexpectedly

5.Click OK

[Check the attached screenshot] 

For SQL monitoring agent to pick-up/refresh this new setting, do the following:

1.Stop VCS:

hastop -local -force

2.Start VCS:

hastart