Hi Deepak,
Thank you for your timely article.
I have no experience of Azure but we have been asked to look at the possibility of moving some of our SQL2008 databases to Azure instead of replacing the server in our datacentre. Given that overnight processes like DBCC CHECKDB and BACKUP consume a lot of resouces, do you think we should only capture metrics during the working day or should we capture metrics for a full 24 hour period?
Thanks.