research Question

number of database can be host by SQL 2019 enterprise AG

Avatar of marrowyung
marrowyung asked on
DatabasesMicrosoft SQL ServerAWSAWS RDS
9 Comments2 Solutions22 ViewsLast Modified:
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.



ASKER CERTIFIED SOLUTION
Bembi
CEO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros