Post reply

"Best practices" for creating an Azure Sql VM?

  • July 11, 2015 at 7:34 am

    #318968

    We needed to run an earlier sql version (sql 2008) in an Azure VM so we used an OS image and installed sql 2008 in the Guest ourselves. Then we added "E" and "F" drives to the Guest, from the Portal, for data and log files. It's great fun creating a VM in this manner but I'm concerned if the described approach is "suboptimal". in other words, is there a "best practices" document for creating Azure Sql DBs?

    TIA,

    bd

  • July 13, 2015 at 2:54 pm

    #1812141

    Hi Barking Dog,

    Your configuration should work well. An article outlining Best Practices is posted here.

    Hope this helps,

    Andrea

  • July 14, 2015 at 2:03 am

    #1812217

    Don't expect blazing fast IOPs... still, very handy having some VMs in the cloud.

    EDITED. Just seen the G series VMs.

  • October 8, 2015 at 6:25 am

    #1832265

    And you can specify Premium SSDs if you spin up your VM in a region that supports them (eg: Western Europe)

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

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