Azure data centers are located worldwide and a team/division MCIO (MicrosoftCloudInfrastructure and Operations) manages all the data centers and its operations. Microsoft divided all the data centers into several regions called “Azure Regions” based on geographic locations. Currently Azure services are available in more than 35 regions around the world and increasing the count rapidly. But all the azure services are not available to each data center, so you have to check the availability of required azure service in the closest region. However there are many parameters need to be consider like cost, redundancy, and network performance etc. because each region have different cost, redundancy option and network performance. So if your requirement is best performance then you can follow below steps before deploying your service otherwise you can compare each parameter region wise.
1)Find the closest region:
To decide where you should deploy your workload, there is a tool Azure speed test that can suggest the suitable region for your workload.
3)If required service is not available in the closest region check for the next closer region.
Affinity Group and Regional Virtual Networks
If you are using old azure portal (Classical portal), there is concept of affinity group. Affinity groups improved performance of multi-tiered applications. Resources that are placed in same affinity group minimize latency between those resources because these resources share same data center. To understand this rack, you have to aware about datacenter architecture.
There are multiple racks in each datacenter. Each rack has 40 to 50 blades and has network switch on top to connect other racks. 20 racks groups together to make a cluster (also called stamp) and all hardware in a cluster uses same processor generation. When all resources are bound to an affinity group, they use same cluster. If you specify the affinity group and create all dependent services in same affinity group, unnecessary network latency avoided and performance will be improved.
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.