VMware vExpert and SQL Server performance expert David Klee leads this full-day, hands-on 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 the focus on SQL Server performance.
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.
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