Archive

Archive for the ‘SQL’ Category

BISQL # 98 – Introduction of Private Cloud with SQL Server and Hyper-V, Resource Link

May 29, 2012 6 comments

Hi Friends ,

Today i thought of writing something on cloud w.r.t SQL Server, Now day moving on cloud is one of the most important requirement on every organisation.

We have discussed already lot on cloud related stuff , if you have missed can go through on that too in following links :

MSBI # 64 – Cloud # 1– MSBI Cloud Introduction,Need and Cloud on – Inforgrapics

In this article we are going to cover

  • Why private cloud is required
  • What re Private Cloud Drivers
  • Resource Pooling
  • Elasticity
  • Self Service
  • Control & Customize
  • Resource
  • Hyper-V is the best virtualization solution for SQL Server
  • Licensing Cost Comparison – Microsoft and VMware
  • Why Hyper-V is the best virtualization for SQL Server

Why private cloud is required

  • 70% customers are doing/planning private cloud1 -  In short after year or two every one will know power of cloud will use cloud for sure.
  • Adoption of virtualization and cloud computing to increase dramatically in the next 12 months in all domains rapidly
  • Self-services are catching up with virtualization quickly in real world now days
    What re Private Cloud Drivers

There are four main Drivers of private cloud right now

  • Resource Pooling
  • Elasticity
  • Self – Service
  • Control & Customize image

Resource Pooling

With respect to Resource Pooling Following figure will represent steps, Tools and Features for Database consolidation:

image

Key points

  • Understand Isolation/security/HA requirements
  • Determine software edition, version, & hardware requirements
  • Use Consolidation Planning Tool for SQL Server to understand resource requirements
  • Upgrade using SQL Server Upgrade Advisor
  • Migrate using SQL Server Migration Assistant
  • Use P2V to keep existing settings
  • Create new VM to combine multiple apps Benefits
  • Reduce capital expenses – Standardize and consolidate
  • Reduce operational expenses – Improve hardware utilization, Manage IT infrastructure efficiently
  • Green IT – Reduce space and power needs Tools
  • MAP toolkit 5.5
  • Consolidation Planning Tool for SL Server
  • System Center Virtual Machine Manager 2008 R2
  • SQL Server Upgrade Advisor
  • SQL Server Migration Assistant

Elasticity

With respect to Elasticity in cloud following figure will represent steps, Tools and Features for Database consolidation:

image

Key Points

  • IT develops VM templates
  • Build and deploy SQL Server Sysprep templates
  • Minimize planned downtime using Windows Server 2008 R2 Hyper-V Live Migration
  • Manage unplanned downtime with Guest Failover Clustering
  • Increase virtual machine density with Dynamic Memory
  • Virtual machine load balancing with System Center Virtual Machine Manager 2008 R2 Benefits
  • Greater agility – Handle peak load scenarios faster
  • Dynamic Infrastructure – Scale to efficiently meet demands Tools
  • Live Migration
  • Dynamic Memory
  • Guest Failover Clustering
  • System Center Virtual Machine Manager 2008 R2

Self Service

With respect to Self service in cloud following figure will represent steps, Tools and Features for Database consolidation:

imageimage

Key Points

  • Leverage workflow service in SCVMM SSP 2.0
  • Create & assign roles/permissions for business and IT admin
  • Request and build business specific infrastructures (submit & approval)
  • Map infrastructure to existing VM templates
  • Create & retire VMs on-demand Benefits
  • Faster time to market – Automation without compromising control
  • Reduce administration overhead
  • Business units can request resources on demand
    Tools

  • System Center Virtual Machine Manager 2008 R2
  • System Center Virtual Machine Manager Self Service Portal (SCVMM SSP 2.0)

Control & Customize

With respect to Control and Customization in cloud following figure will represent steps, Tools and Features for Database consolidation:

image

Key Points

  • Pre-build infrastructure by IT based on company standard and policy
  • Assign cost recovery model for each virtual machine templates
  • Monitor usage by users through reporting
  • Chargeback to users
  • Monitor & troubleshoot entire stack using SCOM Benefits
  • Enforce and standardize based on policies
  • Measure service – Meter resource usage and charge back to business units
  • Customize for your business needs Tools
  • System Center Virtual Machine Manager 2008 R2
  • System Center Virtual Machine Manager Self Service Portal (SCVMM SSP 2.0)
  • System Center Operations Manager 2007 R2 Management Packs

Resource

Topic – Benefits on SQL Server consolidation/virtualization

Resource  – (Why consolidate) as follows

Resource  – Compare links are as follows

Resource – (How to Plan & Deploy)

Resource – (How to Plan & Deploy)

Resource – (How to Plan & Deploy)

Resource – (How to Plan & Deploy)

Hyper-V is the best virtualization solution for SQL Server

image

Licensing Cost Comparison – Microsoft and VMware

Following explanation is easy enough to understand all .

image

Why Hyper-V is the best virtualization for SQL Server

As we know in current market everyone has started steps towards Cloud computing and many of them already started using SQL server

Which as shown on stats

image 

You may also interested in reading topics like

Hope you will like this post on Optimize SQL Server for Private Cloud.

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

Categories: Link, SQL