tuning

Did You Really Just Spend Thousands on New Hardware?

Did You Really Just Spend Thousands on New Hardware?

Seriously? You did what now? OK, I’m sure it’s all shiny and new and takes up less space in your data center. That sounds wonderful, truly. But did you try anything else before agreeing to spend money like a sailor on shore leave? I’m here today to help you understand your performance tuning options before(…)

SQL 2012 Database Engine Tuning Advisor: Now With More Plan Cache!

I’m normally not one to advocate the use of the Database Engine Tuning Advisor (DETA), a tool available inside of Microsoft SQL Server. (To be fair, I’m not a fan of the SQL Tuning AdvisorĀ from Oracle, either.) But I recently came across a little nugget of information that I wanted to share with you regarding(…)