Rebuild Very Large Primary Key Index

September 2, 2017 Andy 0

Question I have a SQL database that is hosted on Azure. The problem is that the size is getting out of control, I can see up to 99% fragmentation in the Primary Key clustered indexes. I’m able to rebuild all other indexes with online=on option … [Read More]

Load balancing reads SQL Server 2016 AG

April 19, 2017 Andy 0

Question I’m trying to balance read traffic between two SQL Server 2016 Enterprise Edition instances (Primary and Secondary) using availability groups and the read only routing. Here is my current setup: The servers are in AWS in two different AZ The servers are in a … [Read More]