Join Me for a NetApp TalkTech on Virtualizing SQL

Join me on Thursday, May 28, 2009 at 11:00am Pacific Time for a discussion on Virtualizing SQL on VMware with Confidence.

Virtualize SQL on VMware with Confidence
What You Should Know and How to Get Started

Join us for a live Webcast and hear how Rick Scherer from San Diego Data Processing Corporation overcame server sprawl by successfully implementing SQL Server® on VMware®.

> Register Now

In addition, experts from NetApp and VMware will host an interactive discussion on best practices that will help you weigh your deployment options. You’ll learn how virtualization solutions can help you:

  • Gain performance advantages when virtualizing SQL.
  • Optimize storage utilization without impacting performance.
  • Implement centralized and cost-effective backup and disaster recovery.

Created on May 21, 2009 by Rick Scherer

Posted under Conferences.

This blog has 2,271 views.

Tags: , ,

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

3 Comments so far

  1. Clay Guthery
    12:24 pm on May 28th, 2009

    Good presentation, thanks for the information Rick! I too am using VMware 3.5 on our NetApp 3140 via NFS and SMVI for backups with SnapMirror to our DR location. I had one lingering question on how you are backing up SQL on the VM’s in turn with SMVI since it does not provide for application consistent snapshots? How do you recover the SQL servers in your DR location in a consistent state? Thanks!

  2. Rick Scherer
    10:48 am on May 29th, 2009

    Hey Clay, thanks for joining us and I’m glad to hear you enjoyed the web-cast.

    You know, DB reliability is hit and miss with SMVI (and VM snapshots for that matter), since VMware Snapshots integrate with the Microsoft VSS driver it should quiesce the database properly — but sometimes it does not.

    In the event that the DB is corrupt in the snapshot, we also have a very solid SQL backup policy. Full backups weekly, Diffs daily and t-logs every hour.

    Depending on your RPO (Recovery Point Objective) you can determine how often you need a snapshot, some of systems have a 30 min. RPO so we need a snap taken every 30 minutes — others are 4 hours.

    If you have any questions, feel free to shoot me an e-mail rick (@) vmwaretips (dot) com

  3. Brian
    7:44 pm on June 2nd, 2009

    I enjoyed the overview of the presentation but some answers where left unanswered for me.

    I have a netapp 3020 with DP setup.
    I have questions regarding placement of the VMDK

    My SQL Server will have three Virtual hardrives.
    1. OS
    2. logging
    3. one for data ( may be RDM)

    Should I create separate LUNS for the placement of the VMDKs or place in one big lun

    Is the os on the raid dp degraded instead of being on raid 1 ?

Leave a Comment

Name (required)

Email (required)

Website

Comments

More Blog Post