SQL 2016 Optimization ...
Database
1
Posts
1
Posters
1
Views
1
Watching
-
Hello, I have two SQL 2016 Always On nodes - (VMware Virtual Machines). Each node has 250GB RAM, 46 vCPU @2.5GHz. Each of the MS SQL VM is dedicated to 1 ESXi Host so there is no resource contention. The application that would connect to the Database is expected to be: 70% WRITE and 30% READ. I need advise on the best way to: (1.) Configure MS SQL nodes to use the 250GB RAM, 46 vCPU efficiently and optimally. (2.) Perform Write and Read as fast as possible using all the hardware resources. (3.) I have configured Always On Read Routing, how can I test it? Thanks.