Post reply

Identifying the right Service tier for Azure Database

  • 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

  • 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.

  • 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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply