research Question
number of database can be host by SQL 2019 enterprise AG
Hi,
We have 2 x SQL 2019 enterprise database connect to each other using linked server and query get data between them IN ORDER TO balance the loading, it not a good method as query thought linked server is ALWAYS slow.
now each server host 25x user database on AWS and user report it is slow from time to time suddently, o we
if I combine 2 x SQL server to single SQL server 2019 always on while running in SQL 2017 compatibility mode, is one single SQL server 2019 AG can operate 500 user database while sync with other peer ?
I just plan to have 2 x sync SQL node at this moment and separate read and write operation can be spilt between nodes.
or what is other way you can suggest and I will also look at how to tune SQL server in AWS.
we are also considering to upgrade AWS instance type as recommended by Amazon.
We have 2 x SQL 2019 enterprise database connect to each other using linked server and query get data between them IN ORDER TO balance the loading, it not a good method as query thought linked server is ALWAYS slow.
now each server host 25x user database on AWS and user report it is slow from time to time suddently, o we
if I combine 2 x SQL server to single SQL server 2019 always on while running in SQL 2017 compatibility mode, is one single SQL server 2019 AG can operate 500 user database while sync with other peer ?
I just plan to have 2 x sync SQL node at this moment and separate read and write operation can be spilt between nodes.
or what is other way you can suggest and I will also look at how to tune SQL server in AWS.
we are also considering to upgrade AWS instance type as recommended by Amazon.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.