You can now get an insight into SQL Azure performance and elasticity by just downloading a free resources "Microsoft SQL Azure Performance and Elasticity Guide" offered by Microsoft Cloud services through the software giant's Download Center to all customers.
"This guide focuses on optimizing performance of SQL Azure applications. The guide includes a SQL Azure performance checklist to use before and during application development, best practices to optimize applications, and information to mitigate throttling of SQL Azure applications," the Redmond company stated.
"SQL Azure performance guidance can be divided into two distinct categories: optimizing performance of applications running on a single SQL Azure Database and increasing performance of SQL Azure applications by scaling out across multiple SQL Azure Databases," the software company revealed.
Additional information is provided on how to deal with SQL Azure apps throttling as well as with deprovisioning databases to cut costs when usage allows it.
"If an app is running against a single SQL Azure Database, then it becomes particularly important to avoid connection throttling due to excessive resource usage. This document recommends several best practices to optimize performance of applications running against a single SQL Azure Database," the software giant added.
"If an application can make use of multiple SQL Azure Databases, then the application developer should determine how best to leverage SQL Azure's elasticity or the ability to scale-out/scale-in as demand increases and decreases.
"Applications written to take advantage of SQL Azure elasticity can quickly scale out without the requirement of procuring and maintaining additional hardware and software since these resources are maintained in the datacenter for use as needed."
You can download the guide by visiting here.