SQL in Azure…A Tale of two Deployments (IaaS & PaaS) #AzureSQL #SQLServer

The SQL Deployment Model illustrated in a Nutshell….

 Compare-AzureSQL-SQLServer

Microsoft Documentation Articles:

 

Choose a cloud SQL Server option: Azure SQL (PaaS) Database or SQL Server on Azure VMs (IaaS):

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas

 

Frequently asked questions for SQL Server running on Windows Azure Virtual Machines (SQL as IaaS):

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-faq

 

Frequently asked questions for Azure SQL (SQL as PaaS):

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-faq

Upcoming Readiness Opportunities Around SQL Server 2012 for Service Providers #Hosters #Hosting @msfthost

Courtesy of Microsoft Hosting Community Newsletter

SQL Server 2012: Training and Events

Upcoming Readiness Opportunities Around SQL Server 2012 for Service Providers:

March 5: SQL Server 2012 Launch Prep—Technical Overview for Service ProvidersThis technical overview session will cover what’s coming in Microsoft SQL Server 2012 and review the latest features that Service Providers can leverage in their business. Sales Engineers, Architects, Product Managers, and Database Administrators from Service Providers should attend this session, which will focus on key SQL Server 2012 features and new offerings that hosters can build on top of SQL Server 2012.

March 7: SQL Server 2012 Virtual Launch Event (VLE)The SQL Server 2012 Virtual Launch Event (VLE) will help immerse you in the exciting new world of data with SQL Server 2012. Engage with Microsoft product teams as well as with partners and customers. Discover how SQL Server 2012 enables mission-critical confidence, fast performance, and interactive data visualizations.

March 22:

Service Provider Sales Teams—Positioning SQL Server 2012 with Your Customers Microsoft will conduct training for Service Provider sales teams on how to position SQL Server 2012 with customers. Account Managers, Telesales Teams, and Sales Engineers from Service Providers should attend this session, which will focus on key SQL Server 2012 features—what SKUs will be part of SQL Server 2012 and how these features compare to previous versions of SQL Server.

Additional Training Resources:
On-Demand Training: SQL Server 2012—Overview for Service Providers and SPLA

Webcast: #SQL Server 2012 Overview for Service Providers and SPLA #Hosters #Hosting #SQL2012 #SPLA

About the Microsoft Partner Network Learning Center Webcast…

The new SQL Server edition, SQL Server 2012 is coming soon and will bring exciting opportunities for service provider partners, ISVs and other partners that are purchasing under the Service Provider License Agreement. In particular, partners can benefit with Denali by:
• Enabling mission critical performance and availability at low TCO with high availability features
• Unlocking new insights with pervasive data discovery across the organization
• Creating business solutions fast, on your customers terms across private or public cloud
This is a special training for service providers and SPLA resellers and partners, are all highly encouraged to attend this session.

Register for the event here:
https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&ActivityId=775097

Useful Links: #Clustering on Windows Server 2008/R2 – #SQL Server 2008/R2 Failover Cluster #MSCS

Some useful links I thought I woud share that I found on this topic, conviniently all in one place courtesy of Technet Social High Availability(Clustering Forum)

Failover Clusters in Windows Server 2008
Failover Clusters in Windows Server 2008 R2

Failover Cluster Step-by-Step Guide: Configuring a Two-Node File Server Failover Cluster
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=B9C8D3FB-482C-426E-B3A9-707D6EC77BAD&amp%3Bdisplaylang=en

Getting Started with SQL Server 2008 R2 Failover Clustering
http://msdn.microsoft.com/en-us/library/ms189134.aspx

SQL Server 2008 multi-site cluster on Windows Server 2008 R2
http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-3/

SQL Server 2008 & SQL Server 2008 R2 clustering FAQ’s:
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/30/sql-server-2008-sql-server-2008-r2-clustering-faq-s.aspx

SQL Server 2008 Failover Clustering whitepaper.

#Exchange 2010 & #SQLServer on #VMware Best Practices Guides #SAN Deploy Guide #ISCSI #NFS #NAS

Microsoft Exchange 2010 on VMware Best Practices Guide
Microsoft Exchange 2010 on VMware Best Practices Guide
Microsoft SQL Server  on VMware Best Practices Guide
Microsoft SQL Server on VMware Best Practices Guide
VMware SAN Deployment Guide
VMware SAN Deployment Guide

 

vSphere Online Library:

Fibre Channel SAN Configuration Guide:
http://pubs.vmware.com/vsp40_i/wwhelp/wwhimpl/js/html/wwhelp.htm#href=fc_san_config/esx_san_config_fc.1.1.html

ISCSI SAN Configuration Guide: http://pubs.vmware.com/vsp40_i/wwhelp/wwhimpl/js/html/wwhelp.htm#href=iscsi_san_config/esx_san_config_iscsi.1.1.html

MS Support policy for SQL Server in a virtualization environment (via Virtualisation & Management Blog)

Sharing with all this blog post found on researching this topic, saved me some legwork (Thanks)

SQL Server 2005/ 2008 / 2008 R2 are supported in the following virtualization environments: Windows Server 2008 /R2 with Hyper-V Microsoft Hyper-V Server 2008 / R2 Configurations that are validated through the Server Virtualization Validation Program (SVVP), which includes VmWare and Citrix. Note The SVVP solution must be running on hardware that is certified for Windows Server 2008 to be considered a valid SVVP configuration. Restrictions and Li … Read More

via Virtualisation & Management Blog

Back to #Storage Basics #Exchange2010 #Sharepoint2010 #SQLServer

Block & Bytes

Understand and know the difference between Block Level Data and File Level  Data and  its storage….Its kind of key.
Refresh your memory here

Grasp the  Fundamental  Technologies: NAS Vs SAN (or DAS)

To select the most apppriate technologies such as NAS, SAN or DAS, you need to have a grasp of what each offers over the other. And to do this you first needed to have understood the above.  Some people think they need one, when actually other would suffice, or their workload dicates.
Refresh your memory on NAS / SAN here

Don’t over engineer a solution, think elastic, dynamic and above all be agile to changing demands, and workloads.

Think Billy Connelly Buisness Plan, but replace business needs with  Storage Needs….
We Want this (Size/ Scale/ Growth), and that (Speed/IOPS), plenty of this (lower TCO/ ROI), none of that (latency), none of this (Corruption/failures), and ***** stay awake as demands (workloads / app requirements)  will all be changed…..Billy Connelly Buisness Plan

Mind your Langauage

Learn the differences in the Storage Languages. How do the Storage protocols/ Transport methods stack up… FC vs iSCSI

Refresh your memory here.


RAID & Writes

The thing to remember is Reads will be generally consistent across all RAID Levels (1 IOPS per Read). However, Writes, will may be clearly different (4 IOPS per Write for RAID5)
(this is largely (not wholey) due to distributed parity, performance traded off for fault tolerance)

 RAID 1 Write Penalty

 

IO Impact
IO Impact

 

 

RAID 1 Write Penalty

Two Writes must be performed for every Write operation. Increased Read performance.
Two IOPS per Write Operation

The RAID5 Write Penalty

Because RAID 5 has distributed parity, two Reads and two Writes must be performed for every Write operation. Four IOPS per Write Operation

RAID 1+0

Creates a striped set from a series of mirrored drives. Two IOPS per Write Operation.
Half the RAID 5 Write Penalty, increased Reads.

In a failed disk situation, RAID 1+0 performs better because all the remaining disks continue to be used. The array can sustain multiple drive losses so long as no mirror loses all its drives.

RAID 0+1

Creates a second striped set to mirror a primary striped set.

The array continues to operate with one or more drives failed in the same mirror set, but if drives fail on both sides of the mirror the data on the RAID system is lost.

LUN scaling and performance  

LUN performance will vary according to the disk or configuration of disks upon which they reside, so it is important to consider the physical medium and its characteristics when planning LUNs as part of storage provisioning.

For example, a LUN that resides on a Fibre Channel 15,000 rpm disk will perform better than an identical LUN on a 5,400 rpm SATA disk. Raid configuration also affects performance and reliability, so the characteristics of the RAID type used for LUNs need to be taken into account.

Type of Workload

Sequential or Random Read/ Writes all impact the design descisions. DataBases – OLAP vs OLTP for example….Are you more interested in read performance than write performance. Are you willing to trade performance for Fault Tolerance and Data Integrity.
 

Calculate IOPS Required

Great post here by Scott Lowe

Table below courtesy of Scott’s article

Average IOPS / Drive
Average IOPS / Drive

 

The Right Questions to Ask

Before you can propose a solution you have to know the problem. Ensure happy customers by aligning the technology to the requirements
Know what questions to ask?

Read Storage area network fundamentals – Part 2

Read Storage area network fundamentals – Part 3

#SharePoint2010 Optimising #Storage and #SQLServer Series

Optimizing SQL Server for SharePoint 2010 (part 1)
Optimizing SQL Server for SharePoint 2010 (part 2) – Database Files and Their Location
Optimizing SQL Server for SharePoint 2010 (part 3) – Model Database Settings
Optimizing SQL Server for SharePoint 2010 (part 4) – Pre-Creating Your Content Databases

Related Reading:
Sharepoint 2010 : Optimizing Outside of SQL Server

#SharePoint2010 #Storage and #SQLServer capacity planning and configuration

“This article describes how to plan for and configure the storage and Microsoft SQL Server database tier in a Microsoft SharePoint Server 2010 environment.

http://technet.microsoft.com/en-us/library/cc298801.aspx

If you need a refresher on the basiscs of SQL Server in a Sharepoint Server 2010 environment then below is the link for you. Last updated Aug 27 2010

http://technet.microsoft.com/en-us/library/ff945791.aspx