Jul 232017
 

My slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where I presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let me know if you have any questions! I hope to see you all at the PASS Summit later this year!

Jan 042017
 

Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.

Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Registration is now open here, and seats are limited! Register today!

Nov 012016
 

I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our one-day SQL Server infrastructure and virtualization master class. We are hosting an all-day training session before the end of the year to help you take advantage of quiet(er) times around the holidays. Select from one of the dates that works best for you and register today!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern

Looking to ramp up on the infrastructure and virtualization underneath your databases? Want to learn how to work effectively with the other silos in your IT organization? This live web-based training will help take you to the next level by understanding the architecture, performance characteristics, and performance tuning opportunities of the storage, physical server hardware, virtualization hypervisor, and VM layers underneath your critical SQL Server databases.

David KleeMicrosoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer 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 an enterprise IT strategy for SQL Server.

Course Topics

The following topics will be addressed during the course:

  • Datacenter Fundamentals
  • Infrastructure Stack Fundamentals
  • Storage and SAN Concepts and Design
  • Networking and Interconnect Topologies
  • Physical Server Technologies
  • The SQL Server Virtual Machine
  • 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 infrastructure concepts
  • Determine the optimal infrastructure configuration for best performance
  • Review their own enterprise infrastructure for performance bottlenecks
  • 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 infrastructure-related SQL Server performance killers
  • Understand proper 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 SQL Server and the infrastructure underneath in their own environments.

Seats are limited in this training offering, so register now!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern

Mar 132015
 

I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be launched on Friday, April 10th, the day before the upcoming SQL Saturday event in Madison, Wisconsin. The price is only $100 for the entire day of training!

SQL Server professionals, now is your chance to help bridge the gap between infrastructure and data to help the business maximize your virtualized SQL Server environment. Recommend this session to your VM administrators, and then attend my session at the SQL Saturday event to learn more about how to boost the performance by “right-sizing” your SQL Server virtual machine on Saturday April 11th at 1:00pm in room 313!

Register today for this exciting new pre-conference training session!

Precon Abstract:

Microsoft MVP and VMware vExpert David Klee of Heraflux Technologies leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those infrastructure systems professionals who manage a business-critical virtual SQL Server environment understand the impact of SQL Server on their environments and how to better architect the platform to maximize availability and performance. Participants will gain exposure to the impact of virtualized SQL Server 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. High availability, disaster recovery, multi-tenancy, and performance tuning topics will all be explored during the session.

The following topics will be addressed during the course:

  • What is SQL Server?
  • The SQL Server Virtual Machine
  • Networking, Support, and Licensing
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

Register today for this exciting event at Eventbrite! I look forward to seeing all of you at this event and at the SQL Saturday!

Mar 092015
 

VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… even the best VM admins out there seem to get burned once when they create a snapshot for some routine maintenance and just forget about it afterwards. The VM crashes and goes into a suspended state until free space is added to the datastore.

Sometimes this task is harder than it sounds. If your SAN is out of space, or the SAN management tools are out of your control, you could be stuck.

But… follow a simple trick to give yourself that last little bit of wiggle room in the event that a snapshot fills a datastore.

Add a large text file to the root of the datastore that you can delete if you need headroom! I know it sounds too simple… but it’s simple and effective.

These directions are updated for VMware 5.5 environments, and is validated through vSphere 6.5, but the same concept applies to any hypervisor out there today.

How do you do this?

It’s easy.

Enable the SSH server, and remote into one of the ESXi hosts. This example is from a vSphere 5.5 ESXi server from my home lab.

Change directories into the root of the datastore that you want to create the file in.

snap01

Use the Linux command ‘dd’ to write a 10GB file (or whatever size of your choosing). Basically, we’re creating a file full of zeroes with a 1MB block size and ten thousand blocks. Simple, eh?

dd if=/dev/zero of=snapshotfailsafe.txt count=10000 obs=1M ibs=1M

snap02

It will take a few minutes to create the file. You can see the file creation process with another terminal, and can see the activity in the hosts’ disk performance view in the vSphere Client.

snap03

Once done, you’ll see it in the terminal and in the datastore view screen.

snap04

vmware_snapshot_dd_06

If you have a VMware or Hyper-V snapshot that has filled the drive, just hit the datastore browser and delete the failsafe file! You just gained time to better manage the snapshot or move data around to accommodate the growth.

I know this seems unnecessary, but every VMware admin seems to get burned with a rogue snapshot once. Occasionally, it’s more than once.

How can I prevent actually needing this?

That part is pretty simple, too. Just set up a vCenter alert to warn you if you have a snapshot that is growing out of control! The directions for how to do this are located in this VMware KB article. (Just remember to set up the email server so you actually receive the emails!)

Oct 082014
 

PASS_VC_VirtualizationToday I presented the final ramp up session entitled “Virtualization for SQL Server DBAs 499” for the SQL PASS Virtualization Virtual Chapter. It’s the last session in a four-part where the goal is to take the DBA from knowing nothing about infrastructure and virtualization technologies up to where they can identify specific issues with performance and availability and work directly with the VM administrators – in their nomenclature – to get the VMs stable, highly available, and tuned for maximum performance. This last session worked on common performance troubleshooting scenarios and the quick hits for remediation from both perspectives. The previous session recordings (101-301) are available on my videos page here.

The slides from this session are available for you to download and review. Tom Norman has this 499 session recorded so watch away!

Special thanks goes to Matt Penny (@salisbury_matt) for an absolutely awesome SketchNote!

salisbury_matt sketchnote from twitter

Next it’s on to special topics! In January I will be working with the chapter to present an updated version of my Summit 2014 session – “How to Right-Size Your SQL Server VMs“, and after that, I’m going to be working on a session to demonstrate configuring and using cluster and Availability Groups in a virtual environment. If you have any special topics that you’d like to learn more about and/or see demos of, please let me know! I’m always looking for new ideas for topics, and if it matters to you, it’s guaranteed to matter to someone else, and I’m willing to get a webinar put together to make it happen.