Top 10 SQL Server Performance Tuning TipsCommented on: 3 years ago
(March 11, 2011)
Great article! You covered some key areas that frequently get missed, any one of which could be "the problem". Also nice to see the Waits & Queues whitepaper reference at top......
When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More