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.
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.
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.
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
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
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
RAID 1 Write Penalty
Two Writes must be performed for every Writeoperation. 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
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.
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.