This question that I contributed is a part of the ongoing SQL server Quiz 2011. To take part, please go to: http://beyondrelational.com/quiz/sqlserver/dba/2011/questions/186/which-are-the-options-available-to-a-dba-to-tune-a-sql-azure-database.aspx
The idea behind this question is two-fold:
1) To spread awareness that with SQL Azure we do need to tune the databases – that part does not go away. Though many of the tasks are offloaded to cloud, the fact is, if you write a bad query – it’s going to run bad on the cloud too. yeah, It’s that simple!
2) To learn what “tools” do we have as a DBA to tune those bad running queries.
So yeah, go ahead and send what you think at http://beyondrelational.com/quiz/sqlserver/dba/2011/questions/186/which-are-the-options-available-to-a-dba-to-tune-a-sql-azure-database.aspx and ALL the best for the Quiz and it’s results! May you walk away with Apple iPad given by Redgate – it’s an awesome prize!
And I would thank Jacob sir for inviting me as a Quizzer (Now I have a badge on my beyond relational profile!) for this wonderful Quiz he runs! Thanks sir.
And all the best for Quiz again. Have fun!
we can’t tune sql azure, can we? curious.
How does an azure question appear in sql server quiz? not clear.