Improving Cloud Performance For Databases


Running database servers in the cloud presents several challenges, one of which is ensuring performance . A paper comparing the performance of SQL Server in its traditional and cloud versions (the latter known as SQL Database) highlights the need to adjust apps to suit the different approaches.

Database picture from Shutterstock

The cost benefits of moving to the cloud can be considerable, but that doesn’t mean there aren’t difficulties. In particular, you need to allow for the importance of recoding apps to match the performance characteristics of cloud systems:

The use of commodity hardware and servicing model in SQL Database implies that you should build commands to expect that some operations will fail and need to be retried. This requires thinking about how to split up operations into smaller chunks, avoiding long-lived temporary state, and making operations easily restartable.

Hit the link to read the full paper and further suggestions on how to tune database servers for each platform. The big lesson? As with any server migration, major planning is required.

Windows Azure SQL Database and SQL Server — Performance and Scalability Compared and Contrasted [via SQL Server Blog]


The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.

Comments


Leave a Reply