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......
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More