question

Bsthomas0327 avatar image
Bsthomas0327 asked

AlwaysOn Server application has 2 databases.

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?
sql2012high-availabilityclusters
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
raadee avatar image
raadee answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.