Identifying the right Service tier for Azure Database

• Deepak Prasad Sahu

  Ten Centuries

  Points: 1091

  September 20, 2018 at 12:04 am

  #368346

  Comments posted to this topic are about the item Identifying the right Service tier for Azure Database

• Ken McKelvey

  SSCoach

  Points: 18231

  September 20, 2018 at 5:08 am

  #2006402

  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.

• Deepak Prasad Sahu

  Ten Centuries

  Points: 1091

  September 21, 2018 at 2:59 am

  #2006526

  Welcome Ken!
  I would suggest to run the data collector for 3 to 4 different time frames for at least 2 to 3 hours each time.Also try to identify the peak hours for the database transactions and schedule to capture metrics in those hours to get the closest results.
  Please let me know if it answers your questions.

  Thanks,
  Deepak.