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

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

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
  1. June 20, 2012 at 1:52 pm | #1

    I wouldn’t look to me for gdaiunce there It was a long, painful, arduous process.I recently switched to a Mac, so I’ve got MySQL on it. That sort of motivated me to try and gradually move away from SQL Server. Nothing against SQL Server, but for something like this blog there’s no reason not to use a free and readily available solution.So my situation was my blog entries were in a SQL Server database up on a VPS. I wanted to convert them to MySQL here on my local machine.I’ve still got a PC running, so using Enterprise Manager I connected to the remote SQL Server instance, and tried exporting the data to plain text files (to be imported into MySQL). Unfortunately, on a couple of tables that had NTEXT datatypes, the export failed. I spent a while trying to figure out how to get around that, but every avenue I looked into ended up with the same unhappy result.Since all I really needed to do was one database (the one powering the blog), I ended up going the brute force route and simply writing a cfm page that did a SELECT * on each table, then looped over the result and did an INSERT into an empty table in a newly created database on the remote MySQL database.Not particularly elegant, but it got the job done.I’m sure there has to be a better way. If anyone has any suggestions, please feel free to post them. I may be done with migrating the blog over, but you never know when the need to do something like this will arise again.

  1. July 16, 2012 at 10:48 pm | #1
  2. July 17, 2012 at 9:06 pm | #2
  3. July 23, 2012 at 6:16 am | #3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,115 other followers

%d bloggers like this: