SQL Azure Performance in a Multi-Tenant Environment [NZ 2010: COS220]

Download this episode

Download Video

Description

Microsoft SQL Azure presents unique opportunities and challenges with regards to database performance. While query performance is the key discussion in traditional, on-premise database deployments, we show you that factors such as network latency and multi-tenant effects also need to be considered in the Cloud. We offer some tips to resolve or mitigate related performance problems. We also dig deep into the inner workings of how SQL Azure manages resources and balances workload in a massive Cloud environment. The elastic access to additional physical resource in the Cloud offers new opportunities to achieve better database performance in a cost effective manner, an emerging pattern not available in the on-premise world. We show you some numbers that quantify the potential benefits.

Day:

71

Code:

COS220

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.