Virtualization for SQL Server DBAs
Event Information
Description
Course Description
Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server
performance.
Intended Audience
The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.
Course Topics
The following topics will be addressed during the course:
- Virtualization and Infrastructure Fundamentals
- Private Cloud Concepts
- The SQL Server Virtual Machine
- Security, Networking, Support, and Licensing
- High Availability and Disaster Recovery
- Performance Investigation and Tuning of the Entire Stack
Course Objectives
Upon completion of this course, attendees will be able to:
- Understand key virtualization and cloud concepts
- Determine the optimal infrastructure configuration for best performance
- Construct a SQL Server virtual machine template with best practices for agility and performance
- Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
- Identify and remediate common virtualized SQL Server performance killers
- Understand proper virtualized capacity management techniques for long term management
Prerequisites
Attendees with the following experiences will benefit the most from this course:
- Basic familiarity with the core components of a server
- SQL Server installation and configuration
- Exposure to SQL Server performance metric measurement and identification
A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with virtualized SQL Server in their own environments.
Please contact David with any questions: dklee@heraflux.com.
About David Klee
David Klee, Microsoft MVP and VMware vExpert, is a SQL Server performance and
virtualization expert. With over seventeen years of IT experience, David spends his
days handling performance and HA/DR architecture of physical and virtualized
mission critical SQL Servers as the Founder and Chief Architect for Heraflux
Technologies. His areas of expertise are virtualization and performance, datacenter
architecture, software engineering, security, and business process analysis. When
not geeking out on database and infrastructure technologies, David enjoys anything
with a motor and is an aspiring amateur photographer. You can read his blog at
davidklee.net, and reach him on Twitter at @kleegeek.
David speaks at a number of national and regional technology related events. The
numerous events include the SQL PASS Summit, IT/Dev Connections, VMware
Partner Exchange, numerous SQL Saturday events, VMware User Groups, SQL PASS
virtual chapter webinars, and many SQL Server User Groups.