I have two databases. One I'd like to set up in an availability group between two servers (two instances, one on each server). The database is not huge and I'm not expecting it to grow exponentially. We'd like to utilize local storage for this database for performance reasons as it is a high usage OLTP database.
The second database would be on additional instances across the same two servers but I need to utilize shared storage because we are expecting this database to grow exponentially. Our SAN is not designed for high I/Os and this database does not need the I/Os. I'd like to use SQL Failover Clustering and keep this database on the SAN and take advantage of some High Availability. Both of these databases need High Availability.
Is it possible to have two SQL instances on the same windows failover cluster with one instance using always on (no SQL failover cluster), and the second instance belonging to a SQL failover cluster?