We have 2 SQL 2012 servers. Our application has 2 databases. We are creating it to where it is an AlwaysOn cluster. Is it good to create 2 AlwaysOn clusters to have one database primary server on one of the servers and the other database primary server on the other server? I have been asked if it is possible to have one database running on one server and the other database on the other. Is this possible without creating 2 separate AlwaysOn clusters? Is this a good idea to do this?
If you want to acheive some load balancing then you can have your primary databases on different servers. Just remember that if a failover occurs to the second node, then you need to have enough hardware/resources to run both workloads on the same server.